Andrew Medley
Durham,NC
Summary
Detail-oriented Data Engineer at Fidelity Investments with a strong foundation in SQL-based ETL pipelines, big data platforms, and data warehousing. Experienced in designing scalable data solutions that support internal analytics, reporting, and data science. Adept at navigating complex source systems (DB2, VSAM, Oracle), transforming data to track history and effectiveness, and ensuring integrity across cloud and on-prem environments. Skilled in developing insightful dashboards and reporting solutions using Power BI and Tableau. Proven ability to translate business needs into effective visualizations and metrics that drive decision-making. Committed to continuous learning, currently advancing Python proficiency to complement engineering and analytical capabilities.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Engineer
Fidelity Investments
Durham, NC
06.2024 - Current
- Develop and maintain complex data pipelines moving stock plan service (SPS) data from diverse sources into Fidelity’s Enterprise Analytics Platform (EAP), a large-scale internal data lake.
- Work with data from DB2 and VSAM mainframes, Oracle cloud systems, and legacy WIDE data warehouse to construct effective, historical views of plan administration and global recordkeeping data.
- Write advanced SQL scripts including CTEs and window functions to transform, stitch, and validate data across RAW and prepared layers.
- Created a reusable SQL utility that identified and preserved decimal precision across Oracle-to-Snowflake data transfers, saving weeks of manual validation.
- Orchestrate pipeline development with Airflow and manage code/versioning via GitHub; deploy via Jenkins as part of CI/CD workflows.
- Collaborate in Agile ceremonies including daily standups, sprint planning, backlog refinement, and sprint reviews.
- Delivered a Power BI-based "Lost Shareholder Report" as part of Fidelity’s reporting modernization initiative, optimizing performance and user interactivity.
Data Analytics Intern
Fidelity Investments
Westlake, TX
06.2023 - 08.2023
- Built Power BI dashboards based on stakeholder-defined metrics and presented findings to senior leadership.
- Wrote SQL queries to extract, join, and transform business data for use in dashboards and reporting.
- Worked collaboratively on an Agile team to meet deadlines and iterate on deliverables.
Education
Bachelor of Science - Business Analytics
Grand Canyon University
Phoenix, AZ04.2024
Skills
- Languages/Query Tools: SQL (Advanced), DAX, Python (learning)
- Data Engineering Tools: Airflow, Jenkins, GitHub, Snowflake, S3
- Visualization Tools: Power BI, Tableau
- Methodologies: Agile, CI/CD
Certification
- Lean Six Sigma Yellow Belt
- Introduction to Python Programming - Georgia Tech (in progress via edX)
Timeline
Data Engineer
Fidelity Investments
06.2024 - Current
Data Analytics Intern
Fidelity Investments
06.2023 - 08.2023
Bachelor of Science - Business Analytics
Grand Canyon University
Similar Profiles
MICHAEL O'BRIENMICHAEL O'BRIEN
FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)
Richard De HoyosRichard De Hoyos
Financial 401k Representative at Fidelity InvestmentsFinancial 401k Representative at Fidelity Investments
DAYANANDA KDAYANANDA K
Lead Business Analyst at Fidelity InvestmentsLead Business Analyst at Fidelity Investments
Abhay SharmaAbhay Sharma
Lead DevOps Engineer at Fidelity InvestmentsLead DevOps Engineer at Fidelity Investments
Brenda SanchezBrenda Sanchez
Owner/ Esthetician at Willow & Sage AestheticsOwner/ Esthetician at Willow & Sage Aesthetics