SSIS (SQL Server Integration Services) Administration

Master-Works; Riyadh; On-site; SAR 120,000 - 160,000; Full time

Job summary

A leading BI solutions provider in Saudi Arabia is seeking an experienced BI Administrator to manage Power BI, SSIS, and SSAS. The ideal candidate will have over 5 years of experience in administering these tools and a strong understanding of data warehousing concepts. Responsibilities include designing ETL processes, monitoring system performance, and providing technical support to users. This role offers a dynamic work environment and opportunities for professional growth.

Qualifications

• 5+ years of experience in administering and managing Power BI, SSIS, and SSAS.
• Strong understanding of data warehousing and BI concepts.
• Familiarity with data visualization best practices and tools.

Responsibilities

• Design, develop, and maintain ETL processes using SSIS.
• Monitor and optimize SSIS package performance.
• Document processes and configurations for BI administration.

Skills

Power BI administration

SSIS package development

Data warehousing

T-SQL scripting

Data modeling

Problem-solving skills

Communication skills

Education

Bachelor’s degree in Computer Science, IT, Data Science, or related

Tools

Power BI

SSIS

SSAS

SQL Server

Azure

Job description

Responsibilities

• 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.

General Responsibilities

• Monitor system health, performance, and availability of BI tools and services.
• Perform regular backups, updates, and patches for BI tools and related systems.
• Document processes, configurations, and best practices for BI administration.
• Provide technical support and training to end-users and stakeholders.
• Collaborate with cross-functional teams to ensure alignment between BI tools and business objectives.
• Stay informed about industry trends and emerging technologies in BI and data analytics.
• Building Analysis Services reporting models
• Migrating Self-Service Reports From Oracle BI and Tableau To Power BI Self-service
• Migrate Reports and Dashboards from oracle BI to Power BI.

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