ETL Engineer-III at Edward Jones
Saint Louis, MO 63190
About the Job
Innovate here. And see your ideas come to life.
It's an exciting time to work in tech at Edward Jones. We are making massive investments in emerging technologies to improve how we work with our clients and with each other. Relationships are the focus of our business model. And working in Technology here means using your skills to build, deliver and maintain the technologies that enable us to deepen and support those relationships. The best part? We develop and create our own industry-leading solutions internally. And you can be a part of it. Working with emerging new technologies. Creating platforms, programs and experiences that change how we work together - and support our client-first focus. Changing the future of our firm, the industry and the advisor-client relationship.
Job Overview
Position Schedule: Full-Time
In 2022, Edward Jones invested $ 1 billion in technology infrastructure, digital initiatives, and virtual business enablement tools. We're currently in the test-and-learn phase and are looking for talented, motivated professionals, that want to be part of this transformational journey. Cloud-based architecture and modern technical capabilities will enable us to grow our impact while providing the best client experience possible.
You may be surprised to know that Edward Jones employs hundreds of software developers - all focused on creating world-class experiences for our clients and branch offices. If you've considered Edward Jones in the past, it's time to take another look. We are embracing a modern, cloud-based architecture and are looking for exceptional individuals who want to be a part of that future.
About the Team
As a Senior Programmer Analyst, you will contribute to the design and support of a future state cloud-based data warehouse architecture that will power Business Intelligence and Advanced Analytics across the firm. This role will support the Data & Analytics area within Edward Jones by ensuring production data pipelines, BI & AA tools and Analytic data platforms remain highly available. Tools used will include SQL, PLSQL, Oracle, DB2, Snowflake, Qlik, Databricks, Matillion and pentaho. This is a technical role.
What you'll do:
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. Visit our career site 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:
Hiring Minimum: $81750
Hiring Maximum: $139194
Skills/Requirements
What You'll Need
Awards & Accolades
At Edward Jones, we are building a place where everyone feels like they belong. We're proud of our associates' contributions to the firm and the recognitions we have received.
Check out our U.S. awards and accolades: Insights & Information Blog Postings about Edward Jones
Check out our Canadian awards and accolades: Insights & Information Blog Postings about Edward Jones
About Us
Join a financial services firm where your contributions are valued. Edward Jones is a Fortune 500¹ company where people come first. With over 8 million clients and 19,000 financial advisors across the U.S. and Canada, we're proud to be privately-owned, placing the focus on our clients rather than shareholder returns.
Behind everything we do is our purpose: We partner for positive impact to improve the lives of our clients and colleagues, and together, better our communities and society. We are an innovative, flexible, and inclusive organization that attracts, develops, and inspires performance excellence and a sense of belonging.
People are at the center of our partnership. Edward Jones associates are seen, heard, respected, and supported. This is what we believe makes us the best place to start or build your career.
View our Purpose, Inclusion and Citizenship Report.
1Fortune 500, published June 2023, data as of December 2022. Compensation provided for using, not obtaining, the rating.
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.
#LI-HO
It's an exciting time to work in tech at Edward Jones. We are making massive investments in emerging technologies to improve how we work with our clients and with each other. Relationships are the focus of our business model. And working in Technology here means using your skills to build, deliver and maintain the technologies that enable us to deepen and support those relationships. The best part? We develop and create our own industry-leading solutions internally. And you can be a part of it. Working with emerging new technologies. Creating platforms, programs and experiences that change how we work together - and support our client-first focus. Changing the future of our firm, the industry and the advisor-client relationship.
Job Overview
Position Schedule: Full-Time
In 2022, Edward Jones invested $ 1 billion in technology infrastructure, digital initiatives, and virtual business enablement tools. We're currently in the test-and-learn phase and are looking for talented, motivated professionals, that want to be part of this transformational journey. Cloud-based architecture and modern technical capabilities will enable us to grow our impact while providing the best client experience possible.
You may be surprised to know that Edward Jones employs hundreds of software developers - all focused on creating world-class experiences for our clients and branch offices. If you've considered Edward Jones in the past, it's time to take another look. We are embracing a modern, cloud-based architecture and are looking for exceptional individuals who want to be a part of that future.
About the Team
As a Senior Programmer Analyst, you will contribute to the design and support of a future state cloud-based data warehouse architecture that will power Business Intelligence and Advanced Analytics across the firm. This role will support the Data & Analytics area within Edward Jones by ensuring production data pipelines, BI & AA tools and Analytic data platforms remain highly available. Tools used will include SQL, PLSQL, Oracle, DB2, Snowflake, Qlik, Databricks, Matillion and pentaho. This is a technical role.
What you'll do:
- Provides 1st level support on our team by applying technical and business knowledge to ensure availability of our systems, and to provide quality solutions for business needs.
- Leverage workflow tools to maintain accurate status of assigned tasks in an agile methodology (JIRA, Service Now, etc.)
- Troubleshoot any issues with jobs based on alerting system
- Ensure scheduled reporting jobs are scheduled to run on a frequency consistent with stakeholder requirements
- Associate will be assigned high priority requests and will need to verify controls are followed to ensure accuracy of output and security.
- Work with developers to correct errors in jobs and processes at the production level
- Review of SQL and ETL processes to tune and fix existing processes
- Develop and review documentation as it pertains to the team
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. Visit our career site 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:
Hiring Minimum: $81750
Hiring Maximum: $139194
Skills/Requirements
What You'll Need
- 4+ years of experience in using or supporting the following platforms or technologies:
- Business Intelligence tools (preferred platforms include Tableau, Power BI)
- Windows/Linux platform experience
- Oracle/DB2 database
- Experience with ETL processes, configuration, scheduling and creating pipelines
- Familiar with SQL and PL/SQL
- Ability to multitask with many different projects and have the knowledge to prioritize the workload
- Be on call in a rotation in the team 24×7
- Familiarity with Cloud technologies
- Ability to work through tier 1 level issues and escalate when needed
- Knowledge of database objects; Oracle, SQL Server, DB2, Pentaho
- Experience with Snowflake, Matillion, Qlik and or Databricks preferred
- Bachelor's degree in Computer Science, Information Systems or another applicable field experience is preferred
- *Candidates that live within in a commutable distance from our Tempe, AZ and St. Louis, MO home office locations are expected to work in the office three days per week, with a preference for Tuesday through Thursday.**
Awards & Accolades
At Edward Jones, we are building a place where everyone feels like they belong. We're proud of our associates' contributions to the firm and the recognitions we have received.
Check out our U.S. awards and accolades: Insights & Information Blog Postings about Edward Jones
Check out our Canadian awards and accolades: Insights & Information Blog Postings about Edward Jones
About Us
Join a financial services firm where your contributions are valued. Edward Jones is a Fortune 500¹ company where people come first. With over 8 million clients and 19,000 financial advisors across the U.S. and Canada, we're proud to be privately-owned, placing the focus on our clients rather than shareholder returns.
Behind everything we do is our purpose: We partner for positive impact to improve the lives of our clients and colleagues, and together, better our communities and society. We are an innovative, flexible, and inclusive organization that attracts, develops, and inspires performance excellence and a sense of belonging.
People are at the center of our partnership. Edward Jones associates are seen, heard, respected, and supported. This is what we believe makes us the best place to start or build your career.
View our Purpose, Inclusion and Citizenship Report.
1Fortune 500, published June 2023, data as of December 2022. Compensation provided for using, not obtaining, the rating.
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.
#LI-HO
