Jorge Sanchez

Jorge Sanchez Email and Phone Number

Data Engineer @ Capital One | Commercial Finance @ Capital One
mclean, virginia, united states
Jorge Sanchez's Location
New York City Metropolitan Area, United States
Jorge Sanchez's Contact Details

Jorge Sanchez personal email

Jorge Sanchez phone numbers

About Jorge Sanchez

At Capital One, my role as a Data Engineer blends over three years of Python, SQL analytics, and big data engineering expertise, focusing on delivering robust data solutions in financial and commercial banking metrics to key stakeholders while ensuring to meet SEC requirements. Our team ensures on-time delivery of daily files and seamless migration of features to live production environments, upholding stringent data governance standards and service level agreements.My recent achievements include developing new business logic and metrics using Pyspark, SQL, and Scala to align with finance and accounting objectives. At the same time I perform AWS remediation, planning and execution with many AWS tools including S3, Lambda, EMR and EC2 clusters. With proficiency in scripting, and automation, I am dedicated to enabling informed decision-making and operational excellence through innovative data engineering practices.

Jorge Sanchez's Current Company Details
Capital One

Capital One

View
Data Engineer @ Capital One | Commercial Finance
mclean, virginia, united states
Website:
capitalone.com
Employees:
55043
Jorge Sanchez Work Experience Details
  • Capital One
    Data Engineer
    Capital One Aug 2022 - Present
    New York City Metropolitan Area
    • Ensure the on-time delivery of daily files to consumers from managed pipelines and automated workflows on production support utilizing PagerDuty and One ServiceNow incident management• Design and implement CI/CD data pipelines with Jenkins and Git to build and promote applications from QA to Production while meeting necessary testing requirements and staging environments• Build Databricks environments with cluster appropriation, computed resources and performances for East to West transitions to continue team notebook collaboration and scheduled workflows• Promote features and QA processes to live Production environments after testing, verification, development and scheduling in automated engines, including Automic and Redwood servers• Develop transformations using Python, Pyspark, SQL and Scala to build financial processes and modeling for analysis and performance enhancement using collaborative Databricks notebooks and Github repositories• Assist with the migration of older transformations from Java and Scala to current Pyspark environments using Docker and AWS containerization• Manage AWS infrastructure including S3 buckets, versioning, policies, lambdas, EMR and EC2 cluster rehydration for production performance using shell scripting with Unix and Linux in IAM roles.• Register and validate datasets to AWS S3 Data Lakes and Delta Lake environments from QA to live production following stringent data governance, privacy, and data cataloging guidelines using internal applications and platforms• Uphold security standards using vulnerability fixes with Maven, package library updates in Artifactory and ensuring code coverage with compliance standards and testing maturity• Load data from AWS S3 into Snowflake tables, maintain, build and structure tables to optimize data ingestion and improve query performance for financial analysis
  • Signify Health
    Senior Data Analyst
    Signify Health Jun 2021 - Sep 2024
    New York, New York, United States
    • Lead the development of in-depth analyses to support the business goals of internal and external clients with automated report creation using Python scripting and built in API’s for most up to date data availability.• Use PySpark to read, write and analyze large data Apache Parquet files for AWS deployment from large government medicare files to live table loads.• Build functions and execution engines using Python Object Oriented Programming for AWS S3 and EC2 virtual environments with SQL Alchemy, psycopg2 and PostgreSQL.• Implement SQL queries for reporting and reconciliation purposes with financial stakeholders.• Work with data engineering team in database design and table registration with PostgreSQL tables using joins, metric creation and exploration queries.• Ensure data quality by designing ad hoc initiatives for emergency fixing, reconciliation checks and solutions.• Investigate healthcare claims data for patient tracking, facility and healthcare systems ratings• Push to and pull from code repository using Git and contribute to production documentation in Confluence with other engineers and analysts.
  • Northwell Health
    Data Analyst
    Northwell Health Mar 2020 - Jun 2021
    New York, New York, United States
    As a Data Analyst, I coordinate various databases which includes the research and clinical operations of projects. I help collect, input, analyze and report data.Responsibilities include:• Find data insights using statistical analysis with Python, R and Microsoft Excel• Coordinate and maintain SQL warehouse with primary, foreign keys and data dictionaries.• Create Tableau visualizations of project operations, success metrics and insights using Enterprise Server • Set up automated programming processes in data analysis across databases for report building• Report and present key findings and insights as recommendations of strategy to leadership and management• Provide data auditing and data support across the hospital system for research initiatives• Assisted in COVID-19 emergency efforts to build patient databases and provide clinical population insights• Trains staff on data capture and data entry.
  • Weill Cornell Medicine
    Research Program Coordinator
    Weill Cornell Medicine Feb 2019 - Mar 2020
    Greater New York City Area
    • Provided and presented data analysis and statistical findings for conferences and meetings using Excel and R • Managed large qualitative and quantitative health research databases along with NYS Department of Health data and reports • Lead a team of researchers, medical students and physicians in community settings to conduct research• Designed and coordinated the collection of New York City data for the international MetaSUB genomic project• Assisted in the preparation of materials, submissions and renewals to the Institutional Review Board (IRB)• Provided preparation of grant submissions, progress reports, routing forms, abstracts and manuscripts• Proficient in statistical and database management in RedCap and SPSS
  • Weill Cornell Medicine
    Research Program Assistant
    Weill Cornell Medicine Jan 2018 - Feb 2019
    Greater New York City Area
    • Managed and entered collected data into study databases, conducts qualitative coding and analysis of research data• Coordinated the recruitment and enrollment of study participants, access patient eligibility for eligibility in clinical trials. Ensured consent protocols are followed for study participation • Assisted in the preparation of materials, submissions and renewals to the Institutional Review Board (IRB)• Assisted with departmental mailings, storage and disposal of patient medical records• Provided trainings to community members and undergraduate students at large, both in English and Spanish• Translated research documents and educational materials for communities from English to Spanish• Proficiency in statistical and database management in RedCap and SPSS
  • Weill Cornell Medicine
    Undergraduate Research Volunteer Leader
    Weill Cornell Medicine Aug 2014 - Dec 2017
    Greater New York City Area
    • Provide free cardiovascular and ophthalmology health screenings to underserved NYC communities• Obtain comprehensive medical and health history from participants and provide personal health education• Completes community medical research using IRB approved survey through REDCap software• Attend executive campaign meetings to analyze statistical data and to make research implementations • Recruit, train, inform and direct undergraduate student volunteers on behalf of the program
  • Metasub Consortium
    Research Volunteer
    Metasub Consortium Jun 2016 - Jun 2018
    Greater New York City Area
    • Obtain metagenomic samples in teams in New York City subway system following research protocol and using mobile data storage applications
  • The Bristal Assisted Living
    Staff Waiter
    The Bristal Assisted Living Jun 2013 - Dec 2017
    • Dining room waitperson that prepares and serve appetizers, main courses and desserts to Bristol residents• Provide care and supervision of Bristol residents to help meet dietary expectations
  • Association Of Hispanic Healthcare Executives ( Ahhe)
    Executive Intern
    Association Of Hispanic Healthcare Executives ( Ahhe) Jan 2017 - Jun 2017
    Greater New York City Area
    • Attended executive meetings, receive lectures and training from Weill Cornell Medicine director of laboratories
  • Nyu Langone Medical Center
    Research Associate
    Nyu Langone Medical Center Sep 2016 - Jun 2017
    New York City
    • Enrolled over 180 patients into NIH funded EDCares Study with REDCap software through IRB protocol• Obtained consent and enrolled 61 Spanish speaking ED patients into EDCares study
  • Nyc Health + Hospitals
    Wecare Program Volunteer
    Nyc Health + Hospitals Sep 2015 - Sep 2016
    Greater New York City Area
    • Immerse in emergency medicine volunteering, physician shadowing and patient advocacy • Help obtain medical history of patients under direct supervision • Helped nurses accommodate and transport patients, helped sanitize and restock ED when directed
  • The University Of Texas Health Science Center At Houston (Uthealth)
    Summer Medical And Dental Education Program Scholar
    The University Of Texas Health Science Center At Houston (Uthealth) May 2014 - Jul 2014
    Houston, Texas Area
    • Gained medical exposure with professors and health professionals in the UT Health system• Attended pre-medical lectures in medical school and dental school setting.

