Hybrid BI Data Analyst: Data Modeling & Dashboards

Motion; Ogden, Northern (UT, KY); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Motion is seeking a BI Data Analyst in Ogden, UT, to design and develop data models and dashboards using BI tools. You will translate stakeholder requirements into robust data solutions, often leveraging ERP data, QVD files, and Python or Excel/VBA reports to drive decision making.

The role emphasizes end-to-end BI lifecycle, collaboration with IT on security, and delivering self-service analytics with intuitive visualizations for leadership and cross-functional teams.

Qualifications

• Typically requires a bachelor's degree in information systems and three to five years of related work experience.
• Proficient with Microsoft Office Suite and advanced SQL across relational databases.
• Strong analytical skills and ability to propose data-driven solutions.
• Excellent written and oral communication, including presentations.

Responsibilities

• End-to-end design and maintenance of BI datasets, data models, reports, dashboards and visualizations.
• Design, develop and optimize data models for the business unit and other departments.
• Meet with stakeholders to understand data needs and deliver BI solutions (dashboards, Python programs, Excel/VBA reports).
• Enhance insights with robust, intuitive data visualizations.
• Leverage ERP data to extract, transform and model for reporting and analytics.
• Collaborate with IT to ensure security standards for BI applications.

Skills

SQL

Python

R

Excel

Data modeling

BI tools

Presentation

Communication

Education

Bachelor's degree in information systems

Tools

QVD files

Job description

Motion is seeking a BI Data Analyst in Ogden, UT, to design and develop data models and dashboards using BI tools. You will translate stakeholder requirements into robust data solutions, often leveraging ERP data, QVD files, and Python or Excel/VBA reports to drive decision making.

The role emphasizes end-to-end BI lifecycle, collaboration with IT on security, and delivering self-service analytics with intuitive visualizations for leadership and cross-functional teams.