Data Engineer

Vanguard Malvern , PA 19355

Posted 2 months ago

Want to work in an exciting, cutting-edge space? Do you like a fast-paced work environment?

Want a front-row seat to Vanguard's Engine 2! Then this is the job for you. Support the development and delivery of AI/ML- driven Advice products and our Advice Data as an Asset initiatives.

Provide expertise and services to drive advice data enablement to support the Data Engineering, Data Scientist and AI/ML teams. Identify and implement data quality rule while working with data management and analytics groups across the organization to drive and deliver business value.

Core Responsibilities

  • Writes ETL (Extract / Transform / Load) processes, designs database systems, and develops tools for real-time and offline analytic processing.

  • Troubleshoots software and processes for data consistency and integrity. Integrates data from a variety of sources for business partners to generate insight and make decisions.

  • Translates business specifications into design specifications and code. Responsible for writing programs, ad hoc queries, and reports. Ensures that all code is well structured, includes sufficient documentation, and is easy to maintain and reuse.

  • Partners with internal clients to gain a basic understanding of business functions and informational needs. Gains working knowledge in tools, technologies, and applications/databases in specific business areas and company-wide systems.

  • Participates in all phases of solution development. Explains technical considerations at related meetings, including those with business clients.

  • Tests code thoroughly for accuracy of intended purpose. Reviews end product with the client to ensure adequate understanding. Provides data analysis guidance as required.

  • Provides tool and data support to business users and fellow team members.

  • Tests and implements new software releases through regression testing. Identifies issues and engages with vendors to resolve and elevate software into production.

  • Participates in special projects and performs other duties as assigned.


  • Minimum of three years data analytics, programming, database administration, or data management experience.

  • Undergraduate degree or equivalent combination of training and experience.

About Vanguard

We are Vanguard. Together, we're changing the way the world invests.

For us, investing doesn't just end in value. It starts with values.

Because when you invest with courage, when you invest with clarity, and when you invest with care, you can get so much more in return. We invest with purpose - and that's how we've become a global market leader. Here, we grow by doing the right thing for the people we serve. And so can you.

We want to make success accessible to everyone. This is our opportunity. Let's make it count.

Inclusion Statement

Vanguard's continued commitment to diversity and inclusion is firmly rooted in our culture. Every decision we make to best serve our clients, crew (internally employees are referred to as crew), and communities is guided by one simple statement: "Do the right thing."

We believe that a critical aspect of doing the right thing requires building diverse, inclusive, and highly effective teams of individuals who are as unique as the clients they serve. We empower our crew to contribute their distinct strengths to achieving Vanguard's core purpose through our values.

When all crew members feel valued and included, our ability to collaborate and innovate is amplified, and we are united in delivering on Vanguard's core purpose.

Our core purpose: To take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Engineer


Posted 9 months ago

