ETL Data Engineer / Azure / On-site Philly Suburbs

at  Motion Recruitment

This investment management company is looking to expand their team to meet the needs of their growing client base. They are looking to hire a ETL Data Engineer with strong experience in Python and Azure Synapse Analytics to join their dynamic team. You will play a critical role in their expanding data engineering team, and will be responsible for designing, developing, and maintaining ETL data integration processes primarily using Python (PySpark), Azure Synapse Analytics Pipelines, and other Azure Synapse Analytics resources. This role is hybrid in the Philadelphia suburbs, and requires the candidate to be on-site from Monday-Thursday. This FinTech company is located in the Philadelphia suburbs and continues to prove themselves as a leader in the industry. They specialize in providing investment solutions and services related to private equity, private credit, real assets, and other alternative investments. They work with a diverse client base, including institutional investors, family offices, and high-net-worth individuals. Required Skills & Experience

• Proven experience in ETL data engineering with significant expertise using Python (PySpark) to perform data extraction, transformation, and loading from REST APIs, SQL database tables, and CSV files
• Proficiency in using Azure Synapse Analytics resources including Notebooks, Pipelines, Linked Services, and Azure Key Vault
• Demonstrated ability to write complex SQL queries, optimize query performance, and work with both SparkSQL and MS SQL
• Experience with version control systems, such as Git (Azure DevOps).
• Strong problem-solving and analytical skills, with a keen attention to detail
• Bachelor’s degree in Computer Science, Information Technology, or a related field; or appropriate work experience

Desired Skills & Experience

• Certifications related to data engineering or data science (Ex. Azure Data Engineer)
• Knowledge of big data technologies
• Experience with data visualization tools (Power BI, Tableau, etc.)
• Familiarity with ML and data analysis
• Experience with agile methodologies

What You Will Be Doing Tech Breakdown

• 100% Data Engineering

Daily Responsibilities

• 80% Hands on
• 20% Team Collaboration

The Offer

• Bonus eligible

You will receive the following benefits:

• Medical, Dental, and Prescription Plans
• Life and Disability Insurances
• Paid Time Off
• 401k plan
• Tuition Reimbursement
• Employee Stock Purchase Program

Applicants must be currently authorized to work in the US on a full-time basis now and in the future

This investment management company is looking to expand their team to meet the needs of their growing client base. They are looking to hire a ETL Data Engineer with strong experience in Python and Azure Synapse Analytics to join their dynamic team. You will play a critical role in their expanding data engineering team, and will be responsible for designing, developing, and maintaining ETL data integration processes primarily using Python (PySpark), Azure Synapse Analytics Pipelines, and other Azure Synapse Analytics resources. This role is hybrid in the Philadelphia suburbs, and requires the candidate to be on-site from Monday-Thursday. This FinTech company is located in the Philadelphia suburbs and continues to prove themselves as a leader in the industry. They specialize in providing investment solutions and services related to private equity, private credit, real assets, and other alternative investments. They work with a diverse client base, including institutional investors, family offices, and high-net-worth individuals. Required Skills & Experience

• Proven experience in ETL data engineering with significant expertise using Python (PySpark) to perform data extraction, transformation, and loading from REST APIs, SQL database tables, and CSV files
• Proficiency in using Azure Synapse Analytics resources including Notebooks, Pipelines, Linked Services, and Azure Key Vault
• Demonstrated ability to write complex SQL queries, optimize query performance, and work with both SparkSQL and MS SQL
• Experience with version control systems, such as Git (Azure DevOps).
• Strong problem-solving and analytical skills, with a keen attention to detail
• Bachelor’s degree in Computer Science, Information Technology, or a related field; or appropriate work experienc