Lead Business Intelligence & Data Analytics (Boston)

Stepping Stones Group is looking for a hands-on Lead, BI & Data Analytics to own and drive our data solutions while guiding a small team. This role is perfect for someone who enjoys building complex SQL queries, designing data models, and creating Power BI dashboards while also mentoring others and setting standards. Youll spend much of your time in the code and tools, delivering solutions directly, while also ensuring your team follows best practices and delivers high-quality work.

Primary Responsibilities :

Hands-On Development & Data Engineering :

• Write, test, and optimize SQL queries, stored procedures, views, and functions for high-performance data processing.
• Build and maintain ETL pipelines using SQL Server and Azure Data Factory to ensure clean, reliable, and timely data.
• Design and maintain data warehouse structures and data models that scale with business needs.
• Develop and enhance Power BI dashboards and reports, including DAX calculations and performance tuning.
• Troubleshoot issues across BI, SQL Server, and Azure environments, ensuring stability and accuracy.
• Perform deep-dive data analysis to uncover trends, troubleshoot data anomalies, and provide actionable insights.
• Work daily with Microsoft SQL Server, Power BI, Azure Synapse, Azure Data Factory, and Data Lake.
• Write T-SQL and DAX code to deliver efficient queries and optimized reports.
• Explore and adopt new Microsoft features, including dataflows and advanced analytics integrations, to improve speed and functionality.

Leadership & Collaboration :

Qualifications : Required :

Preferred :

Supervision Exercised :

Direct guidance and oversight of development staff and contractors.