Opportunity Overview 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 contribute to the design of a future state cloud-based data warehouse architecture that will power Business Intelligence and Advanced Analytics across the firm. You will also act as a solutions engineer for new analytics efforts that involve data modeling and delivery. Your designs will account for data movement, storage, compute, BI consumption, and will comply with security and data governance standards. You will work closely with a variety of partners within the Information Systems division, in addition to analytics customers across the firm.
What you'll do - Solution Architecture & Design
- Architect highly resilient and geo-redundant data platforms leveraging Azure Databricks, Snowflake, and Azure Data Lake Storage.
- Design disaster recovery and failover strategies using Azure Availability Zones, geo-redundant storage accounts, and cross-region replication.
- Document architecture using Markdown, GitHub, Erwin Data Modeler, and data flow diagrams.
- Develop reference architectures, reusable patterns, and roadmaps to mature our data architecture practice.
- Understand and translate business requirements to data strategies that align with overall technology vision
- Data Modeling & Engineering
- Create logical (semi-dimensional, dimensional) and physical data models for cloud-based platforms.
- Implement data lakehouse architectures and optimize performance for large-scale analytics workloads.
- Azure Infrastructure & Governance
- Ensure compliance with enterprise data architecture standards, security policies, and cloud governance frameworks.
- Apply Azure best practices for networking, identity, encryption, and monitoring.
- Optimize cost, scalability, and performance of data platforms in Azure.
- Collaboration & Continuous Improvement
- Partner with Product Owners, Analysts, and system/data stewards to understand requirements and upstream processes.
- Identify opportunities to reduce technical debt and modernize technology stacks.
- Participate in solution reviews and provide guidance on cloud-native architecture patterns.
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 9 million clients and 20,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.
Fortune 500, published June 2024, data as of December 2023. 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 - Experience partnering with internal product development teams to ensure the right solutions for potentially large-scale efforts
- Cloud Expertise: Strong hands-on experience with Azure Cloud services, including:
- Azure Databricks, Azure Data Lake Storage, Azure Synapse Analytics
- Geo-redundant storage, Availability Zones, disaster recovery planning
- Azure Key Vault, Azure Monitor, Azure DevOps for CI/CD
- Data Architecture Skills:
- Logical and physical data modeling
- Data warehousing and analytics
- Familiarity with data governance and compliance frameworks
- Proven track record of championing innovation and change, and actively guiding the work of others
- Broad knowledge of data technologies, tools, and disciplines including data modeling, dimensional models, third-normal-form structures, ETL/ELT, change data capture, slowly changing dimensions, and database tuning
- Experience with Snowflake as a Cloud Data Warehousing platform
- Minimum of eight years of experience working in a data-centric development role
- Minimum of five years in data warehouse modeling, design and implementation; experience with OLAP and OLTP
- Minimum of five years of ETL experience
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 preference for Tuesday through Thursday. Current INTERNAL home-based associates: While this role is posted as hybrid,
if selected and accepted, you may retain your home-based status . Edward Jones intends in good faith to continue offering the role as home-based, though future business or regulatory needs may require on-site work.
Salary Information Edward Jones' compensation and benefits package includes medical and prescription drug, dental, vision, voluntary benefits (such as accident, hospital indemnity, and critical illness), short- and long-term disability, basic life, and basic AD&D coverage. Short- and long-term disability, basic life, and basic AD&D coverage are provided at no cost to associates. Edward Jones offers a 401k retirement plan, and tax-advantaged accounts: health savings account, and flexible spending account. Edward Jones observes ten paid holidays and provides 15 days of vacation for new associates beginning on January 1 of each year, as well as sick time, personal days, and a paid day for volunteerism. Associates may be eligible for bonuses and profit sharing. All associates are eligible for the firm's Employee Assistance Program. For more information on the Benefits available to Edward Jones associates, please visit our benefits page.
Never miss an opportunity! Create an alert based on the job you applied for.