About this role:
Wells Fargo is seeking a Lead Data Engineer to join the Enterprise Service Management (ESM) Data Services team. As part of Enterprise Function Technology (EFT) the Data Services Team helps Enterprise Information Technologies (EIT) and Enterprise Information Securities (EIS) manage IT assets and their associated risks. Our current focus is to maintain and enhance existing solutions, including IT Asset Management Data Mart (ITADM), Vulnerability Remediation Data Warehouse (VRDW) and IT Asset Management Operational Data Stores (ITAM ODS).
Our current technical landscape consists of a typical data architecture leveraging Microsoft / Teradata database technologies and SSIS / Ab-Initio ETL tools. However we will also be embarking on a migration of the aforementioned applications onto cloud based architecture in the coming 12 - 18 months.
In order to meet our strategic goals we have an exciting opportunity for a Lead Data Engineer to join our team. This individual contributor role will providing technical guidance and execution across several Data Services initiatives.
Initial primary focus will be to provide data analysis and support for the IT Asset Management Operational Data Store (ITAM ODS) and will expand to include our cloud modernization efforts. (Google or Azure). In this role, the Principle Data Engineer will be designing, building and operationalizing large-scale enterprise data solutions and applications using one or more data and analytics services in combination with 3rd party cloud and big data platforms.
In parallel to cloud migration we are also assessing our data quality & completeness capabilities. This role may also play a key role in maturing Data Quality within our data portfolio.
In this role, you will:
Initially be responsible to assess downstream Data Enquiries and Enhancement Requests: This encompasses understanding requirements. Determining if data is fit for purpose through data profiling of existing and new sources. Partner with other ETL developers on delivery including pre / post implementation validation.
Lead efforts in Business Requirements analysis, Data Analysis, and Profiling. Being able to receive broad technical guidance of analytical and technology outcomes and constraints, and implement them accurately by providing detailed direction to team resources.
Assisting in defining data strategy particularly in the area of cloud technologies and data quality
Build relationships with SME’s on respective development teams and with business partners. Leverage existing Subject Matter expertise to understand additional insights about business processes and state of the infrastructure.
Utilize excellent data analysis skills to resolve complex Data Requirements.
Develop a broad but detailed understanding of IT Asset Management data, and an intimate knowledge of how it is transformed within all DataMart’s.
Collaborate with application aligned DBA’s, Data Technologies and Infrastructure Architects and Systems Administrators on all aspects of data management.
Make decisions in complex and multi-faceted data engineering situations requiring understanding of software package options and programming language and compliance requirements that influence and lead Technology to meet deliverables and drive organizational change. (Particularly with respect to Cloud migration)
Required Qualifications, US:
- 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 data management experience.
- 5+ years of SDLC (System Development Life Cycle) experience
- 1+ year of PL/SQL experience
- 6+ months of Python experience
- Knowledge and understanding of database architecture, design, and support
- Experience conducting root cause analysis for data-driven process-related improvements
- Strong analytical skills with high attention to detail and accuracy
- 3+ years of experience securing public cloud deployments on Google Cloud Platform (GCP) and / or Azure
- ETL (Extract, Transform, Load) Programming experience
- SSIS or Ab-Initio Experience
- Data Modelling
- GitHub Experience
- Apache Spark design and development experience using Scala, Java, Python or Data Frames with Resilient Distributed Datasets (RDDs)
- Knowledge and understanding of asset management function support
- Ability to develop operational reporting and performing complex data analysis
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, age, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Candidates applying to job openings posted in Canada: Applications for employment are encouraged from all qualified candidates, including women, persons with disabilities, aboriginal peoples and visible minorities. Accommodation for applicants with disabilities is available upon request in connection with the recruitment process.