BI Pricing & Data Analyst – Belting

USA MOT Motion Industries, Inc.; Cedar Rapids (IA); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Healthcare

401(k)

Paid vacation

Job summary

Motion Industries, Inc. is seeking a BI Pricing & Data Analyst to design, develop, and maintain Power BI analytics for pricing, margins, and business insights. You will translate ERP and transaction data into trusted models and dashboards, supporting commercial and leadership decision-making.

You will lead migration efforts from Qlik Sense to Power BI, collaborate across functions, and ensure data quality and self-service analytics adoption. Strong SQL, Excel, and Python/R skills are required.

Qualifications

• Bachelor's degree in information systems, data analytics, finance, economics, mathematics, statistics, or related field.
• Typically 3–5 years of related BI, data analytics, pricing analytics, or equivalent experience.
• Experience with ERP, pricing, cost, and financial data is preferred.

Responsibilities

• Design, develop, deploy, and maintain Power BI dataflows and semantic models.
• Create dashboards and reports to show price realization, margins, and pricing trends.
• Migrate Qlik Sense implementations to Power BI including data mapping and testing.
• Collaborate with Sales, Finance, Product Management, and Ops to answer pricing questions.

Skills

Power BI

SQL

Excel

Python

R

Education

Bachelor's degree in information systems, data analytics, finance, or related field

Tools

Power BI

Qlik Sense

Job description

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 required 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.

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. Since 1928, GPC has set the standards for performance and value for our customers and our stakeholders. Today, we’re proud to say we’re the largest global auto parts network and a leading industrial parts distributor, one that offers rewarding careers that combine small company feel with a global scale. Our strengths are in the relationships we build and the value we deliver by merging local expertise with a global force.