SQL Server BI Developer

Codinix Technologies
East Hartford, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

East Hartford, United States of America

Tech stack

Data analysis
Big Data
Code Review
Data Integrity
ETL
Data Warehousing
Dimensional Modeling
Job Scheduling
Microsoft SQL Server
SQL Stored Procedures
SQL Server Agent
SQL Server Integration Services
SQL Server Analysis Services
T-SQL
Star Schema

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.

Requirements

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

Apply for this position