Principal ETL Engineer

Company: Comerica
Location: Auburn Hills
Posted on: May 6, 2025

Job Description:

Principal ETL Engineer

If you think you are the right match for the following opportunity, apply after reading the complete description.

The Principal ETL Engineer role will provide engineering and architecture support for complex system management activities related to system software, hardware, performance, problem determination or resource management requiring communication and coordination with vendors, technicians, clients, and management. Provide technical input to management decision making in the areas of software, hardware, and performance.

Responsibilities include: performing detailed analysis of various projects and requests; developing designs for projects that have medium to high complexity; formulating procedures; monitoring key performance indicators; and implementing advanced business solutions. The Principal ETL Engineer will collaborate with business partners, technical teams, and product managers to understand the data requirements and provide technical project solutions. Successful candidates will have excellent written and analytical skills; and be able to identify, recommend, improve and document the CICD and change management processes. The Principal ETL Engineer must possess excellent communication and presentation skills to interact with all levels of technology and business teams. Candidates should be available to provide the off-hours support, coordinate with the data teams to lead the production and non-production deployment and validation efforts.

Position Responsibilities:
Design and Methodology

Work closely with business units, application teams, infrastructure areas and vendors to identity, review and evaluate the solution requirements.
Investigate and propose strategic fits for virtualization, consolidation and rationalization solution opportunities within the infrastructure or business. Propose changes to the technical architecture and design solutions as applicable.
Evaluate and align strategic fit solutions across infrastructure platforms and solutions specific to system hardware and software technologies.
Understand, participate, review and influence long term capacity planning and technology investments.

Technical Consulting

Provide Client consulting and planning guidance as applicable for moderate to large highly complex projects/programs.
Provide consultation and works closely with other functional infrastructure areas/departments on multiple initiatives to meet common organizational / business goals and objectives.
Participate in and provides consulting to project teams on architectural, design development, integration opportunities, planning of highly complex systems and assures it is aligned to our established strategies, guiding principles, rationales and practices.

Planning and Organizing

Identify and evaluate projects/programs/initiatives and design processes that enhance and rationalize existing and upcoming solutions.
Map requirements into standard services solution, identify opportunities for integrating to existing or reuse technology and provide cost effective solutions for moderate to large highly complex project/programs/initiatives.
Review, identify and manage requirements for moderate to complex solutions and do a cost value, feasibility and risk analysis.

Risk Management

Review, participate, develop and update architectural standards, guiding principles, rationales and strategies.
Evaluate, review and approve highly complex design solutions for business and Infrastructure project or programs or initiatives.

Position Qualifications:

Bachelor's Degree from an accredited university in computer science, engineering or in a technology related field or equivalent through a combination of education and/or technology experience or 12 years of technology experience
6 years of experience in identifying technical solutions for complex business problems, identifying the benefits and risks of the solutions and providing recommendations
5 years of experience in negotiating complex solutions
5 years of experience in designing complex solutions
5 years of experience in Math, Science or Technology
5 years of experience in technology project management complex, critical projects
5 years of experience in mentoring other technologists
This position is not eligible for sponsorship. Must have indefinite employment authorization.

Preferred Qualifications:

Experience leading and developing automated Informatica data pipelines with at least 2 years Informatica cloud (IDMC) and relevant knowledge in data profiling, data quality, catalog tools
Experience working in enterprise data warehouse solutions and platforms, and working knowledge of different databases (e.g., RDBMS, Snowflake), S3 Datalake, CICD, Jenkins and AWS cloud technologies
5 years of experience designing, implementing automated data solutions, building workflows, developing, and scheduling ETL processes using programming SQL
5 years of experience mentoring another technologist
5 years of experience implementing data solutions by adopting, recommending, and improving CICD, change management, data security, auditing processes
4 years of experience with cross-platform scheduling tools like CA7
4 years of experience with data replication technologies like IBM infosphere data replication or IDMC data replication and synchronization
4 years of experience working with software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes and testing
AWS, Informatica, or Snowflake certification is preferred

Work Best Category:
Category C - Days in the office will either be designated days or will vary week to week from 2-5 days

Hours:
8:00am - 5:00pm Monday - Friday

Salary:
To Be Determined Based on Individual Experience

About Comerica
We know our employees are critical to our overall success and we are dedicated to investing in their future. One of the ways we do this is to offer a comprehensive Total Rewards package designed to recognize and reward individual performance, as well support health, well-being, development and security for our colleagues and their family. Total Rewards consists of cash compensation, development and flexible benefit programs designed to meet individual needs today and in the future. Your salary will be commensurate with your work experience and our programs are reviewed regularly to ensure each remain competitive. We are proud to offer benefits such as health and welfare programs, strong retirement benefits, and generous paid time off programs. You and your eligible family members, including domestic partners and their children, can participate in medical, dental, and vision benefits, 401(k) and pension, income protection benefits such as life insurance, AD&D, and supplemental health programs to offset unexpected health care expenses. We also have a variety of time off programs for things like vacation, sick time, disability, and parental leave. Eligibility for some programs varies based on employment status and tenure.

Upon offer, Comerica conducts a comprehensive background and fingerprint check.

NMLS certification requirement: where applicable, a favorable background check screening, credit check, fingerprint check, and NMLS certification is required in accordance with the SAFE Act.

Comerica Incorporated (NYSE: CMA) is a financial services company headquartered in Dallas, Texas, and strategically aligned into three major business segments; the Commercial Bank, the Retail Bank, and Wealth Management. Comerica's colleagues focus on relationships, and helping people and businesses be successful. In addition to Texas, Comerica Bank locations can be found in Arizona, California, Florida and Michigan, with select businesses operating in several other states, as well as in Canada and Mexico.

Comerica is proud to be an Equal Opportunity Employer - veterans/individuals with disabilities, committed to workplace diversity.

Keywords: Comerica, Waterford , Principal ETL Engineer, Education / Teaching , Auburn Hills, Michigan