The Stepping Stones Group, LLC
Lead – Business Intelligence & Data Analytics
The Stepping Stones Group, LLC, Boston, Massachusetts, us, 02298
Lead – Business Intelligence & Data Analytics
The Stepping Stones Group, LLC provided pay range. This range is provided by The Stepping Stones Group, LLC. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range $130,000.00/yr - $140,000.00/yr
Additional compensation types Annual Bonus
The 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. You’ll 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:
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.
Lead a small team of BI developers and analysts, with a focus on mentoring and code reviews.
Work side by side with your team — contributing directly to deliverables while teaching best practices.
Collaborate with stakeholders to translate business requirements into working SQL solutions and BI dashboards.
Set coding standards, enforce data governance, and ensure consistent, reliable output.
Qualifications:
Required:
Bachelor’s degree in Computer Science, Data Science, Information Systems, or related field.
6+ years of hands-on BI and SQL development experience.
2+ years of team leadership or mentoring experience in a BI/analytics environment.
Strong experience writing and tuning SQL (queries, stored procedures, indexing, performance optimization).
Proven experience with ETL processes, data modeling, and data warehousing.
Skilled in building and optimizing Power BI dashboards for executive and operational audiences.
Excellent communicator who can explain technical solutions to both technical and non-technical users.
Preferred:
Experience with Azure Synapse, Data Factory, and Data Lake.
Advanced DAX and T-SQL skills.
Exposure to Python or R for advanced analytics.
Track record of being a hands-on leader, balancing coding with team mentorship.
Supervision Exercised:
Direct guidance and oversight of development staff and contractors.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Hospitals and Health Care
Referrals increase your chances of interviewing at The Stepping Stones Group, LLC by 2x
Inferred from the description for this job
New York, United States $79,700.00-$98,000.00 2 days ago
Greater Boston $60,000.00-$80,000.00 3 days ago
Waltham, MA $58,000.00-$92,000.00 5 days ago
Middlesex County, MA $82,000.00-$100,000.00 2 weeks ago
Medford, MA $60,000.00-$80,000.00 1 week ago
Medford, MA $110,000.00-$125,000.00 2 weeks ago
Data Analyst – Corporate Technology Data Engineering & Analytics Boston, MA $70,000.00-$85,000.00 2 weeks ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Base pay range $130,000.00/yr - $140,000.00/yr
Additional compensation types Annual Bonus
The 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. You’ll 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:
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.
Lead a small team of BI developers and analysts, with a focus on mentoring and code reviews.
Work side by side with your team — contributing directly to deliverables while teaching best practices.
Collaborate with stakeholders to translate business requirements into working SQL solutions and BI dashboards.
Set coding standards, enforce data governance, and ensure consistent, reliable output.
Qualifications:
Required:
Bachelor’s degree in Computer Science, Data Science, Information Systems, or related field.
6+ years of hands-on BI and SQL development experience.
2+ years of team leadership or mentoring experience in a BI/analytics environment.
Strong experience writing and tuning SQL (queries, stored procedures, indexing, performance optimization).
Proven experience with ETL processes, data modeling, and data warehousing.
Skilled in building and optimizing Power BI dashboards for executive and operational audiences.
Excellent communicator who can explain technical solutions to both technical and non-technical users.
Preferred:
Experience with Azure Synapse, Data Factory, and Data Lake.
Advanced DAX and T-SQL skills.
Exposure to Python or R for advanced analytics.
Track record of being a hands-on leader, balancing coding with team mentorship.
Supervision Exercised:
Direct guidance and oversight of development staff and contractors.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Hospitals and Health Care
Referrals increase your chances of interviewing at The Stepping Stones Group, LLC by 2x
Inferred from the description for this job
New York, United States $79,700.00-$98,000.00 2 days ago
Greater Boston $60,000.00-$80,000.00 3 days ago
Waltham, MA $58,000.00-$92,000.00 5 days ago
Middlesex County, MA $82,000.00-$100,000.00 2 weeks ago
Medford, MA $60,000.00-$80,000.00 1 week ago
Medford, MA $110,000.00-$125,000.00 2 weeks ago
Data Analyst – Corporate Technology Data Engineering & Analytics Boston, MA $70,000.00-$85,000.00 2 weeks ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr