Senior Business Intelligence Developer

Quantam; Glastonbury (CT); Hybrid; USD 34,000 - 62,000; Full time

Benefits offered by this job

Competitive wages

Health benefits

Paid time off

401(k) plan

Job summary

Quantam Solutions is seeking a Senior Business Intelligence Developer to transform data into actionable insights. You will design and maintain data warehouse solutions, develop star-schema data marts, and build dashboards using Microsoft BI stack and Tableau.

The role starts with two days of onsite training in Glastonbury, CT, then offers a fully remote schedule with hybrid options. Ideal candidates have 5+ years of SQL Server/ETL experience, strong data modeling skills, and the ability to

Qualifications

• Minimum of 5+ years gathering and analyzing business requirements.
• Deep understanding of data warehousing concepts and star schema design.
• Extensive experience building and validating large datasets.
• Proficient in MS SQL Server, SQL, and ETL development.
• Experience designing dashboards and reports with Tableau.

Responsibilities

• Design, deploy, and maintain data warehouse and BI solutions.
• Develop data models, ETL processes, and BI content using MS SQL Server stack and Tableau.
• Respond to ad-hoc data requests by writing complex T-SQL.
• Collaborate with stakeholders to translate business needs into data solutions.

Skills

Data warehousing concepts

Star schema design

ETL development

T-SQL

SQL Server

Excel

Tableau

Data analysis

Communication

Tools

MS SQL Server

SSIS

SSRS

SSMS

Tableau

Excel

Job description

Quantam Solutions provides IT solutions and consulting for various clients. We offer competitive hourly wages, health benefits, paid time off, and a 401(k) plan. We are currently seeking a Senior Business Intelligence Developer. This position requires two days of onsite training (in Glastonbury, CT) and then allows for a fully remote work schedule.

Overview:

Our client is looking for a BI Developer to become an expert at understanding their data to ensure the data aligns with the business goals. They will be responsible for identifying and communicating data trends to business stakeholders. The goal is to aid business stakeholders in drawing insights from data by interpreting and translating business needs into data storage, analysis, and visualization solutions. Need to understand how to develop star-schema datamarts, optimize data retrieval, and how to develop dashboards, reports and other visualizations for stakeholders.

This position requires strong technical skills (such as data development, creation of dashboard/reports) and soft skills (such as communication and business knowledge). Our client utilizes the Microsoft BI stack and Tableau as the primary platforms and systems.

Responsibilities:

• Design, create, deploy, and maintain data warehouse and business intelligence solutions
• Develop data modeling, ETL solutions, and BI/analytical content using Microsoft SQL Server BI stack (SSRS/SSMS/SSIS), Excel, Tableau.
• Respond to ad-hoc data requests for information by writing complex T-SQL
• Collaborate with technical and non-technical stakeholders to solve complex business problems, by gathering requirements, prototyping and testing, or enhancing existing solutions to meet new requirements

Minimum Qualifications:

• Minimum of 5 years’ experience in gathering and analyzing business requirements.
• Thorough understanding of data warehousing concepts, Star Schema design, and slowly changing dimensions.
• Minimum of 5 years’ experience assembling and validating large datasets for research/analysis.
• Minimum of 9 years’ experience with MS SQL Server, including SQL programming and scripting.
• Minimum of 5 years’ experience working with data in Excel.
• Minimum of 9 years’ experience as a database developer.
• Minimum of 9 years’ experience designing, troubleshooting and maintaining SSIS packages and Agent jobs.
• Minimum of 9 years’ experience designing, troubleshooting and maintaining SSRS reports and dashboards.
• Minimum of 2 years’ hands‑on experience working in Tableau or equivalent (Tableau certification preferred).

Additional Information:

• Candidates are required to attend their first two days in person in Glastonbury, CT. Then can work either a hybrid or remote schedule.