Data Warehouse Engineer Job at LeMans Corporation, Janesville, WI

cEhKUXZESGVZN2gxTTdGQlUyTkFQaGF3REE9PQ==
  • LeMans Corporation
  • Janesville, WI

Job Description

Overview

The Data Warehouse Engineer is responsible for building, optimizing, and scaling enterprise-grade data platforms. This position works with the Enterprise Data, Intelligence, and AI Platform teams to drive and maintain scalable data warehousing solutions.

Essential Functions

  • Designs, Builds, and maintains scalable ETL pipelines and data warehousing solutions using primarily Microsoft BI and Azure data stack
  • Analyzes complex data sources and pipelines; performs source-to-target mapping and optimization
  • Provides development for existing systems; troubleshoots data and/or system issues, building and extending toolsets
  • Contributes to data and governance and quality assurance practices across systems including SQL Server, PostgreSQL, MySQL, and Oracle
  • Collaborates with analysts and business stakeholders to support data-driven decision-making
  • Participates in Agile development and peer code reviews
  • Mentors’ other developers and analysts
  • Drives on-going evolution, improvement, and automation of data warehouse solutions
  • Maintains strict confidentiality
  • Performs other duties and/or tasks as assigned

Skills

  • Experience with Azure Data Factory or other cloud ETL platforms
  • Experience with Databricks, PySpark, SparksSQL, and cloud platforms like AWS or GCP preferred
  • Excellent scripting skills in Python or Shell preferred
  • Familiarity with DevSecOps and CI/CD tools similar to Docker and Jenkins preferred
  • Exceptional attention to detail, confidentiality, and integrity

Required Qualification and Education

  • Bachelor’s degree in computer science or related field
  • 7-10 years of experience in data warehousing, ETL, and database development
  • Proficiency in SQL and experience with Microsoft BI stack (SSIS, SSAS, SSRS)
  • Understanding of dimensional modeling, data governance, and performance tuning
  • Travel required up to 5% of the time

Physical Demands

  • Must be able to communicate verbally and written
  • Must be able to read from a screen
  • Must be mobile within an office space to access file cabinets, office and/or computer equipment
  • Must be able to sit for 7+ hours a day
  • Must be able to operate a vehicle for 3+ hours
  • Must be able to travel by air for 8+ hours

Disclaimer

Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

LeMans Corporation is an equal opportunity employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law. LeMans will only employ those who are legally authorized to work in the United States for this opening.

This company participates in E-Verify

Notice to California Employees and Prospective Employees

Job Tags

Similar Jobs

Sam Houston State University

Student Employee-Dept of Art-Graphic Design Lab Assistant Job at Sam Houston State University

 ...Requisition: 202500184ST Title: Student Employee-Dept of Art-Graphic Design Lab Assistant Employee Class: Student Employee College Work Study Position: Yes Department: Dept of Art Division: Division of Academic Affairs Hours per week: 20 Hiring... 

FrankCrum

Business Consultant Job at FrankCrum

 ...Clearwater, Florida. FrankCrum employs approximately 500 people who serve over 4,000 businesses by offering a full range of HR services, including payroll, employee benefits, HR consulting services and workers' compensation insurance. Our PEO is a family culture that... 

Unifi Aviation, LLC

Airport Passenger Service Agent - CHO Job at Unifi Aviation, LLC

General information Job Title Airport Passenger Service Agent - CHO Date Saturday, May 3, 2025 Entity Unifi Aviation, LLC State Virginia City Charlottesville Base Pay Rate: $ 15.15 Full/Part Time...

ChanceLight Behavioral Health, Therapy, & Education

Speech language Pathologist - $10,000 Relocation Bonus Job at ChanceLight Behavioral Health, Therapy, & Education

 ...content areas and instruction. Highly skilled in working with individuals with severe learning, emotional behavioral disorders, autism spectrum disorders, and/or other related disabilities. Well-versed in applied behavior analysis (ABA) including positive behavior... 

Discount Tire/America's Tire

Principal business Systems Analyst - Salesforce (Scottsdale) Job at Discount Tire/America's Tire

The Reinalt-Thomas Corp dba Discount Tire/ Americas Tire has an opening for a Principal Business Systems Analyst Salesforce at our Scottsdale, AZ office.Complete software engineering & documentation w/Salesforce. Mail resumes to: Discount Tire, ATTN: HR/Jen Terhark, 20...