Principal Data Engineer Iics & Snowflake Etl Dallas Or Detroit Metro

• 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

• 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.

• 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.

• 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.

• 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.

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 by the Business Bank, the Retail Bank, and Wealth Management. Comerica's more than 9,000 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.