Senior BI Developer: SSAS, SSIS & MDX/DAX Expert

Sonoma Consulting Inc.; New Kensington (Westmoreland County); On-site; USD 90,000 - 120,000; Full time

Job summary

A national IT consulting firm is seeking a Senior BI Developer to design and develop robust business intelligence solutions. The successful candidate will utilize SQL Server and ETL processes to integrate data for comprehensive reporting. Key qualifications include over 10 years' experience in Microsoft BI development and expertise in T-SQL. Strong communication and coaching skills are essential for mentoring BI team members and collaborating with infrastructure teams. This position offers the opportunity to work in a dynamic and professional environment.

Qualifications

• Strong knowledge of relational and multidimensional databases including cubes.
• Ability to coach and mentor BI team members.
• Experience with various versions of SQL Server.

Responsibilities

• Design and develop complete BI solutions using SSIS.
• Implement ETL processes using quality testing.
• Develop training materials for end-users.

Skills

Integrity and Honesty

Commitment to excellence

Accountability

Strong communication skills

Team player

Analytical skills

Education

10+ years of experience related to Microsoft BI development using SSAS

5+ years of experience in writing T-SQL scripts

3+ years of experience related to SSIS

Tools

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

SQL Server Management Studio (SSMS)

Power BI

Job description

A national IT consulting firm is seeking a Senior BI Developer to design and develop robust business intelligence solutions. The successful candidate will utilize SQL Server and ETL processes to integrate data for comprehensive reporting. Key qualifications include over 10 years' experience in Microsoft BI development and expertise in T-SQL. Strong communication and coaching skills are essential for mentoring BI team members and collaborating with infrastructure teams. This position offers the opportunity to work in a dynamic and professional environment.