Analytics Engineer

OEConnection LLC; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

OEConnection LLC is seeking an Analytics Engineer to build and maintain infrastructure for data and business analytics, financial data visualization, and exploratory data analysis. Responsible for managing data systems and ensuring information accuracy to support business operations and requirements.

This position will work with OEC engineers to maintain all the database's safety and security to prevent unauthorized access and potential leaks of confidential data.

Qualifications

• 4+ years of experience in high-volume data management.
• Strong mathematics or statistics background.
• Proficient with SQL, R, Python, DBT, and data modeling.
• Experience with data visualization tools (Tableau/Looker/Power BI) and cloud data platforms.
• Familiarity with data governance and data quality testing.

Responsibilities

• Develop and maintain data infrastructure for analytics at OEConnection.
• Build pipelines to extract data from primary and secondary sources.
• Build and support data visualization for Business and Product needs.
• Define reporting and prepare reports to assist with tracking and goals.
• Analyze parts and application data for trends, patterns, errors.
• Work with Engineers and Software Developers to identify data issues and fix them.
• Build and maintain our data architecture by staging, transforming and finalizing datasets that meet quality standards with testing and QA.
• Develop and document central source of truth for OEConnection and assist in our digital transformation.

Skills

SQL

Python

Database Design

Data Models

ETL Frameworks

Data Mining & Segmentation

Tableau/Looker/Power BI

DBT

AWS Glue

AWS Redshift

Snowflake

Google BigQuery

Excel

Tools

DBT

Tableau

Looker

Power BI

AWS Glue

AWS Redshift

Snowflake

Google BigQuery

Excel

Job description

Job Summary

The Analytics Engineer will help us build and maintain infrastructure for data and business analytics, financial data visualization, and exploratory data analysis. Responsible for managing data systems and ensuring information accuracy to support business operations and requirements. This position will work with OEC engineers to maintain all the database's safety and security to prevent unauthorized access and potential leaks of confidential data.

What You’ll Accomplish:

• Develop and maintain data infrastructure for analytics here at OEC.
• Build pipelines to extract data from primary and secondary sources.
• Build and support data visualization for Business and Product needs.
• Work with business and tech Product Managers to define reporting and prepare reports to assist with tracking and achieving their goals.
• Analyze parts and application data for trends, patterns, errors.
• Work with Engineers and Software Developers to identify potential data issues and help fix them.
• Build and maintain our data architecture by staging, transforming and finalizing datasets that meet our high standards of quality through out of box & custom testing as well as QA and arere used across the organization.
• Develop and document this central source of truth for OEC and assist in our internal digital transformation.

Who You Are

• You are well-versed in Mathematics and/or Statistics.
• You enjoy critical thinking, data-oriented, systematic approaches to solving problems.
• You have 4+ years of experience in high-volume data management.
• You are proficient with most of the following: SQL, R, Python, Database Design, Data Models, ETL Frameworks, Data Mining and Segmentation, Sigma/Tableau/Looker/Power BI, DBT, AWS Glue, AWS Redshift, Snowflake, Google BigQuery
• You are familiar with Excel.
• Other Skills: Data Visualization, Revenue Analysis and Modeling.
• You are articulate. Your communication skills are top-notch, both in writing and verbal.
• Able to keep track of multiple projects concurrently.
• Ability to work independently in an environment that expects great things every day.
• You pride yourself on being tech-savvy. You learn new processes and software tools quickly.
• You’re very detail-oriented and organized. You believe in neatness, and you take pride in a job that is well done!

Why You Should Join Us

Our vision is to make it fast and easy for auto repair shops to find the right parts across all of their suppliers with one search. Together, OEC’s team helped countless businesses save valuable time so they can focus on their customers — and we’re just getting started.

The position is fully remote, with the requirement to attend quarterly in-person meetings.