Analytics Engineer

Miron Construction Co., Inc. | Neenah, WI

DEPARTMENT: Information Technology

JOB CLASSIFICATION: Full-Time

FLSA CLASSIFICATION: Exempt

REPORTS TO: IT Director

POSITIONS SUPERVISED: Reporting/Data Warehouse Team

TRAVEL REQUIRED: 15

WORK SCHEDULE: Day Shift

POSITION SUMMARY

The analytics engineer will design, build, and maintain our data warehouse models. They would also transform raw data into reliable, well-documented datasets that power decision-making across the organization.

ESSENTIAL FUNCTIONS

Design and develop DBT models following software engineering best practices.
Build and maintain scalable data transformations in DBT.
Design and implement dimensional data models using star and snowflake schemas.
Build and maintain data transformations that convert operational data into user-friendly datasets.
Integrate data sources (Forma, Procore, Destini, Docusign, Oracle Fusion, etc.).
Create data quality tests and monitoring to ensure reliability.
Create and maintain documentation for data models, business logic, and data history.
Document data models and maintain clear lineage for stakeholders.
Monitor and Optimize Snowflake for cost and performance.
Continue to grow our data governance standards for analytics, access controls, etc.
Mentor/Coach junior analysts on data modeling, SQL, and analytics best practices.
Communicate with stakeholders to drive data-informed decisions.

POSITION QUALIFICATIONS

3+ years’ experience with SQL and data modeling.
Hands-on experience with DBT, SQL, Star schemas, ETL, Power BI.
Proficiency with cloud data warehouses (Snowflake, BigQuery, Fivetran, or Redshift).
Strong understanding of dimensional modeling and data warehouse concepts.
Strong problem-solving skills
Knowledge of role-based permissions, governance, and security best practices.
Experience with version control and CI/CD practices.

WORK ENVIRONMENT

Primarily an office environment.

ADA Demands

The following outlines how much on-the-job time is spent on specific physical activities. Under 1/3 of your time will be spend standing, walking, sitting, using hands to finger, handle or feel, reaching with hands and arms, climbing or balancing, and stooping, kneeling, crouching or crawling. Over 2/3 of your time will be spent talking or hearing. Our office environment requires extensive computer work and use of the phone.

CULTURE AND BENEFITS

For more information on Miron's culture and benefits, please click on the following link: https://miron-construction.com/join-the-team/office-careers/.

Miron Construction Co., Inc. is proud to be an Equal Opportunity / Affirmative Action Employer. We welcome and encourage ALL qualified applicants to apply for our open career opportunities.

At Miron, we:

Create relationships built on honesty, integrity, and respect.
Accept challenges, take the initiative, welcome hard work, and empower one another.
Communicate with transparency at every opportunity, asking questions to gain clarity
and understanding.
Speak up, listen up, and recognize it to strengthen our team and hold one another accountable.
Pursue excellence in our craft and utilize the best tools and processes to deliver safe, quality, and productive construction.
Make sound decisions by focusing on the details, thinking it through, and asking for help when needed.
Fulfill the commitments we make to our clients, our partners, and each other.
Recognize achievements and celebrate successes together.
Represent the best of Miron and the best of ourselves wherever we go.
Serve the communities in which we live and work, giving back whenever and wherever we can.

Learn more about this Employer on their Career Site

Analytics Engineer Lead