SSIS (SQL Server Integration Services) Administration

<div><ul><li>Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSIS</li><li>Monitor and optimize SSIS package performance and troubleshoot failures</li><li>Manage SSIS catalog, deployments, and scheduling of packages</li><li>Ensure data integrity and accuracy by implementing data validation and error handling mechanisms</li><li>Collaborate with database administrators and developers to integrate SSIS with other systems</li></ul><h3>General Responsibilities</h3><ul><li>Monitor system health, performance, and availability of BI tools and services</li><li>Perform regular backups, updates, and patches for BI tools and related systems</li><li>Document processes, configurations, and best practices for BI administration</li><li>Provide technical support and training to end-users and stakeholders</li><li>Collaborate with cross-functional teams to ensure alignment between BI tools and business objectives</li><li>Stay informed about industry trends and emerging technologies in BI and data analytics</li><li>Building Analysis Services reporting models</li><li>Migrating Self-Service Reports From Oracle BI and Tableau To Power BI Self-service</li><li>Migrate Reports and Dashboards from oracle BI to Power BI</li></ul><h3>Qualifications</h3><h3>Education</h3><ul><li>Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field</li></ul><h3>Experience</h3><ul><li>5+ years of experience in administering and managing Power BI, SSIS, and SSAS</li><li>Strong understanding of data warehousing, ETL processes, and BI concepts</li><li>Experience with SQL Server, including T‑SQL scripting and database administration</li><li>Familiarity with data visualization best practices and tools</li><li>Experience with cloud platforms (e.g., Azure, AWS) is a plus</li></ul><h3>Technical Skills</h3><ul><li>Proficiency in Power BI administration, including Power BI Service and Power BI Report Server</li><li>Expertise in SSIS package development, deployment, and troubleshooting</li><li>Strong knowledge of SSAS, including cube design, processing, and optimization</li><li>Experience with data modeling, DAX, and MDX</li><li>Knowledge of data gateways, dataflows, and Power Query</li><li>Familiarity with PowerShell scripting for automation tasks</li></ul><h3>Soft Skills</h3><ul><li>Strong problem‑solving and analytical skills</li><li>Excellent communication and collaboration skills</li><li>Ability to work independently and manage multiple priorities</li><li>Attention to detail and a commitment to data accuracy and quality</li></ul><h3>Preferred Certifications</h3><ul><li>Microsoft Certified: Power BI Data Analyst Associate</li><li>Microsoft Certified: Azure Data Engineer Associate</li><li>Microsoft Certified: SQL Server Database Administration</li></ul></div>#J-18808-Ljbffr