Data Engineering - Associate

Summary

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 across cloud and on-premises environments while developing technical and consulting expertise.

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

Skills

• 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
• Applicants must be authorized to work for ANY employer in the U.S
• This is a remote role with approximately 50% travel
• To be considered for this position, candidates must reside in one of the following U.S. states or Washington, DC: AL, AR, AZ, CA, CO, CT, DE, FL, GA, IA, ID, IL, IN, KS, MA, MD, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OK, OR, PA, TN, TX, VA, WI, or Washington, DC
• 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
• The preferred location is the Northeast U.S

Qualifications

Must Haves

• 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
• Applicants must be authorized to work for ANY employer in the U.S
• This is a remote role with approximately 50% travel
• To be considered for this position, candidates must reside in one of the following U.S. states or Washington, DC: AL, AR, AZ, CA, CO, CT, DE, FL, GA, IA, ID, IL, IN, KS, MA, MD, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OK, OR, PA, TN, TX, VA, WI, or Washington, DC

Nice to Haves

• 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
• The preferred location is the Northeast U.S

Benefits

• Employees may be eligible for discretionary bonuses, commissions, or other incentive programs
• Medical insurance
• Dental insurance
• Vision insurance
• 401(k)
• Paid time off
• Remote work