Edward Jones ETL Developer

At Edward Jones we are developing a next-generation data architecture to support our growing business. As part of the Data Management area, you will be tasked with provisioning new datasets for analytic and operational use cases, as well as changes to existing loads.  This will bring you into contact with a diverse array of stakeholders ranging from IS to our analytics stakeholders across the firm. 

What you'll do

• Interact directly with requestors from multiple divisions of the firm to understand their documented data requirements


• Recommend an ETL design based on the requirements of the specific use case and provide accurate estimates of effort


• Partner with RDBMS DBAs to understand the source data structures and design of the target structures


• Use the appropriate tools and frameworks available to develop the data acquisition and ingestion process in accordance with the approved design


• Leverage workflow tools to maintain accurate status of assigned tasks (JIRA, etc.)


• Ensure the necessary data validation steps are included to ensure completeness and accuracy of data


• Perform initial validation of the process and inspection of the data


• Utilize the deployment frameworks available to move artifacts from development to test to production environments


• Ensure jobs are scheduled to run on a frequency consistent with stakeholder requirements


• Ensure role-based access is established on target tables


• Support ETL jobs once deployed in production to ensure SLAs are met for data consumers