Senior Data Engineer

4 weeks ago


Malvern, United States CareerBuilder Full time

The Transaction Cost Analysis (TCA) team seeks to provide decision support and decision automation to improve outcomes in the investment process by minimizing transaction costs, via quantitative and data-driven research. If you are looking to work in a lively environment while learning and developing your AWS and python skills to help the trading desks reduce transaction costs, then this opportunity is for you.

In this role, you will:

Provide senior level system analysis, design, development, and implementation of applications and databases. Integrate third party products.
Translate technical specifications into code for complex new or enhancement projects for internal clients. Write programs, develop code, test artifacts, and produce reports. Employ software development techniques to ensure tests are implemented in a way that support automation.
Elevate code into the development, test, and production environments on schedule. Provide follow-up production support. Submit change control requests and documents.
Thoroughly understand software development methodology. Thoroughly understand development architecture standards. Train and mentor staff with less experience. Resolve elevated issues.
Participate in design, code, and test inspections throughout the life cycle to identify issues. Explain technical considerations at related meetings, including those with internal clients. Perform systems analysis activities.
Thoroughly understand client business functions and technology needs. Has a broad understanding of Vanguard's technologies, tools, and applications, including those that interface with business area and systems.
Collaborate with cross functional team members, and communicate systems issues at the appropriate technical level for each audience.
Thoroughly understand and align with Information Technology and Information Security policies and procedures, and verify that deliverables meet requirements.

Additional responsibilities:

Writes ETL (Extract / Transform / Load) processes.
Troubleshoot 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.
Translate business specifications into design specifications and code. Write complex programs, ad hoc queries, and reports. Ensure that all code is well structured, includes sufficient documentation, and is easy to maintain and reuse.
Partner with internal clients to gain an enhanced understanding of business functions and informational needs. Gain expertise in tools, technologies, and applications/databases in specific business areas and company-wide systems.
Lead all phases of solution development. Explain technical considerations at related meetings, including those with internal clients and less experienced team members.
Test code thoroughly for accuracy of intended purpose. Review end product with the client to ensure adequate understanding. Provide data analysis guidance as required.
Design and conduct training sessions on tools and data sources used by the team and self provisioners. Provide job aids to team members and business users.
Test and implement new software releases through regression testing. Identifies issues and engages with vendors to resolve and elevate software into production.

What it takes:

Minimum of five years related work experience, with at least one year of development experience.
Undergraduate degree or equivalent combination of training and experience.

Skills that will make an impact:

Python, PySpark programming experience
Experience with pandas
Experienced with SQL/Presto/HIVE/Spark
Experience with Key AWS services/components: EMR , Lambda, Glue ETL, Step Functions, s3,ECS, IAM, RDS PostgreSQL, CloudWatch Events/Event Bridge, Athena, SNS, SQS, VPC
Knowledge of Tableau
Exposure to designing and building web environments on AWS
Good analytical skills
Good understanding of source control, unit testing, test driven development, and CICD
Able to write clean, maintainable code, and read code created by others.

Special Factors

Sponsorship

Vanguard is offering visa sponsorship for this position.

About Vanguard

We are Vanguard. Together, were changing the way the world invests.

For us, investing doesnt 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 thats how weve 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. Lets make it count.

Inclusion Statement

Vanguards 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 Vanguards 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.

How We Work

