Job details
Job type full-time
Full job description
At edward jones, we help clients achieve their serious, long-term financial goals by understanding their needs and implementing tailored solutionsTo ensure a personal client experience, we have located our 14,000+ branch offices where our more than 7 million clients live and work.
A typical branch office has one financial advisor who meets with clients face-to-face and one branch office administrator who enhances the team`s ability to build deep relationships with clientsHeadquarters associates in stLouis and tempe provide support and expertise to help u.sAnd canada branch teams deliver an ideal client experienceEdward jones currently has more branch offices than any other financial services firm, and we continue to grow to meet the needs of long-term individual investorsAt edward jones we are developing a next-generation data architecture to support our growing businessAs 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 loadsAn etl developer is a type of software engineer that builds and manages the extract, transform, and load processes, implementing technical solutions to do soThis role will meet with a diverse array of stakeholders ranging from is to our analytics stakeholders across the firm.
Responsibility summary:
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.
3+ years of experience in an etl developer role
Bachelor`s degree in computer science, information systems or another applicable field is preferred
Advanced working knowledge of data acquisition frameworks and etl development
Advanced sql coding experience and performance tuning
Linux/unix platform experience
3+ years of experience using the following platforms/technologies:
Etl/elt tools or suites
Relational sql databases
Hadoop and nosql platforms
Desired skills:
Data modeling experience using either sap power designer or erwin tools.
Snowflake cloud based data warehousing platform.
Experience using agile development methodology and working within a scrum team.
Fortune 2020 – edward jones was named no7 on the 2020 fortune 100 best companies to work for® list.
From fortune ©2020 fortune media ip limitedAll rights reservedUsed under licenseFortune and fortune 100 best companies to work for are registered trademarks of fortune media ip limited and are used under licenseFortune and fortune media ip limited are not affiliated with, and do not endorse products or services of, edward jones investments.
Edward jones ranked no6 of the 100 best workplaces for millennials by great place to work and fortune magazine.
2020 corporate equality index – edward jones joins the ranks of 680 major u.s businesses that received top marks in the hrc foundations 18th annual scorecard on lbgtq workplace equality
Edward jones named a top company for training, ranking no25 on training magazine`s 2020 training top 125 list – the highest ranking among the financial-services industry!
Financial services firm edward jones has been named one of the 2019 best workplaces for parents by great place to work and fortune magazineThe firm ranked no5 on the list of 50 companies, up two spots from last year.
The best workplaces for parents list is one of a series of rankings by great place to work and fortune based on employee feedback from great place to work-certified™ organizationsEdward jones ranked no7 on the fortune 100 best companies to work for in 2019 list, the firm’s 20th appearance on the listThe firm also was ranked the no1 best workplace in financial services & insurance and the no6 best workplace for millennials by great place to work and fortune.
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 lawAt 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-beingVisit our career site to learn more about our total compensation approach, which in addition to base salary, typically includes benefits, bonuses and profit sharingThe 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:
