ETL Engineer-Iii

Opportunity Overview 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 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.

Company Description 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. Awards and 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 Position 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 24x7 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.

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. 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: