Data Engineer

FocusKPI Inc. • New York, NY

2d • Remote

About The Position

FocusKPI is looking for a Data Engineer to join their client's growing team. This role involves spearheading analyses and providing meaningful insights into users and product. The initial project will focus on migrating DBT models that currently run in Spark SQL to run in Redshift. The position is 100% remote and ideally requires working New York EST hours for a duration of 5 months, 40 hours per week.

Requirements

• Bachelor’s degree in the Computer field, which requires logical, creative thinking, STEM majors
• 5+ years of industry experience is required
• Expertise in SQL (Need to have strong skills)
• Strong experience in Spark/PySpark, Python, Scala, Airflow, and AWS
• Experience with DBT, Redshift
• Experience with data models
• Experience with CI/CD
• Experience collaborating with and understanding the needs of stakeholders from a variety of business functions, including product, marketing, finance, and so on
• Experience in handling large-scale data with efficiency
• Strong analytical and problem-solving skills

Nice To Haves

• MS degree preferred
• Experience with GitHub is a huge plus to have
• Experience in Financial Services or FinTech preferred

Responsibilities

• The initial project will be moving DBT models that currently run in Spark SQL to run in Redshift
• Need to have the business intuition to roughly understand the business logic in the existing data model and make sure the new one meets their needs
• Team would also like you to do some CI/CD work around their DBT job, where Python, GitHub Actions, and Airflow would be helpful
• Support new product launches, A/B testing, ramp-up recommendations, and root cause investigation
• Be constantly curious and continue to pursue in-depth explorations of the datasets
• Leverage new techniques to investigate their data and incorporate external information to boost our knowledge of this market
• Communicate complicated data findings in a clear and concise manner to our multi-disciplined teams
• Collaborate with stakeholders, including product, marketing, finance, etc., on initiatives that improve our company-level KPIs and match our business priorities
• Ad-hoc analysis to address urgent high-impact analysis for business stakeholders

What This Job Offers

• Job Type: Full-time
• Career Level: Senior