Senior Data Analyst; Power BI Consulting or Manufacturing Industry

A Chicago based Global Manufacturing firm is growing their Data team. You will be working with Data from Salesforce and Finance, helping move that into an Azure Data warehouse and working with Power BI to build reports and Dashboards used by Sales, Marketing, Finance and HR. The role will be 1-2 days in office, per month, so living in the Greater Chicago area is required.

• 5+ years working as a Data Analyst and some experience building Data Pipelines
• Prior experience working in a manufacturing company or consulting supporting manufacturing clients
• Experience developing reports & Dashboards in Power BI with large, complex, and/or fragmented datasets.
• Experience in data analysis and interpretation to drive actionable insights.
• Some experience building Data Pipelines with ADF, Fabric or just SQL
• Proficiency with SQL and database administration.
• Advanced Microsoft Excel capabilities performing data cleansing, manipulation, and analysis.
• Understanding of financial concepts and terminology

• Develop and validate internal reporting and data & analytics tools using Power BI and SQL.
• Enhance and update existing reporting and data & analytic tools.
• Provider user support for Power BI reporting tools.
• Work cross functionally across the enterprise to perform business analysis and develop data strategy. In addition, understand context, gather requirements, and provide recommendations to business.
• Participate in data validation and quality assurance testing as well as data health analysis.
• Develop data transformation processes, including data cleansing, normalization, aggregation, and enrichment to prepare data for analytics and reporting.
• Identify and resolve performance bottlenecks in data processing, optimizing query performance, and improve overall data pipeline efficiency.
• Lead database enhancement and data cleaning initiatives.
• Partner with FP&A to identify, design, and implement internal process improvements: e.g., automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.
• Solid understanding of data visualization principles, best practices, and design aesthetics.
• Develop, maintain, and manage advance reporting, analytics, dashboards using Power BI.
• Perform data analysis and validations.

• Define process to enhance data management and control
• Management of new and historical data

This is a full-time direct hire position and is currently not open to C2C or able to sponsors.