Senior BI Developer: Data Warehouse & Tableau Lead (Remote)

Infojini Inc; Glastonbury (CT); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Infojini Inc seeks a Sr. Business Intelligence Developer to design and deliver data warehouse and BI solutions for the Judicial Branch (JB-CSSD).

You will translate business requirements into scalable data models, dashboards, and reports using Microsoft SQL Server BI tools and Tableau. The role emphasizes star-schema data marts, optimized data retrieval, and clear communication with stakeholders to drive insights.

Qualifications

• Minimum 5 years of experience gathering and analyzing business requirements.
• Deep understanding of data warehousing concepts, star-schema design, and slowly changing dimensions (SCDs).
• Minimum 9 years of experience with Microsoft SQL Server, including SQL programming and scripting.
• Minimum 5 years of experience working with data in Excel.
• Minimum 9 years of experience as a database developer.
• Minimum 9 years of experience designing, troubleshooting, and maintaining SSIS packages and SQL Server Agent jobs.
• Minimum 9 years of experience designing, troubleshooting, and maintaining SSRS reports and dashboards.
• Minimum of 2 years of hands-on experience with Tableau or an equivalent BI visualization platform. Tableau certification is preferred.

Responsibilities

• Designing, developing, deploying, and maintaining data warehouse and BI solutions.
• Developing data models, ETL solutions, and BI/analytical content using the Microsoft SQL Server BI stack, including SSRS, SSMS, and SSIS, as well as Excel and Tableau.
• Responding to ad hoc data requests by writing complex T-SQL queries.
• Collaborating with technical and non-technical stakeholders to address complex business challenges.
• Gathering requirements, developing prototypes, conducting testing, and enhancing existing solutions to meet evolving business needs.

Skills

Requirements gathering

Data warehousing concepts

Star-schema design

Slowly changing dimensions

Stakeholder communication

Analytical mindset

Tools

Microsoft SQL Server

T-SQL

SSIS

SSRS

SSMS

Tableau

Excel

Job description

Infojini Inc seeks a Sr. Business Intelligence Developer to design and deliver data warehouse and BI solutions for the Judicial Branch (JB-CSSD).

You will translate business requirements into scalable data models, dashboards, and reports using Microsoft SQL Server BI tools and Tableau. The role emphasizes star-schema data marts, optimized data retrieval, and clear communication with stakeholders to drive insights.