Data Engineering - Associate

FormativGroup helps middle-market organizations connect infrastructure, applications, and business processes through cloud architecture, system integration, AI, and data strategy. The Data Engineering Consulting Associate will help clients design, build, and optimize modern data platforms, pipelines, and integration solutions while developing technical and consulting expertise across cloud and on-premises environments.

Responsibilities

Design, develop, test, and maintain scalable data pipelines and ETL/ELT processes

Support the implementation of modern data platforms, data lakes, and data warehouses

Develop data integration solutions using cloud-native and enterprise technologies

Build and optimize data ingestion frameworks for structured and unstructured data

Perform data quality validation, transformation, reconciliation, and performance tuning

Support migration of legacy data environments to modern cloud architectures

Gather business and technical requirements from client stakeholders

Translate business needs into practical technical data solutions

Participate in workshops, design sessions, demonstrations, and project status meetings

Document technical designs, architecture decisions, operating procedures, and development standards

Support disciplined project delivery across one or more client workstreams

Collaborate with business intelligence, analytics, AI, and data science teams to ensure reliable data availability

Support the development of curated data models for reporting and analytical use cases

Assist with implementing data governance, security, privacy, and compliance controls

Identify opportunities to improve platform performance, scalability, reliability, and maintainability

Stay current on emerging cloud, data engineering, analytics, and AI technologies

Contribute to internal accelerators, reusable assets, proposals, and knowledge-sharing initiatives

Preferred

Experience with Azure Data Factory, Microsoft Fabric, Databricks, Synapse Analytics, Snowflake, Redshift, BigQuery, Airflow, dbt, or comparable platforms

Knowledge of distributed data processing frameworks such as Apache Spark

Exposure to data governance, metadata management, master data management, or data observability

Experience in consulting, professional services, or another client-facing delivery environment

Relevant certifications from Microsoft Azure, AWS, Google Cloud, Databricks, or Snowflake

Azure Data Factory

Microsoft Fabric

Databricks

Synapse Analytics

Snowflake

Amazon Redshift

Google BigQuery

Apache Airflow

dbt

Distributed Data Processing

Apache Spark

Data Governance

Metadata Management

Master Data Management

Data Observability

Consulting

Client-Facing Delivery

Microsoft Azure Certifications

AWS Certifications

Google Cloud Certifications

Databricks Certifications

Snowflake Certifications

Benefits

Employees may be eligible for discretionary bonuses, commissions, or other incentive programs.

Medical insurance

Dental insurance

Vision insurance

401(k)

Paid time off

Company

IT consulting for workflow, application, and data integration

White Plains, New York, USA

https://formativgroup.io/

51-200 employees

Qualifications

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa currently

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, Mathematics, or a related field

1-3 years of experience in data engineering, data integration, analytics engineering, software engineering, or a related technical role

Hands-on experience with SQL, relational databases, and ETL/ELT development

Understanding of data warehousing concepts, dimensional modeling, and data quality practices

Experience with at least one programming language such as Python, Scala, or Java

Familiarity with at least one cloud platform such as Microsoft Azure, AWS, or Google Cloud

Strong analytical, problem-solving, communication, and documentation skills

Ability to work collaboratively in a team-oriented, client-facing environment

You are curious, practical, collaborative, detail-oriented, and motivated to learn through feedback and hands-on delivery

You handle ambiguity by clarifying assumptions, gathering evidence, communicating progress, and escalating thoughtfully when needed

You balance pace with quality and treat testing, documentation, reliability, security, and maintainability as part of the work

Experience with Azure Data Factory, Microsoft Fabric, Databricks, Synapse Analytics, Snowflake, Redshift, BigQuery, Airflow, dbt, or comparable platforms

Knowledge of distributed data processing frameworks such as Apache Spark

Exposure to data governance, metadata management, master data management, or data observability

Experience in consulting, professional services, or another client-facing delivery environment

Relevant certifications from Microsoft Azure, AWS, Google Cloud, Databricks, or Snowflake

1-3 years of experience in data engineering, data integration, analytics engineering, software engineering, or a related technical role.

Required skills

SQL, Relational Databases, ETL/ELT Development, Data Warehousing, Dimensional Modeling, Data Quality, Python, Scala, Java, Microsoft Azure, AWS, Google Cloud

Experience

1+ years