ETL Engineer

| St. Louis, MO
Sorry, this job was removed at 7:19 p.m. (CST) on Sunday, May 8, 2022
Find out who's hiring in St. Louis, MO.
See all Developer + Engineer jobs in St. Louis, MO
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

At Edward Jones we are developing a next-generation data architecture to support our growing business. As part of the Operational Data and Integration Portfolio, you will be tasked with provisioning new datasets for MDM and ODS use cases, changes to existing loads and overall data flow scheduling batch, micro batch and real-time.Responsibility Summary:

  • Create and maintain optimal on premise and cloud-based data pipeline architectures capable of ingesting structured and unstructured data using both batch & streaming methods in a secure, scalable, and efficient manner.
  • Assemble large, complex data sets that meet functional and technical requirements.
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources, both internal and external.
  • Develop data flows that can leverage both on premise and cloud architectures.
  • Work with the development team and data stewards to create the business and data quality rules for MDM survivorship rules
  • Work with stakeholders including the business analytics teams and IS architecture teams to assist with data-related technical issues and support their data infrastructure needs.
  • Assist in building out data model with other team members and DBA's. Help to test and fix performance issues.
  • Partner with RDBMS DBAs to understand the source data structures and design of the target structures.
  • Work in a highly efficient and motivated agile based scrum team embracing the product model.


Req ID
60783BR

Position Type
Home Office

Position Schedule
Full-Time

EEO Statement
Edward Jones does not discriminate on the basis of race, color, gender, religion, national origin, age, disability, sexual orientation, pregnancy, veteran status, genetic information or any other basis prohibited by applicable law.

Posting Location
Missouri, St. Louis

Company Description
At Edward Jones, we help clients achieve their serious, long-term financial goals by understanding their needs and implementing tailored solutions. To ensure a personal client experience, we have located our 15,000+ branch offices where our more than 7 million clients live and work.

In a typical branch office, a financial advisor meets with clients and receives branch office support, so they can focus on building deep relationships with clients. Headquarters associates in St. Louis, Tempe and Mississauga provide support and expertise to help U.S. and Canada branch teams deliver an ideal client experience. We continue to grow to meet the needs of long-term individual investors.

Flexible Work Option(s) (Select all that apply)
Remote

Awards and Accolades

  • 2021 FORTUNE 100 Best Companies to Work For® By Great Place to Work® and FORTUNE Magazine - Edward Jones was named No. 20 on the list.
    • From FORTUNE ©2021 FORTUNE Media IP Limited. All rights reserved. Used under license. FORTUNE and FORTUNE 100 Best Companies to Work For are registered trademarks of Fortune Media IP Limited and are used under license. FORTUNE and Fortune Media IP Limited are not affiliated with, and do not endorse products or services of, Edward Jones Investments.
  • 2021 Corporate Equality Index - Edward Jones joins the ranks of 767 major U.S. businesses that received top marks in the Foundation's 19th annual scorecard on LGBTQ workplace equality.
    • From The Human Rights Campaign. All Rights Reserved
  • 2021 Training Top 100 list - Edward Jones ranked No. 19, up six spots from last year in its 21st consecutive year on this prestigious list.
  • J.D. Power, 2021 - Edward Jones has ranked "highest in Employee Advisor Satisfaction among Financial Investment Firms " in the J.D. Power 2021 U.S. Financial Advisor Satisfaction Study.
    • Edward Jones received the highest score among employee advisors in the J.D. Power 2007,2008, 2010, 2012-2015, 2017-2021 Financial Advisor Satisfaction Studies of employee advisors' satisfaction among those who are employed by an investment services firm. Visit jdpower.com/awards for more information.


Search Headquarters Positions by Area of Interest
TECHNOLOGY

Position Requirements

  • 5+ years' experience working in an ETL/ELT role.
  • Experience building Data Management solutions on cloud
  • Working knowledge of cloud-based data pipeline development.
  • Experience building and optimizing data pipelines for acquisition and management of data including data security, metadata capture, data cataloging, classification and data profiling and data quality.
  • Working knowledge of message queuing, stream processing and Change Data Capture mechanisms; relational SQL, NoSQL and Graph databases; Object-oriented/object function scripting languages: Python, Java, Node.js
  • Good verbal and written communication skills, ability to work in a virtual team using zoom or other virtual team communication software.
  • Bachelor's degree in Computer Science, Information Systems or another applicable field is preferred.

Desired skillsets

  • Working knowledge of Informatica MDM or Informatica Data Quality, strongly preferred
  • Data modeling experience
  • Hands on experience with Informatica MDM/RDM, DQ and PowerCenter or IICS
  • Experience using agile development methodology and working within a scrum team.



Colorado Salary Information
At Edward Jones, we value and respect our associates and their contributions, and we recognize individual efforts through a rewards program that promotes a long-term career, financial security and well-being. Visitourcareersite to learn more about our total compensation approach, which in addition to base salary, typically includes benefits, bonuses and profit sharing. The salary range for this role is based on national data and actual pay is based on skills, experience, education, and other relevant factors for a potential new associate:

More Information on Edward Jones
Edward Jones operates in the Fintech industry. The company is located in St. Louis, MO and Tempe, AZ. Edward Jones was founded in 1992. It has 36340 total employees. It offers perks and benefits such as Flexible Spending Account (FSA), Disability insurance, Dental insurance, Vision insurance, Health insurance and Life insurance. To see all 14 open jobs at Edward Jones, click here.
Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Edward JonesFind similar jobs