Data Engineer (Data Warehouse Agile Team)

Location
Midvale, Utah
Salary
Open
Posted
Sep 21, 2023
Closes
Oct 22, 2023
Type
Full Time

Zions Bancorporation's 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.

 

We are seeking a Data Engineer to join Zions Bancorporation on our Data Warehouse Agile Team.  As a Data Engineer, you'll 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:

  • Partner with architects, engineers, information analysts, business, and technology stakeholders for developing and deploying enterprise grade platforms that enable data-driven solutions.
  • Demonstrate strong analytical, organizational, and problem-solving skills.
  • Strong focus on long-term strategy, application stability, refactoring, and re-usability.
  • Analyzes and designs technical solutions to address business needs.
  • Develops, tests, and modifies software to improve efficiency of data platforms and applications.
  • Identifies, investigates, and proposes solutions to technical problems.
  • Coordinate with data operations teams to deploy changes into production.
  • Serve in the goalie rotation to support Test, QA, and Production environments.
  • Other duties as assigned

 

Qualifications:

  • Requires a Bachelor's in Computer Science, Computer Engineering, or related field.
  • Experience with Data Warehousing, data technologies and ETL solutions.
  • 4+ years of experience in ETL (IBM Datastage preferred), SQL, UNIX/Linux scripting, and Big Data distributed systems.
  • 3+ years of experience in programming languages like Python, orchestration tools and processes.
  • Experience in building ETL pipelines using Python pandas
  • Exposure in RDD's with Python/Scala using Spark framework.
  • Extensive experience in data migration, data analysis, data transformations, conversion, interface, large volume data loading (ETL techniques), database modeling, and performance SQL tuning. 
  • Experience in leveraging database tools to develop DDL scripts, stored procedures, and functions to create and alter database objects.
  • Experience working with Greenplum, Oracle, SQL Server, DB2, Teradata, Hive and delimited text files would be helpful.
  • Enthusiasm and strong desire to learn and grow within the organization.

 

Preferred skills

  • Experience working with cloud or on-prem Big Data/MPP analytics platform like Google BigQuery, Azure Data Warehouse, or similar
  • Experience with designing and implementing real-time ETL pipelines
  • Experience with data pipeline automation and CI/CD tools like Jenkins
  • Hands on experiences with Git version control processes, data streaming technologies such as Kafka, and unstructured data handling preferred.

 

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 400,000-square-foot technology campus in Midvale, Utah. Located on the former Sharon Steel Mill superfund site, the sustainably built campus will be the company's primary technology and operations center.  This modern and environmentally friendly technology center will enable Zions to continue 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.



Similar jobs

Similar jobs