Standard Motor Products
Get AI-powered advice on this job and more exclusive features.
Responsibilities
Requirements Gathering: Collaborating with stakeholders and business analysts to understand data and reporting needs, translating these into technical specifications.
Data Preparation and Integration: Extracting, cleansing, and transforming data from various sources (databases, spreadsheets, cloud services, APIs) using Power Query to ensure data quality and integrity.
Data Modeling: Designing and developing robust data models, including creating relationships and hierarchies, to support complex reporting requirements and ensure optimal performance.
Report and Dashboard Development: Building interactive and visually appealing reports and dashboards with KPIs and filtering capabilities using Power BI Desktop.
Advanced Calculations: Using Data Analysis Expressions (DAX) to create complex measures, calculated columns, and tables for in-depth analysis.
Deployment and Maintenance: Publishing reports to the Power BI Service, managing workspaces, configuring data refresh schedules, and troubleshooting issues.
Performance Optimization: Tuning report and query performance to handle large datasets efficiently.
Data Governance and Security: Implementing data governance practices, including role-level security (RLS), to ensure data privacy and compliance.
Qualifications & Experience
Minimum 3-4 years of experience in relational data modeling.
Minimum 3-4 years of experience with Microsoft SQL Server.
Minimum 3-4 years of experience writing DAX in Power BI.
Demonstrated ability to deliver high-impact business intelligence solutions in complex environments.
Knowledge, Skills and Abilities
Extensive knowledge of Power BI Desktop, Power Query, Power BI Cloud Service, and Power BI On-Premise Reporting Service.
Extensive experience writing DAX in Power BI.
Knowledge of BI security best practices.
Education
Bachelor’s degree in Computer Science or Analytics, Operations Research, Mathematics, Statistics or related subject preferred.
Specific work experience considered.
Seniority Level Mid-Senior level
Employment Type Full-time
Job Function Business Development and Sales
Industries Motor Vehicle Manufacturing
#J-18808-Ljbffr
Responsibilities
Requirements Gathering: Collaborating with stakeholders and business analysts to understand data and reporting needs, translating these into technical specifications.
Data Preparation and Integration: Extracting, cleansing, and transforming data from various sources (databases, spreadsheets, cloud services, APIs) using Power Query to ensure data quality and integrity.
Data Modeling: Designing and developing robust data models, including creating relationships and hierarchies, to support complex reporting requirements and ensure optimal performance.
Report and Dashboard Development: Building interactive and visually appealing reports and dashboards with KPIs and filtering capabilities using Power BI Desktop.
Advanced Calculations: Using Data Analysis Expressions (DAX) to create complex measures, calculated columns, and tables for in-depth analysis.
Deployment and Maintenance: Publishing reports to the Power BI Service, managing workspaces, configuring data refresh schedules, and troubleshooting issues.
Performance Optimization: Tuning report and query performance to handle large datasets efficiently.
Data Governance and Security: Implementing data governance practices, including role-level security (RLS), to ensure data privacy and compliance.
Qualifications & Experience
Minimum 3-4 years of experience in relational data modeling.
Minimum 3-4 years of experience with Microsoft SQL Server.
Minimum 3-4 years of experience writing DAX in Power BI.
Demonstrated ability to deliver high-impact business intelligence solutions in complex environments.
Knowledge, Skills and Abilities
Extensive knowledge of Power BI Desktop, Power Query, Power BI Cloud Service, and Power BI On-Premise Reporting Service.
Extensive experience writing DAX in Power BI.
Knowledge of BI security best practices.
Education
Bachelor’s degree in Computer Science or Analytics, Operations Research, Mathematics, Statistics or related subject preferred.
Specific work experience considered.
Seniority Level Mid-Senior level
Employment Type Full-time
Job Function Business Development and Sales
Industries Motor Vehicle Manufacturing
#J-18808-Ljbffr