Comerica Incorporated
Principal ETL Engineer
Comerica Incorporated, Frisco, TX
Principal ETL Engineer
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
Technical Consulting
Planning and Organizing
Risk Management
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.