SSIS (SQL Server Integration Services) Administration

SSIS (SQL Server Integration Services) Administration Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSIS. Monitor and optimize SSIS package performance and troubleshoot failures. Manage SSIS catalog, deployments, and scheduling of packages. Ensure data integrity and accuracy by implementing data validation and error handling mechanisms. Collaborate with database administrators and developers to integrate SSIS with other systems.

Responsibilities

Monitor system health, performance, and availability of BI tools and services

Perform regular backups, updates, and patches for BI tools and related systems

Qualifications Education

Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field

Experience

5+ years of experience in administering and managing Power BI, SSIS, and SSAS

Strong understanding of data warehousing, ETL processes, and BI concepts

Experience with SQL Server, including T-SQL scripting and database administration

Familiarity with data visualization best practices and tools

Experience with cloud platforms (e.g., Azure, AWS) is a plus

Technical Skills

Proficiency in Power BI administration, including Power BI Service and Power BI Report Server

Expertise in SSIS package development, deployment, and troubleshooting

Strong knowledge of SSAS, including cube design, processing, and optimization

Experience with data modeling, DAX, and MDX

Knowledge of data gateways, dataflows, and Power Query

Familiarity with PowerShell scripting for automation tasks

Soft Skills

Strong problem-solving and analytical skills

Excellent communication and collaboration skills

Ability to work independently and manage multiple priorities

Attention to detail and a commitment to data accuracy and quality

Preferred Certifications

Microsoft Certified : Power BI Data Analyst Associate

Microsoft Certified : Azure Data Engineer Associate

Microsoft Certified : SQL Server Database Administration

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Other

Industries

IT Services and IT Consulting

#J-18808-Ljbffr