Vanguard has implemented a hybrid working model for the majority of our crew members, designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience.
#J-18808-Ljbffr



  • Malvern, United States (THE VANGUARD GROUP INC. MALVERN,PA) Full time

    Manage and optimize automation of key ETL (Extract / Transform / Load) and quality assurance processes for large volumes of data; consult with department or function heads on implementation, transition, and operating plans. Requires Master’s in Computer Science, Computer Engineering, Computer Science and Engineering, or closely related IT field and two...


  • Malvern, PA, United States (THE VANGUARD GROUP INC. MALVERN,PA) Full time

    Manage and optimize automation of key ETL (Extract / Transform / Load) and quality assurance processes for large volumes of data; consult with department or function heads on implementation, transition, and operating plans. Requires Master’s in Computer Science, Computer Engineering, Computer Science and Engineering, or closely related IT field and two...


  • Malvern, United States Kastel Staffing Full time

    Experience Level: Mid-senior Experience required: 10 Years Education level: Bachelor's degree Job function: Engineering Industry: Mechanical or Industrial Engineering Compensation: View salary Total position: 1 Relocation assistance: No Visa sponsorship eligibility: NoJob Description:Our client Keystone Engineering Group is in search of a Senior Mechanical...


  • Malvern, United States Your IT & Corporate Recruiter Full time

    Job DescriptionYour IT Recruiter is looking for a Senior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and fire systems for commercial, municipal, or industrial facilities to join our client's Frazer, PA team.As a Senior Mechanical Engineer, you will design various HVAC system types, plumbing, fire alarm,...


  • Malvern, United States Your IT & Corporate Recruiter Full time

    Job Description Your IT Recruiter is looking for a Senior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and fire systems for commercial, municipal, or industrial facilities to join our client's Frazer, PA team. As a Senior Mechanical Engineer, you will design various HVAC system types, plumbing, fire...


  • Malvern, United States New Life Staffing LLC Full time

    Job DescriptionJob DescriptionDescription:Salary: 90-110KTravel Required: Typically, 2-3 times a month doing a client visit no more than 3 hoursAutoCad experience is a mustDesign experienceField role client facingPE required 10+ years of experienceSenior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and...


  • Malvern, United States Vanguard Full time

    The Brokerage and Investments (B&I) Analytics team is growing again! The B&I Analytics team supports our critical Brokerage and Investments business within Personal Investor. We have an opening for an experienced data analyst to support the Specialty Brokerage Operations (SBO) arm of the business. This analyst will partner closely with the business to...

  • Data Analyst

    2 weeks ago


    Malvern, United States Vision It US Full time

    Job DescriptionJob DescriptionResponsibilities:Analyzes data, assesses trends and develops actionable insights and recommendations in support of business objectives. Trains and develops junior analysts. Work closely with business partners to develop data-driven insights and recommendations to improve the client experience. Develop and maintain dashboards and...


  • Malvern, United States Motion Recruitment Partners, LLC Full time

    Job Description An international trading company is hiring a Senior Software Engineer for their team. This company has architected and developed multiple trading technologies for other firms. In total, they have access to over 70% of the U.S. options market volume. Within the position, you will get the chance to work on their exchange and surrounding...


  • Malvern, United States Horizon Controls Group Full time

    Job DescriptionJob DescriptionAssist in Configuring PI Vision: Help in the installation, configuration, and maintenance of PI Vision and its integration with existing PI System components. Support Data Migration: Assist in the migration of data from PI Asset Framework to PI Vision, ensuring accurate data transfer and minimal disruption to operations. Assist...


  • Malvern, United States Tephra Full time

    Description: Technology exp required:Relational database, SQL, transaction log, replication, applying deltasAmazon Web Services (AWS) - load data into S3 (ssh, sftp, AWS CLI)Deep expertise with Python scripting - preferably including Anaconda on AWS (processing CSV / pipe-delimited data files)Experience in building reliable multi-step distributed data...

  • Data Scientist

    2 weeks ago


    Malvern, United States Goli Tech Full time

    Job DescriptionJob DescriptionResponsibilitiesDevelops queries and performs extensive programming to access, transform, and prepare data for modeling using Python.Performs deep dive diagnostic, predictive, and prescriptive analytics to support data-driven business decision making.Identifies and diagnoses data inconsistencies and errors, documents data...


  • Malvern, United States Motion Recruitment Partners, LLC Full time

    Job Description An investment management company is currently looking for a cloud security engineer to help take their program from infancy stages and catapult it into mature phases. This organization's parent company is located in upstate New York with this subsidiary in Malvern, PA. This will be a full time, hybrid position that will be focused on building...


  • Malvern, United States CubeSmart Full time

    OverviewThis is a hybrid role based in the Malvern, PA.Summary/ObjectiveThe Senior SEO Specialist will be working collaboratively across the marketing function to lead the day-to-day implementation and optimization of Organic and local search strategies. This person will be responsible for collaborating with internal teams and agency partners to implement...

  • Solutions Engineer

    1 week ago


    Malvern, United States Circonus Full time

    As a Circonus Solutions Engineer, you’ll drive customer satisfaction and revenue by advising our customers and prospects on the value of Circonus' technology. Your responsibilities will revolve around supporting the pre and post sales process. This includes development and presentation of product demos, leading technically-oriented conversations with...


  • Malvern, United States KLM Careers Full time

    Sr. Mechanical Engineer Malvern, PA - Hybrid Must be a US Citizen or Green Card holder. The client is in search of a Senior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and fire systems for commercial, municipal, or industrial facilities to join our Frazer, PA team. As a Senior Mechanical Engineer,...


  • Malvern, United States KLM Careers Full time

    Job Description Job Description Sr. Mechanical Engineer Malvern, PA - Hybrid Must be a US Citizen or Green Card holder. The client is in search of a Senior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and fire systems for commercial, municipal, or industrial facilities to join our Frazer, PA team. As a...


  • Malvern, United States Gables Search Group Full time

    As a Senior Mechanical Engineer, you will design various HVAC system types, plumbing, fire alarm, and fire protection systems. Additional responsibilities include construction administration and field investigation tasks for projects, field inspections, developing system narratives, completing load calculations, equipment selection, and other related design...


  • Malvern, United States KLM Careers Full time

    Job DescriptionJob DescriptionSr. Mechanical EngineerMalvern, PA - Hybrid Must be a US Citizen or Green Card holder.The client is in search of a Senior Mechanical Engineer with 10 years+ of consulting engineering experience in designing HVAC, plumbing and fire systems for commercial, municipal, or industrial facilities to join our Frazer, PA team.As a Senior...


  • Malvern, United States STRADA Search Group Full time

    The company is a leading Systems Integrator in the field of automation and industrial controls. We specialize and excel in providing proven, reliable controls systems for our customers' manufacturing and business process needs. We are constantly growing, and as such we need your help every step of the way, from the factory floor PLC logic, to data...