Data Engineer / BI Developer

Data Engineer / BI Developer

LocationNew York, NY.

Onsite. Full time.

About the job

Advantra is partnering with a global financial services firm in New York to hire a Data Engineer / BI Developer to build and maintain scalable data pipelines and develop business intelligence visualizations for internal analytics platforms.

About the role

You will design, develop, and optimize data transformation workflows using PySpark and SQL, while also building clear, effective dashboards and interfaces in tools like Power BI or Retool. The role combines strong data engineering skills with front-end visualization experience to help business users access insights easily.

Responsibilities

Build and maintain ETL pipelines and data transformation workflows using PySpark.

Write efficient SQL queries for large-scale data processing and analytics.

Design and implement BI dashboards using Power BI or Retool.

Collaborate with stakeholders to define visualization and reporting requirements.

Integrate structured and unstructured data from multiple cloud sources.

Support and enhance data pipelines within a managed cloud data platform.

Develop reusable data models and maintain data quality standards.

Optimize performance and scalability of BI and data systems.

Support production deployments and resolve pipeline or dashboard issues.

Core requirements

5+ years of experience in data engineering or BI development.

Strong proficiency in PySpark and advanced SQL coding.

Experience with Power BI or Retool for dashboard development.

Familiarity with front-end web design and data visualization principles.

Strong understanding of ETL / ELT pipelines and cloud data platforms.

Experience with Python for data manipulation and automation.

Familiarity with Java for integration or backend logic.

Ability to translate business needs into technical data solutions.

Excellent communication and problem-solving skills.

Bachelor's degree in Computer Science, Data Engineering, or related field.

Nice to have

Experience with GCP, AWS, or Azure data services.

Familiarity with CI / CD for data pipeline deployment.

Knowledge of API integration for BI tools.

Experience with performance tuning in PySpark or SQL.

Exposure to modern data observability and governance tools.

How to apply

Email careers@theadvantra.com with links to shipped work and a short note on what you owned. Company name shared after the intro.

About Us

Advantra-Upstart Crew is a search program inside Advantra Consulting. We partner with early stage and high growth startups to hire the top 2% in Tech and GTM. We run end to end searches, from single role headhunts to full team build outs, using domain experts and a vetted network to deliver tight shortlists. We stay close to founders and candidates so the relationship lasts beyond the first hire.