Data Engineer (EDW)
Share
Job Location:
Midvale, UT - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Zions Bancorporations Enterprise Technology and Operations (ETO) team is transforming what it means to work for a financial institution. With a commitment to technology and innovation we have been providing our community clients and colleagues the best experience possible for over 150 years. Help us transform our workforce of the future today.
As aData Engineer youll provide your talents in contributing to the success of the Zions team by delivering all aspects of the software development lifecycle including design coding integration testing deployment operations support and documentation using Agile methodologies. Also able to work independently collaborate with cross-functional teams on technical understanding handle multiple concurrent projects with an ability to prioritize and manage projects effectively with changing priorities.
Responsibilities:
Manage Enterprise Data Warehouse (EDW) and Cloudera data lake production environment and proactively address all production support activities in a timely manner by troubleshooting issues and following up with stakeholders.
Be familiar with code deployment activities between Non-Production and Production environments and coordinate with data operations teams to deploy changes.
Support different data pipelines (real-time batch etc.) executed through the Cloudera data lake environment.
Regularly monitor EDW and Big Data processes to ensure they are running smoothly and efficiently.
Gain and apply knowledge of Control-M Python IBM WebSphere DataStage SQL/Plsql & Unix scripting.
Demonstrate strong analytical organizational and problem-solving skills with a focus on long-term strategy application stability refactoring and re-usability.
Identify investigate and propose solutions to technical problems. Document and track and escalate issues to ensure timely resolution.
Serve in the on-call rotation to support Test QA and Production environments.
Other duties as assigned
Qualifications:
Requires a Bachelors Degree in Computer Science Computer Engineering or related field.
4 years of experience with Data Warehousing data technologies ETL solutions (IBM Datastage preferred) SQL UNIX/Linux scripting and Big Data distributed systems. A combination of education and experience may meet qualifications.
Knowledge of programming languages like Python PySpark orchestration tools and processes.
Knowledge of data migration data analysis data transformations conversion interface large volume data loading (ETL techniques) database modeling and performance SQL tuning.
Experience working with cloud or on-prem Big Data/MPP analytics platform like Databricks Google BigQuery Azure Data Warehouse or similar using Python and PySpark is a plus
Experience with designing and implementing real-time ETL pipelines is a plus
Experience In scheduling and monitoring jobs with using Top tier schedulers like Control-M/Autosys is a plus
Exposure to writing and analyzing complex SQL/ETL scripts is a plus
Experience working with Greenplum Oracle SQL Server DB2 Teradata Databricks Hive and delimited text files would be helpful.
Work Location:
This position has a hybrid work from home schedule with a minimum of three days per week in the office at the new Zions Technology Center in Midvale UT.
The Zions Technology Center is a 400000-square-foot technology campus in Midvale Utah. Located on the former Sharon Steel Mill superfund site the sustainably built campus is the companys primary technology and operations center. This modern and environmentally friendly technology center enables Zions to compete for the best technology talent in the state while providing team members with an exceptional work environment with features such as:
Electric vehicle charging stations and close proximity to Historic Gardner Village UTA TRAX station.
At least 75% of the building is powered by on-site renewable solar energy.
Access to outdoor recreation parks trails shareable bikes and locker rooms.
Large modern cafe with a healthy and diverse menu.
Healthy indoor environment with ample natural light and fresh air.
LEED-certified sustainable building that features include the use of low VOC-emitting construction materials.
Benefits:
Medical Dental and Vision Insurance - START DAY ONE!
Life and Disability Insurance Paid Parental Leave and Adoption Assistance
Health Savings (HSA) Flexible Spending (FSA) and dependent care accounts
Paid Training Paid Time Off (PTO) and 11 Paid Federal Holidays
401(k) plan with company match Profit Sharing competitive compensation in line with work experience
Mental health benefits including coaching and therapy sessions
Tuition Reimbursement for qualifying employees
Employee Ambassador preferred banking products
Apply now if you have a passion for impactful outcomes enjoy working collaboratively with co-workers and want to make a difference for the clients and communities we serve.
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Zions Bancorporation recognizes that its success comes from the dedication, experience, and talents of its diverse employee base. As we usher in the.....
