Power BI & SQL Data Analyst

Mancini Companies • Mansfield, MA

5d • $120,000 - $130,000

About The Position

We are seeking a Power BI & SQL Data Analyst with 5 to 7 years of experience to bridge backend database management and frontend business strategy. The role turns distribution, financial, and supply chain data into actionable visual insights, combining dashboard development with management, querying, and optimization of SQL database architecture.

The analyst will develop and maintain Power BI reports and dashboards; administer Microsoft SQL Server environments; build and optimize T-SQL, DAX, and data models; and create ETL processes for enterprise data. The role also supports finance and accounting analysis, tracks supply chain metrics, collaborates with warehouse, logistics, and department managers, and trains internal users on dashboards and self-service BI tools.

Requirements

• Bachelor’s degree in Business, IT, Computer Science, Finance, or a related field.
• 5 to 7 years of dedicated, hands-on Power BI development experience.
• At least 2 years of hands-on Microsoft SQL Server administration experience, including performance tuning, indexing, and backup management.
• Familiarity with Infor data structures and backend systems, such as Infor M3 (CSDE-Cloud Suite Distribution Enterprise), ION, Datalake, and BIRST.
• Advanced proficiency in T-SQL development, DAX, Power Query, and relational database management systems (RDBMS).
• Ability to work independently, stay self-motivated, and deliver high-quality work within an efficient timeframe.
• Proven experience partnering directly with finance and accounting professionals to interpret financial data structures.
• Strong ability to troubleshoot and optimize large, complex, and sometimes messy datasets.
• Ability to use mainstream AI tools to develop solutions.

Nice To Haves

• Experience analyzing data in flooring distribution, logistics, or wholesale sectors.
• Hands-on experience with Infor M3 data structures or similar enterprise resource planning systems.
• Familiarity with Microsoft Fabric, Azure SQL Database, Azure data tools, or modern cloud data warehousing concepts.
• Familiarity with GitHub or similar repositories for sharing and maintaining codebases.

Responsibilities

• Design, develop, and maintain automated, scalable Power BI reports and dashboards.
• Administer and maintain Microsoft SQL Server environments, including database health, security, user permissions, and performance.
• Write, optimize, and maintain complex T-SQL queries, stored procedures, views, and user-defined functions to extract and manipulate data.
• Create DAX calculations and metrics, and build optimized data models using star schema designs.
• Develop ETL pipelines to clean, transform, and ingest data from enterprise sources using Power Query and advanced SQL.
• Partner with finance and accounting teams to build financial models, P&L views, cost analyses, and variance reports.
• Track and visualize distribution metrics, including inventory turnover, shipping lead times, and freight costs.
• Work with warehouse, logistics, and department managers to understand business problems and deliver data solutions.
• Educate and support internal teams to encourage adoption of dashboards and self-service BI tools.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level