Cedar Rapids, IA, USA
Full time
R26_0000022394

SUMMARY:

The BI Pricing & Data Analyst designs, develops, and maintains business intelligence solutions while providing foundational pricing analytics and operational support. The role converts enterprise and transactional data into trusted Microsoft Power BI semantic models, reports, dashboards, and actionable insights that support commercial, operational, and leadership decision-making. This position partners with stakeholders to improve pricing visibility, margin performance, data quality, and self-service analytics, and will play an active role in the transition from Qlik Sense to Power BI.

JOB DUTIES:

• Responsible for the end-to-end design, development, deployment, and maintenance of Power BI dataflows, semantic models, reports, dashboards, and visualizations in support of department and business-unit needs.
• Designs, develops, documents, and optimizes scalable data models using Power Query, DAX, and dimensional modeling best practices.
• Meets routinely with stakeholders to understand business questions, define requirements, prioritize work, and translate needs into sustainable analytics solutions, including Power BI reports, Python programs, and Excel-based tools.
• Creates robust, intuitive visualizations and self-service reporting experiences that improve business insight and decision-making.
• Extracts, transforms, validates, and models transactional data from enterprise resource planning (ERP) applications and other source systems for reporting and analytics.
• Supports the migration of existing Qlik Sense applications and QVD-based data processes to Power BI, including requirements mapping, metric reconciliation, testing, documentation, and user adoption.
• Identifies the most effective layout and presentation of key performance indicators, trends, exceptions, and business drivers.
• Partners with IT to establish and maintain Power BI governance and security standards, including workspaces, access controls, row-level security, gateways, refresh schedules, certified content, and sensitive financial data handling.
• Establishes and applies best practices for data modeling, visualization, documentation, performance optimization, and data quality; investigates and resolves reporting discrepancies.
• Monitors scheduled refreshes and report performance, troubleshoots issues, and communicates impacts and resolutions to stakeholders.
• Provides analytical support for routine pricing activities, including price requests, customer and product price reviews, discount analysis, and maintenance of pricing files or tools.
• Analyzes sales, cost, price, volume, mix, and margin data to identify trends, exceptions, leakage, and opportunities for improved profitability.
• Develops and maintains pricing dashboards and recurring reports that provide visibility to price realization, margin performance, discounting, customer/product trends, and adherence to pricing guidance.
• Assists with periodic price updates and commercial planning activities by preparing data, validating calculations, documenting assumptions, and tracking implementation results.
• Partners with Sales, Finance, Product Management, Operations, and Customer Service to research pricing questions, validate inputs, and provide timely, fact-based recommendations within established guidelines.
• Supports the development and maintenance of customer, product, market, and pricing segmentation used in analysis and decision support.
• Performs post-implementation analysis to measure pricing outcomes and highlight variances from expected performance.
• Maintains clear documentation of pricing methodologies, data definitions, recurring processes, and business rules.
• Builds strong relationships with cross-functional leaders and users to improve processes, documentation, analytics adoption, and decision quality.
• Proactively seeks opportunities to expand business knowledge, increase data visibility, automate manual work, and create operational efficiencies.
• Communicates analytical findings clearly to technical and non-technical audiences through written summaries, presentations, and data storytelling.
• Performs other duties as assigned.

EDUCATION & EXPERIENCE

• Bachelor's degree in information systems, business analytics, data analytics, finance, economics, mathematics, statistics, or a related field.
• Typically requires three (3) to five (5) years of related experience in business intelligence, data analytics, pricing analytics, commercial analytics, or an equivalent combination of education and experience.
• Experience working with ERP, sales, pricing, cost, and financial data preferred.
• Experience supporting a BI platform migration or enterprise reporting transformation is preferred.

KNOWLEDGE, SKILLS, ABILITIES

• Proficiency with Microsoft Power BI, including Power Query, DAX, semantic modeling, interactive report development, publishing, refresh management, and security concepts.
• Advanced SQL skills and experience working with relational databases, data warehouses, and multiple data sources.
• Working knowledge of pricing fundamentals, including price realization, discounts, cost-to-serve considerations, gross margin, contribution margin, and price-volume-mix analysis.
• Advanced Microsoft Excel skills; experience with Power Pivot, VBA, or automation tools is beneficial.
• Proficiency in Python, R, or another statistical or programming platform preferred.
• Strong analytical and problem-solving skills with the ability to identify root causes, assess business impact, and propose practical solutions.
• Demonstrated commitment to data accuracy, validation, documentation, organization, and attention to detail.
• Excellent written, oral, and presentation skills, with the ability to explain complex analysis in clear business terms.
• Professional presence and strong interpersonal skills, including the ability to interact with and influence stakeholders at multiple levels of the organization.
• Self-motivated and forward-thinking, with the ability to independently prioritize and manage multiple responsibilities and deadlines.
• Ability to collaborate effectively within a team, constructively challenge assumptions, and build alignment across functions.
• Results-oriented mindset with a focus on continuous improvement, user adoption, and measurable business value.

LICENSES & CERTIFICATIONS:

• Microsoft Power BI Data Analyst Associate (PL-300) certification preferred.
• Additional analytics, data engineering, pricing, or project management certification is beneficial.

COMPANY INFORMATION:

Motion offers an excellent benefits package which includes options for healthcare coverage, 401(k), tuition reimbursement, vacation, sick, and holiday pay.

Not the right fit? Let us know you're interested in a future opportunity by joining our Talent Community on jobs.genpt.com or create an account to set up email alerts as new job postings become available that meet your interest!

GPC conducts its business without regard to sex, race, creed, color, religion, marital status, national origin, citizenship status, age, pregnancy, sexual orientation, gender identity or expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. GPC's policy is to recruit, hire, train, promote, assign, transfer and terminate employees based on their own ability, achievement, experience and conduct and other legitimate business reasons.
Where permitted by applicable law, successful applicants must be fully vaccinated against COVID-19 prior to start date. COVID-19 vaccination is a condition of employment, subject to an approved accommodation, and proof of vaccination will be required on or prior to start date.

GPC conducts its business without regard to sex, race, creed, color, religion, marital status, national origin, citizenship status, age, pregnancy, sexual orientation, gender identity or expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. GPC’s policy is to recruit, hire, train, promote, assign, transfer and terminate employees based on their own ability, achievement, experience and conduct and other legitimate business reasons.See Description