Data Engineer at Vanguard building client information reporting capabilities with Python and SQL. Leading integration of new services and processes in a hybrid working model.
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 large scale 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 complex 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 an enhanced understanding of business functions and informational needs.
Gains expertise in tools, technologies, and applications/databases in specific business areas and company-wide systems.
Leads all phases of solution development.
Explains technical considerations at related meetings, including those with internal clients and less experienced team members.
Tests code thoroughly for accuracy of intended purpose.
Reviews end product with the client to ensure adequate understanding.
Provides data analysis guidance as required.
Designs and conducts training sessions on tools and data sources used by the team and self provisioner's.
Provides job aids to team members and business users.
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.
Requirements
Advanced SQL development
Advanced Python development
AWS experience
Minimum of five years data analytics, programming, database administration, or data management experience.
Undergraduate degree or equivalent combination of training and experience.
Specialist, Data Engineering at CoverMyMeds enhancing and expanding data platforms for commercial data products. Collaborating with multiple teams to design scalable data solutions from various sources.
Team Lead in Data Engineering at Avanquest mentoring data engineering team and ensuring efficient data management across platforms. Collaborating with departments to align solutions and optimize workflows.
Data Architect at RSM leading AI - driven data migration initiatives within Salesforce ecosystem. Implementing data governance and optimizing performance across complex datasets.
Senior Data Engineer at Capgemini designing and optimizing scalable data architectures on Databricks and GCP. Collaborating across teams to transform business needs into reliable technical solutions.
Data Engineer transforming legacy on - premises systems to cloud - native architectures for advanced data analytics. Collaborating with teams to build efficient data solutions using Python and AWS.
Data Engineering Academy focused on Snowflake and Databricks for professionals interested in expanding their technical capabilities. Fully remote with future office work in Monterrey or Saltillo after completion.
Senior Data Engineer at Intent HQ designing and scaling data platforms. Building high - impact intelligence from millions of customer insights with a focus on performance and reliability.
SAP Data Engineer supporting MERKUR GROUP's evolution into a data - driven company. Responsible for data integration, modeling, and collaboration with various departments in Group Finance.
Data Engineer at Booz Allen Hamilton organizing data and developing advanced technology solutions. Leading data engineering activities for mission - driven projects and mentoring multidisciplinary teams.
Senior Data Engineer at Bristol Myers Squibb developing scalable data pipelines for foundational products. Collaborating with data scientists and IT professionals to ensure data quality and accessibility.