Posted 6d ago

Analytics Engineer

@ Miron Construction
Neenah, Wisconsin, United States
$85k-$125k/yrRemoteFull Time
Responsibilities:design models, build transformations, maintain warehouse
Requirements Summary:3+ years’ experience with SQL and data modeling; hands-on with DBT, SQL, star schemas, ETL; proficient with cloud data warehouses (Snowflake, BigQuery, Redshift).
Technical Tools Mentioned:DBT, SQL, Snowflake, BigQuery, Redshift, Power BI, Fivetran, ETL, dimensional modeling
Save
Mark Applied
Hide Job
Report & Hide
Job Description

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.

About Company

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. 

Company

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.