Power BI & SQL Data Analyst

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

We are seeking a Power BI & SQL Data Analyst with 5 to 7 years of experience to join our growing team. In this role, you will bridge the gap between backend database management and frontend business strategy-turning raw distribution, financial, and supply chain data into actionable visual insights. This unique position requires a professional who can not only build stunning visualizations but also manage, query, and optimize the underlying SQL database architecture.

This position requires full-time presence at our corporate headquarters.

Key Responsibilities

• Build Dashboards: Design, develop, and maintain automated, scalable Power BI reports and dashboards.
• Database Administration: Administer and maintain Microsoft SQL Server environments, ensuring database health, security, user permissions, and optimal performance.
• T-SQL Development: Write, optimize, and maintain complex T-SQL queries, stored procedures, views, and user-defined functions to extract and manipulate data.
• Model Data: Create efficient DAX calculations, metrics, and optimized data models using star schema designs.
• Extract & Clean Data: Develop robust ETL pipelines to clean, transform, and ingest data from various enterprise sources using Power Query and advanced SQL.
• Support Finance & Accounting: Collaborate closely with finance and accounting teams to build financial models, P&L views, cost analyses, and variance reports.
• Analyze Supply Chain: Track and visualize key distribution metrics, including inventory turnover, shipping lead times, and freight costs.
• Cross-Functional Collaboration: Work alongside warehouse, logistics, and department managers to understand business problems and deliver comprehensive data solutions.
• Train Users: Educate and support internal teams to ensure high adoption of deployed dashboards and self-service BI tools.

Required Qualifications

• Education: Bachelor's degree in Business, IT, Computer Science, Finance, or a related field.
• Power BI Experience: 5 to 7 years of dedicated, hands-on Power BI development experience.
• SQL Server Experience: Minimum of 2+ years of hands-on Microsoft SQL Server administration experience, including performance tuning, indexing, and backup management.
• Infor M3 Experience: Familiarity with Infor's data structures and backend, such as Infor M3 (CSDE-Cloud Suite Distribution Enterprise), ION, Datalake, and BIRST.
• Technical Skills: Advanced proficiency in T-SQL development, DAX, Power Query, and relational database management systems (RDBMS).
• Work Style: Must be a highly self-motivated professional capable of working independently to produce high-quality deliverables within an efficient timeframe.
• Collaboration Skills: Proven experience partnering directly with finance and accounting professionals to interpret financial data structures.
• Data Competency: Strong ability to troubleshoot, optimize, and work with large, complex, and sometimes messy datasets.
• AI Competency: Ability to use mainstream AI tools to develop solutions.

Preferred Skills

• Industry Knowledge: Experience analyzing data within the flooring distribution, logistics, or wholesale sectors is desirable.
• ERP Experience: Hands-on experience working with Infor M3 data structures or similar enterprise resource planning systems.
• Cloud Architecture: Familiarity with Microsoft Fabric, Azure SQL Database, Azure data tools, or modern cloud data warehousing concepts.
• Coding/Engineering Best Practices: Familiarity with GITHub or similar repositories for sharing and maintaining codebases.