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

Requirements:

• 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