BI Data Analyst

Motion Industries; Birmingham (AL); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Healthcare

401(k)

Tuition reimbursement

Vacation & holidays

Job summary

Motion Industries, in Birmingham, AL, seeks a Business Intelligence Data Analyst to design and develop software-based data modeling and visualizations using BI tools. You will create proactive data models and dashboards to support data-driven decision-making.

You will work on end-to-end BI solutions, leveraging ERP data and QVD files, collaborating with cross-functional leaders to improve processes and governance. Requires a bachelor's degree and 3–5 years of related experience.

Qualifications

• Bachelor's degree in information systems with 3–5 years of related experience.
• Proficient with Microsoft Office Suite and data analysis tools.
• Advanced SQL with experience across relational databases.
• Proficiency in Python, R, or statistics platforms.

Responsibilities

• End-to-end design and maintenance of BI data sets, data models, reports and dashboards.
• Develop and optimize data models and dashboards for business units.
• Meet with stakeholders to translate data needs into BI solutions, dashboards or reports.
• Enhance insights with robust data visualizations and self-service analytics.
• Collaborate with IT to ensure data security and standardization of QVD files.

Skills

Advanced SQL

Python

R

Data visualization

Excel

Analytical skills

Communication

Education

Bachelor's degree in information systems

Tools

QVD files

ERP data sources

BI tools

Job description

Birmingham, AL, USA

Full time

R26_0000027053

SUMMARY

The Business Intelligence Data Analyst designs and develops software-based data modeling and visualizations with Business Intelligence (BI) tools. This role utilizes various analytical and programming skills to develop BI solutions and supports leadership by designing proactive, value-added data models to provide insight into data driven decision-making

JOB DUTIES

• Responsible for end-to-end design and maintenance of BI tool data sets, data models, reports, dashboards and visualizations in support of all department functions,
• Designs, develops and optimizes data models for the business unit and other departments.
• Routinely meets with various stakeholders to understand their data needs. Develops solutions and processes to fulfill requirements. This typically includes BI dashboards, Python programs, or Excel/VBA reports.
• Enhances business insights and decision making with robust, intuitive data visualizations.
• Leverages transactional data from enterprise resource planning (ERP) applications to extract, transform and model into reporting and analytics solutions.
• Coordinates incremental creation and structure of QVD files from disparate data sources.
• Identifies the most impactful layout and presentation of key performance metrics in easy to use self-service dashboards.
• Partners with the IT team to develop security standards for BI applications and usage of QVD files containing sensitive financial information.
• Partners and develops relationships with cross-functional leaders to improve processes and documentation, and recommends changes that lead to the adoption of world class processes.
• Proactively seeks out opportunities to increase business knowledge and create visibility within the organization.
• Generates new ideas to streamline processes and collaborates with other departments to create operational efficiencies.
• Establishes and implements best practices for data modeling & visualization. Ensures data accuracy.
• Performs other duties as assigned.

EDUCATION & EXPERIENCE

Typically requires a bachelor's degree in information systems and three (3) to five (5) years of related work experience or an equivalent combination.

KNOWLEDGE, SKILLS, ABILITIES

• Proficient with Microsoft Office Suite.
• Advanced SQL and experience with a variety of relational databases.
• Strong analytical skills and the ability to propose positive business solutions.
• Reliability, organization and attention to detail.
• Excellent written and oral communication, including presentation skills.
• Knowledge of database design techniques and advanced SQL skills required.
• Proficiency in Python, R, or other statistics platform preferred.
• Professional presence with excellent interpersonal skills, including the ability to interact with management at corporate and department levels.
• Forward-thinking in implementing tools and techniques to improve analytics, driving better business decisions. Self-motivated and able to independently manage multiple responsibilities concurrently
• Ability to collaborate within a team, managing team dynamics and relationships.
• Strong partnership skills, across all levels of management, with ability to influence and challenge decisions and processes.
• Driver of results, developer and influencer of peers.

LICENSES & CERTIFICATIONS

BI tool certification preferred.

COMPANY INFORMATION

• Motion Industries 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.

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.

PI286549466