BI Developer / Analyst

Stoneridge - Novi, MI

Full-time

Novi, MI

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

Stoneridge is seeking a Power BI Developer/Analyst who will play a crucial role in transforming complex data into actionable insights through captivating visualizations. This position requires a professional who can create interactive dashboards and reports across various platforms, including applications, portals, SharePoint, and Microsoft Teams. The ideal candidate will be a data storyteller, adept at analyzing raw data and presenting it in a way that helps the business understand trends and patterns, ultimately enabling informed decision-making. The successful candidate will have a strong background in data and business analysis, with extensive knowledge of the Microsoft Power BI Stack. This role demands analytical skills and excellent communication abilities, as the individual will need to convey complex data insights to stakeholders effectively. A business acumen and problem-solving aptitude are essential for this position, as the candidate will be expected to identify and address data-related challenges. In addition to technical expertise, the Power BI Developer/Analyst will be responsible for collaborating with various teams to bridge the gap between technical and non-technical aspects of the business. The role also involves mentoring others in the design and implementation of visualizations and dashboards, ensuring that the Power BI infrastructure is maintained and up-to-date. This position is ideal for someone who thrives in a fast-paced environment and is eager to contribute to the company's mission of delivering innovative products and systems.

Responsibilities

• Building comprehensive Power BI reports and dashboards that succinctly summarize complex data sets, tailored to client-specific requirements.
• Developing robust data models that support dynamic and scalable reporting solutions.
• Connecting data sources, importing data, and transforming it for business intelligence.
• Creating visual reports, KPI scorecards, and interactive dashboards using Power BI Desktop.
• Ensuring the accuracy and reliability of the data presented in the dashboards and reports.
• Working closely with various stakeholders, bridging the gap between technical and non-technical aspects of the business.
• Leading and mentoring others on design and implementation of visualizations and dashboards.
• Troubleshooting data-related issues and maintaining the Power BI infrastructure to ensure its up-to-date and running smoothly.
• Collaborating with product teams, business data analysis, project management, strategy development, and administrative duties for Power Automate and SharePoint.

Requirements

• 5+ years of experience in data preparation, data gateway, and data warehousing projects in a BI Developer/Analyst role using multiple tools/technologies.
• Proven experience as a Power BI Developer and/or analyst.
• Expertise in optimizing Power BI performance and troubleshooting data integration issues.
• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Background in data model design (e.g. semantic modeling) and data mining.
• In-depth understanding of database management systems, data modelling, Massively Parallel Processing (MPP), ETL (Extract, transform, load) framework.
• Skills needed to analyze data, identify trends, advanced visualization techniques and provide insights that can help drive business decisions.
• Solid understanding of DevOps, DAX, SQL queries, Creating Dashboards and KPI visualizations.
• Proven abilities to take initiative and be innovative.
• Manufacturing experience is preferred.
• Analytical mind with a problem-solving aptitude.
• Familiarity with Agile Methodologies.
• Must be able to work in a fast-paced office environment.
• BSc/BA in Computer Science, or relevant field.
• Must be legally authorized to work in the United States without employer sponsorship of a VISA such as F1, OPT, and H1B status.