Power BI & SQL Data Analyst

Responsibilities

The role involves designing and maintaining automated Power BI dashboards while managing Microsoft SQL Server environments and optimizing T-SQL queries. You will collaborate with finance and supply chain teams to transform raw data into actionable visual insights and support business decision-making.

Requirements

Candidates must have a bachelor's degree and 5 to 7 years of hands-on Power BI development experience. Additionally, at least 2 years of SQL Server administration experience and familiarity with Infor M3 data structures are required.

Skills

• Power BI
• SQL Server
• T-SQL
• DAX
• Power Query
• Data Modeling
• ETL Pipelines
• Database Administration
• Financial Modeling
• Supply Chain Analysis
• Infor M3
• Star Schema
• Performance Tuning
• Data Visualization
• Business Intelligence
• AI Tools

About this role

Job Summary

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.

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.

About Mancini Companies

Wholesale · 2-10 employees · headquartered in West Greenwich, Rhode Island