Job Description

We are seeking a highly skilled SQL Server BI Developer with strong experience in SQL Server, SSIS, and SSAS. The ideal candidate will be responsible for developing and maintaining ETL solutions, building SSAS cubes/tabular models, optimizing SQL performance, and supporting enterprise data warehouse and business intelligence initiatives.

Required Skills

8+ years of experience with Microsoft SQL Server.
Strong hands-on experience with SQL Server Integration Services (SSIS).
Experience developing and maintaining SQL Server Analysis Services (SSAS) Multidimensional Cubes and/or Tabular Models.
Strong expertise in writing complex T-SQL queries, stored procedures, functions, views, and triggers.
Experience with MDX and/or DAX for cube calculations and reporting.
Strong understanding of Data Warehousing, ETL methodologies, Star Schema, and Dimensional Modeling.
Experience with SQL Server Agent, package deployment, and job scheduling.
Experience troubleshooting and optimizing SQL queries, SSIS packages, and SSAS cube performance.
Ability to perform data analysis, validation, and reconciliation.
Experience working with large datasets in enterprise environments.
Strong analytical, problem-solving, and communication skills.
Develop, test, and optimize SQL Server database objects and T-SQL code.
Design, develop, deploy, and maintain SSAS cubes and Tabular models.
Create dimensions, hierarchies, measures, KPIs, and calculated members.
Monitor and optimize SQL Server performance and ETL processes.
Collaborate with business users, data analysts, and development teams to gather requirements.
Ensure data integrity, quality, and accuracy across ETL and reporting solutions.
Participate in code reviews, deployments, and production support activities.

SQL Developer with SSIS

Quick Overview

Job Description

Skills

Similar jobs

Senior Informatica Developer

Full Stack Developer

Endur Developer

Full Stack Engineer

OnBase Administrator/Developer - Remote

Mainframe Developer