Jorge Sanchez Skills

Spanish Translation Organic Chemistry Biology Non Profit Volunteering Customer Service Customer Satisfaction Customer Relations Spanish Literature Food Sensitivities Data Science Python Sql Project Management Microsoft Excel Microsoft Word Health Services Research Data Analysis Mental Health Data Visualization Big Data Machine Learning Sqlite Mysql Pandas Seaborn Databases Jupyter Javascript D3.js Html Mongodb Visual Basic For Applications Github Git Pyspark Tableau Mental Health First Aid Matplotlib Object Relational Mapping Ethereum Mining Leaflet.js Numpy Big Data Analytics English To Spanish Research Clinical Research Analytics Scripting Microsoft Office Microsoft Powerpoint R Leadership Institutional Review Board Apache Spark Teamwork

Jorge Sanchez Education Details

Frequently Asked Questions about Jorge Sanchez

What company does Jorge Sanchez work for?

Jorge Sanchez works for Capital One

What is Jorge Sanchez's role at the current company?

Jorge Sanchez's current role is Data Engineer @ Capital One | Commercial Finance.

What is Jorge Sanchez's email address?

Jorge Sanchez's email address is sa****@****ail.com

What is Jorge Sanchez's direct phone number?

Jorge Sanchez's direct phone number is +191762*****

What schools did Jorge Sanchez attend?

Jorge Sanchez attended Columbia Engineering, City University Of New York-Hunter College, Hunter College.

What skills is Jorge Sanchez known for?

Jorge Sanchez has skills like Spanish Translation, Organic Chemistry, Biology, Non Profit Volunteering, Customer Service, Customer Satisfaction, Customer Relations, Spanish Literature, Food Sensitivities, Data Science, Python, Sql.

Who are Jorge Sanchez's colleagues?

Jorge Sanchez's colleagues are Shazia Dasu, Robert Versacci, Stephen Nguyen, Jason Lance, Anton Aguilar, Kandice Neilson, Laurie Senior.

Not the Jorge Sanchez you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.