Lead Data Engineer

About this role:

Wells Fargo is seeking a Lead Data Engineer to support the IT Management Data Warehouse within the Enterprise Data Environment of the Enterprise Functions Technology (EFT) Group.

EFT provides technology solutions and support for Risk, Audit, Finance, Marketing, Human Resources, Corporate Properties, and Stakeholder Relations business lines. In addition, EFT provides unique technology solutions and innovation for Wells Fargo Technology, Enterprise Shared Services, and Enterprise Data Management. This combined portfolio of applications and tools are continually engineered to meet the challenges of stability, security, scalability, and speed.

Enterprise Service Management (ESM) is a new organization in EFT which represents the integration of the ServiceNow delivery team, IT data, and Governance to provide an unmatched, industry-leading experience for customers and employees alike. ESM’s vision is to empower our teams to work smarter, faster, and more consistently through efficient process, reusable capabilities, and trusted data.  

In this role, you will:

• Act in the technical role an individual contributor and help design solutions for complex computer applications and/or applications initiatives.

• Utilize a thorough understanding of available technology, tools, and existing designs.

• Work on complex problems where analysis of situations or data requires evaluation of intangible variance factors.

• Lead complex multiple modeling, and analysis efforts.

• Act as expert technical resources to Data Engineering staff in the Design, testing, and implementation process.

• Work on complex data initiatives with broad impact and act as key participant in large scale software planning for the Technology area

• Design data services that deliver Strategic Enterprise Risk Management data and help solution and build high performing and scalable data pipeline platform using Hadoop, Ab Initio, EXADATA and Cloud based solutions.

• Perform data analysis and modelling tasks within a data warehouse environment.

• Perform SQL queries to analyze and troubleshoot issues.

• Discover problems in data and applications and design solutions with engineering and product leadership.

• Make decisions in complex and multi-faceted data engineering situations requiring understanding of technology data and data relationships.

• Strategically collaborate and consult with internal partners to resolve highly risky data engineering challenges

• Works quickly and independently to meet required sprint objectives

• Actively participates in cross-team meetings and is excited to share knowledge for broader team improvement

• Strong verbal, written, and interpersonal communication skills

Required Qualifications:

•  5+ years of Database Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

• 5+ years of experience in query or SQL tuning

• 3+ years of experience in performing peer SQL code reviews

• 3+ years of experience in data modelling within a data warehouse environment

• 3+ years of MapR Hadoop, Hive or Oracle SQL Experience

• 1+ years ServiceNow experience

Desired qualifications:

• ETL Experience

• CI/CD Tool Experience

• Autosys experience

• Experience working in an Agile Team

• Understanding of SDLC Requirements

Job expectations:

• Ability to work outside of regular business hours if needed

• This position offers a hybrid work schedule.

• Relocation assistance is not available for this position

• Ability to travel up to 5% of the time

Pay Range
 

Reflected is the base pay range offered for this position. Pay may vary depending on factors including but not limited to achievements, skills, experience, or work location. The range listed is just one component of the compensation package offered to candidates.

Benefits

Wells Fargo provides eligible employees with a comprehensive set of benefits, many of which are listed below. Visit Benefits - Wells Fargo Jobs for an overview of the following benefit plans and programs offered to employees.

• Health benefits
• 401(k) Plan
• Paid time off
• Disability benefits
• Life insurance, critical illness insurance, and accident insurance
• Parental leave
• Critical caregiving leave
• Discounts and savings
• Commuter benefits
• Tuition reimbursement
• Scholarships for dependent children
• Adoption reimbursement

Posting End Date:

*Job posting may come down early due to volume of applicants.

We Value Diversity

At Wells Fargo, we believe in diversity, equity and inclusion in the workplace; accordingly, we welcome applications for employment from all qualified candidates, regardless of race, color, gender, national origin, religion, age, sexual orientation, gender identity, gender expression, genetic information, individuals with disabilities, pregnancy, marital status, status as a protected veteran or any other status protected by applicable law.

Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit’s risk appetite and all risk and compliance program requirements.

Candidates applying to job openings posted in US: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.

Applicants with Disabilities

To request a medical accommodation during the application or interview process, visit Disability Inclusion at Wells Fargo.

Drug and Alcohol Policy

Wells Fargo maintains a drug free workplace.  Please see our Drug and Alcohol Policy to learn more.

Wells Fargo Recruitment and Hiring Requirements:

a. Third-Party recordings are prohibited unless authorized by Wells Fargo.

b. Wells Fargo requires you to directly represent your own experiences during the recruiting and hiring process.