Senior Power BI & SQL Data Specialist

JJ Haines; Mansfield (MA); On-site; USD 90,000 - 130,000; Full time

Job summary

JJ Haines is seeking a Power BI & SQL Data Analyst to bridge backend data management with frontend business strategy. The role turns raw distribution, financial, and supply chain data into actionable visual insights while optimizing the SQL database architecture.

You will build dashboards, administer SQL Server, develop T-SQL, and model data with DAX. Collaboration with finance, logistics, and warehouse teams is key to delivering self-service BI and impactful analytics.

Qualifications

• 5–7 years of dedicated Power BI development experience.
• 2+ years of Microsoft SQL Server administration, including performance tuning.
• Familiarity with Infor M3 data structures (CSDE-Cloud Suite Distribution Enterprise), ION, Datalake, and BIRST.
• Advanced proficiency in T-SQL, DAX, Power Query, and relational database management systems (RDBMS).
• Self-motivated and able to work independently to deliver high-quality results.
• Experience partnering with finance and accounting to interpret financial data structures.
• Strong ability to troubleshoot and work with large, complex datasets.
• Ability to use mainstream AI tools to develop solutions.

Responsibilities

• Design, develop, and maintain automated, scalable Power BI reports and dashboards.
• Administer and maintain Microsoft SQL Server environments, ensuring health, security, permissions, and performance.
• Write, optimize, and maintain T-SQL queries, stored procedures, views, and functions.
• Create efficient DAX calculations and optimized data models using star schema designs.
• Develop ETL pipelines to clean, transform, and ingest data using Power Query and SQL.
• Collaborate with finance to build financial models, P&L views, cost analyses and variance reports.
• Track and visualize distribution metrics such as inventory turnover and freight costs.
• Work with warehouse and logistics to deliver comprehensive data solutions.
• Educate internal teams to adopt dashboards and BI tools.

Skills

Power BI development

T-SQL development

DAX calculations

Power Query

AI tools usage

Self-motivation

Finance collaboration

Data troubleshooting

Education

Bachelor's degree in Business/IT/CS/Finance

Tools

Microsoft SQL Server

Power BI

Infor M3

Power Query

DAX

Job description

JJ Haines is seeking a Power BI & SQL Data Analyst to bridge backend data management with frontend business strategy. The role turns raw distribution, financial, and supply chain data into actionable visual insights while optimizing the SQL database architecture.

You will build dashboards, administer SQL Server, develop T-SQL, and model data with DAX. Collaboration with finance, logistics, and warehouse teams is key to delivering self-service BI and impactful analytics.