Principal Data Engineer - IICS & Snowflake ETL

Welcome!

We invite you to explore the award-winning culture, people, rewards and opportunities that make Comerica Bank so special. Make your next career choice a confident one.

Qualifications

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
• 7 years of experience in identifying technical solutions for complex business problems, identifying the benefits and risks of the solutions and providing recommendations
• 6 years of experience in Technology
• 6 years of experience in Data Engineering, BI Engineering or related field in architecting and developing end-to-end scalable data applications and data pipelines
• 6 years of experience using Informatica with 3 years IICS experience in extracting, transforming/manipulating, and loading data sets using programming (e.g., Python) or querying languages (SQL) and relevant experience in data profiling, data quality, catalog tools
• 6 years of experience working in enterprise data warehouse solutions and platforms, and working knowledge of different databases (e.g., SQL NoSQL), S3 Datalake, CICD, Jenkins and AWS cloud technologies
• 5 years of experience mentoring another technologist
• 4 years of experience using Snowflake in extracting, transforming/manipulating, and loading data sets using programming SQL or Python
• 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
• This position is not eligible for sponsorship. Must have indefinite employment authorization.
  
  
  

Licenses/ Certifications:

• Amazon Web Services (AWS) Solutions Architect Associate
• Preferred, Informatica Data Management Cloud Certification - Developer or Administration
  
  
  

Job Description

PRINCIPAL DATA ENGINEER

The Principal Data Engineer (IICS Snowflake ETL) will provide data engineering and architecture support for complex Data 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 leading, architecting and building highly available, scalable, stable, secure and cost-effective end-to-end data pipelines, 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 Data Engineer will develop strong collaborative relationships with key technology and data teams and will be responsible for data modeling, applying data quality rules standards, leveraging the latest technologies, and performing proof-of-concept tasks to evaluate new data systems, products, and data source performance. This role will also assist development teams, troubleshoot with data ingestion, and manage ELT/ETL extraction needs and issues. The ideal candidate will have Banking and finance data knowledge, regulatory data reporting experience is a plus.

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, identity 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.
  
  
  

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.

#J-18808-Ljbffr