Share this Job

At Gentherm, we say, “It’s about the person.” We’re with you on a cold winter day when you turn on your heated seat and steering wheel or helping manage patient body temperature in the operating room, recovering room or intensive care units. We take a human approach with everything we do.

 

As the global leader in thermal management technologies we embrace the opportunity to create and deliver extraordinary thermal solutions that make meaningful differences in everyday life. We do this by improving health, wellness, comfort and energy efficiency.

 

We embrace an entrepreneurial spirit and combine that with our global leadership to deliver results. Working at Gentherm provides you the opportunity to not only shape the future of the automotive and medical industries, but also influence your career throughout the company. You will be engaged, challenged and inspired by our team to deliver leading thermal technologies that positively impact lives around the world.

IT Developer, BI & ETL

IMPACT and OPPORTUNITY

 

The IT Developer, BI & ETL will be responsible for defining, articulating, developing, implementing, and realizing our Information and data analytics strategy to meet the strategic IT goals of Gentherm. This role will involve a broad spectrum of applications, information, technical, data, reports, and business architectures with an Enterprise focus across a global group of stakeholders.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

  • Serve as a subject matter expert of Gentherm’s Information and data analytics program, defining and implementing best practices, standards, and processes to ensure alignment with the design and development strategy and goals of the business
  • Collaborate with key stakeholders to ensure data engineering solution alignment with key portfolio initiatives based on cost, functionality, and practicality
  • Involve in the design of the technical and information architecture for the data warehouse, proposing holistic innovative solutions from a working comprehension of the ‘as-is ‘functionality across the enterprise. This extends to all information structures (staging area, data lake, data pipelines, data marts, and operational data stores).
  • Participate in development and maintenance of the database architecture and recommend solutions to business needs including creating structure where none exists for reporting/analytics database solutions using modern techniques and programming language
  • Expertise in data quality and effective use of available information
  • Develop and support various ETL/ELT processes and prepare OLAP cubes, troubleshoot ETL processes and resolve issues effectively.
  • Analyze all data warehouse development goals and identify skill requirement for same.

OTHER CORE FUCNTIONS

  • Conceptualize, assist, design, develop and support the solution for integrating Master Data Management Domains and BI.
  • Define, design, maintain and support architecture models, frameworks, and artifacts (e.g., current, and future state application architecture diagrams, data models, etc.)
  • Identify and promote best practices and patterns for data modeling and provide oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies.
  • Develop and deliver data solutions as well as expand their awareness of technology aspects of the enterprise
  • Help develop and deliver multi-year DWH modernization roadmap plans in partnership with the IT team

QUALIFICATIONS

MINIMUM QUALIFICATIONS:

  • Bachelor’s degree in Information Systems, Information Technology, Computer Science, Finance or Engineering (or a high school diploma/GED with at least 3 years of experience in the application of information technologies to business solutions)
  • 3+ years of experience serving as a Data Warehouse and data solutions of large IT projects/programs and/or similar role in a large, complex organization
  • Minimum 3+ years of experience with various technology and application integration projects
  • Minimum 3+ years of experience in with process improvements or data solutions implementations
  • Hand-on experience working within SQL Server database, SQL, SSMS, ETL SSIS, T-SQL, Data Pipeline, CI/CD Flow, Visual Studio (SSDT), Azure Cloud and BI Platforms like Power BI, Tableau is a plus
  • At least 5 years’ overall experience in IT with Application Development, Data Analytics, Data Warehousing and BI; Solution Delivery - hands-on from a solution development perspective

PREFERRED QUALIFICATIONS

  • Current Hands-on experience with or conceptual understanding of SQL, ETL SSIS, PowerBI, SSAS, SSRS, ADLS, Synapse Analytics, ELT, Azure Synapse Pipeline, ADF, CI/CD Flow (Visual Studio SSDT), .Net App, PowerApps, Azure DevOps, Bit Bucket, Gits & Modern Data Technologies on Microsoft/Open-Source technology stack
  • Experience in leading an enterprise development workstream involving several systems and diverse skillsets in a global company
  • Hands-on experience designing, implementing, and deploying ETL SSIS, Power BI dashboards and integrating it with backend Data Warehouse, both on-prem SQL Server and Azure cloud, based on the data visualization needs of the business
  • Experience with enterprise applications like SAP ERP, CRM etc.
  • Demonstrated ability to lead and drive change in a complex matrix environment
  • Tier 1 Automotive supplier experience

COMPETENCIES

 

  • Deliver Results
    • Understand the mission and output of your team; set SMART objectives and deliver
  • Drive Change
    • Focus on agility and commitment to continuous improvement; Understand and act on internal and external drivers of change
  • Build Capability
    • Foster a culture of learning and development; Support individual growth through continuous feedback to achieve personal and professional goals
  • Cultivate Innovation
    • Openly embrace, create, implement and support new and innovative ideas, processes and technology that deliver business results

 

#LI-TO1

PHYSICAL DEMANDS/WORK ENVIRONMENT

All positions in our office require interaction with people and technology while either standing or sitting. In order to best service our customers, internal and external, all associates must be able to communicate face-to-face and on the phone with or without reasonable accommodation. Gentherm is committed to compliance with its obligations under all applicable state and federal laws prohibiting employment discrimination. In keeping with this commitment, it attempts to reasonably accommodate applicants and employees in accordance with the requirements of the disability discrimination laws. It also invites individuals with disabilities to participate in a good faith, interactive process to identify reasonable accommodations that can be made without imposing an undue hardship.

Gentherm is an Equal Opportunity Employer.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, genetic information, sexual orientation, gender identity, disability or protected veteran status.

Job Req ID:  8384
Location: 

Northville, MI, US, 48167

Country/Region:  US
Published:  Jun 23, 2022


Nearest Major Market: Detroit

Job Segment: Data Warehouse, ERP, ICU, Surgery, Computer Science, Technology, Healthcare