Analytics Engineer

Location: Grand Rapids, MI

Department: IT

Summary of Position:

The Analytics Engineer serves as a bridge between data engineering and analytics by building and improving data pipelines, analytical datasets, and reporting-ready data models. This role is designed for an early-career professional who wants to grow at the intersection of data engineering and analytics, with a strong emphasis on SQL-driven data transformation, pipeline reliability, and analytics-ready data modeling.

The position works closely with the Data Engineer, BI Developer, and BI Manager to ingest new data sources, transform and structure data for reporting and analytics, and improve the reliability, performance, and documentation of the analytics platform. Over time, this role is expected to grow into increased ownership of production datasets, data quality monitoring, and pipeline optimization, and semantic modeling.

Essential Job Functions:

• Write and maintain SQL transformations used to clean, standardize, and model data for reporting, analytics, and self-service use cases.

• Assist in managing database objects such as tables, views, schemas, and transformations used by reporting and analytics tools.

• Help build and maintain structured data layers (e.g., raw, cleaned, and reporting layers).

• Work with the Data Engineer to onboard new data sources using a modern analytics stack.

• Create and maintain curated datasets and reporting tables consumed by Power BI and other internal tools.

• Perform data validation and reconciliation to ensure accuracy and reliability.

• Assist in developing data quality checks, monitoring, and alerting.

• Troubleshoot data issues and support root cause analysis.

• Document data pipelines, transformations, business logic, and data lineage.

• Contribute to experimentation and adoption of AI-driven tools or models to enhance analytics, data preparation, and insight generation.

Knowledge, Skills and Abilities:

· Foundational SQL skills for querying, transforming, and validating data.

· Basic understanding of data modeling concepts for reporting and analytics.

· Enthusiasm and ability to learn cloud-based data platforms and modern analytics tools.

· Strong attention to detail and commitment to data accuracy.

· Analytical mindset with the ability to ask good questions and investigate data issues.

· Clear communication skills and comfort working with both technical and non-technical stakeholders.

Qualifications

· 1–3 years of relevant experience in data analytics, business intelligence, data engineering, or a related role.

· Bachelor’s Degree or equivalent experience in computer science, information systems, engineering, mathematics, business, or a related field.

· Experience working with SQL and relational databases.

· Exposure to reporting or analytics tools such as Power BI, Tableau, or similar platforms.

Preferred Qualifications

• Exposure to ETL/ELT concepts or analytics transformation frameworks.

• Familiarity with cloud-based data platforms (Azure preferred).

• Experience with data ingestion or orchestration tools.

• Interest in data quality, automation, and scalable analytics.

• Curiosity about AI or advanced analytics techniques.

First 90 Days

• Gain a working understanding of existing data pipelines, data sources, and reporting datasets.

• Document key data pipelines, transformations, and data lineage

• Support recurring data processes independently with guidance.

• Build or enhance at least one production analytics dataset.

• Implement basic data validation or quality checks.

Growth Path (Internal Expectation)

This role is expected to grow over time into greater ownership of data pipelines, data modeling, quality monitoring, and performance optimization, evolving toward a full Analytics Engineer role as skills and experience develop

Key Benefits:

In addition to your base compensation, we offer a competitive benefits package that includes monthly bonus opportunities, Medical/Rx, Dental, and Vision coverage, a retirement plan (401-k) with a percentage match, flexible spending accounts, health savings accounts, an employee assistance program, and several other benefit options. 

Enroll in benefits coverage that is effective on your first day of employment! Further details on the benefits program are available upon request.