VIEW JOBS 2/18/2021 12:00:00 AM 2021-05-19T00:00 Why you'll love Softchoice: We are a technology company that equips organizations to be agile and innovative, and for their people to be productive, creative and happier at work. That means moving them to the cloud, helping them build the workplace of tomorrow, and enabling them to make smarter decisions about their technology portfolio. By doing these things, we create success faster and in circumstances otherwise not possible. We stand proudly for our people and support their success through career development and advancement. We are recognized and respected for our culture of inclusion and belonging, continuously striving to do what's good for our people and communities. The impact you will have: We're on a mission to help our clients unleash the full potential of the public cloud - and we're hiring a new Data Engineer to make that happen. If you are passionate about driving customer outcomes using best-in-class Data solutions and creative problem solving, we have an exciting opportunity for you. As part of our Cloud Transformation Team, you will work closely with a cross-section of Softchoice's most innovative experts and architects. From designing tailored Data solutions, to having the tactical know-how to put the pieces together, you will lead the way on how to use the best of Data in technology and to transform all kinds of customer environments using automation, advanced tooling and a dedication to outstanding customer results. What you'll do: * Delivering excellence: Developing, testing and managing Data cloud native and 3rd party tooling and automation technologies, delivered through code, templates and scripts to ensure top-quality client experiences, delivered with consistency and efficiency. * Leading by collaboration: Working with software developers, application architects, QA engineers, and operations teams to deliver on - and exceed - client expectations. You will also team up with SME's, practice leads and vendors to fine tune our strategy and overcome obstacles to adoption at every step. * Evangelizing the New: You aren't just deeply familiar with cutting-edge concepts and technologies. You know how to tailor your insights to customers, occasionally working onsite with customers as a consultant to explore their needs to provide a compelling vision forward. What you'll bring to the table: * Expert-level understanding about Data Services * Good understanding about DevOps culture, methodologies, coding and automation. * Proven experience driving results with relevant technologies and methods, such as architecting and implementing public cloud data solutions on Azure. * Bachelor's Degree or Diploma in a relevant field or equivalent industry experience. * Minimum 2 years of experience of IT Cloud Implementations * Strong knowledge of Oracle, SQL Server, Azure SQL Database and Amazon RDS * Knowledge of SQL with High Availability such as Always On Availability Groups * Experience designing and implementing Digital Transformational solutions with expertise in the following areas: * Solution design and data migration * Security and Compliance * Database tuning and optimization * Big Data technologies; designing and implementing Data Lakes * Integration Services: Azure Data Factory * Reporting Tools such as; Power BI, SSRS, etc. * Foundational cloud IaaS and PaaS technologies * Oracle * Python scripting * Experience in the following areas are an asset: * Azure Cosmos DB * Azure Synapse * Azure Databricks * Apache Spark * Data Virtualization * GIT * Advanced development skills and strong scripting experience, for example: Python or PowerShell. * Bonus points for having multiple related certifications for Azure (DP-200 & DP-201), AWS or GCP. You will also have a wealth of professional services and consulting experience, such as: * Great communication and consultative skills, with the ability to occasionally work onsite with customers and be able to present technically advanced topics to large groups of people with confidence and impact. * End to end ability to chart a strategy and identify the solution, while also being able to deliver it and support the client through adoption and maturity * Experience working in professional services and/or software engineering for clients in a provider to client relationship. Bonus if experience in a consulting firm. Some reasons why our employees love working here: * Softchoice has been recognized as a Best Workplace in Canada by the Great Place to Work Institute for 15 consecutive years. * Softchoice has been certified as a Great Place to Work in the United States for several years. * We offer meaningful work that drives professional development. * Our team members have 2 paid volunteer days per year to give back to a cause of their choice. * We offer an opportunity to build a career in the technology industry. * We have raised over $3 Million through our team member run charity Softchoice Cares. * You will have the opportunity to take an ownership position here at Softchoice. Inclusion & Equal opportunity employment: We are an equal opportunity employer committed to Diversity, Inclusion & Belonging. Individuals seeking employment at Softchoice are considered without regard to any protected category including but not limited to, race, color, religion, national origin, age, sex, marital status, ancestry, disability, veteran status, gender identity, or sexual orientation. Require an accommodation? We are ready to help: We are proud to provide interview & employment accommodation during the recruitment and hiring process. If you require any accommodation to apply or interview for a position, please reach out directly to We are committed to work with you to best meet your needs. Our commitment to your experience: We are committed to the safety of all candidates and team members. With that in mind, we have implemented virtual interviewing for all candidates. We understand that you may need to interview with distractions around you (such as children or furry friends) and we will most likely be doing the same. For team members joining Softchoice, you will be onboarding remotely. Rest assured, offering a human and inspiring onboarding experience is our top priority. Prior to commencing employment: Completion of a satisfactory criminal record check, education verification and reference checks are required for employment. EoE/M/F/Vet/Disability Mid-Senior Level #LI-MP1 Nearest Major Market: Philadelphia Softchoice Malvern PA

Data Engineer