At our core, we help organizations unlock the full value of their data - turning complexity into clarity and strategy into measurable outcomes. As a Consultant - Data Engineering & Analytics - Data Engineering, you will support the delivery of data solutions and contribute to client transformation initiatives.
This role focuses on building on foundational experience at the intersection of data engineering, analytics, and consulting delivery. You will work alongside experienced team members to help design, develop, and implement modern, cloud-based data solutions that enable efficient analytics and data-driven decision-making.
You will support development efforts across platforms such as Snowflake, Databricks, AWS, and Azure, contributing to client data modernization initiatives. You will assist in translating business and technical requirements into well-structured data solutions while developing your technical and consulting skill set.
Success in this role requires strong problem-solving abilities, attention to detail, and a willingness to learn in a fast-paced environment. You will be expected to contribute to team deliverables, continuously build technical expertise, and support high-quality client outcomes.
What You'll Work On
- Support client engagements as a contributing project team member
- Assist in gathering and understanding business and technical requirements
- Translate requirements into technical tasks under guidance from senior team members
- Support preparation of presentations, documentation, and deliverables
- Develop and support data solutions leveraging:
- Snowflake (data warehousing, data storage)
- Databricks (data processing, Spark workloads)
- AWS ecosystem (S3, Glue, Redshift, Lambda, EMR, IAM)
- Microsoft Fabric / Azure (Synapse, ADF)
- DataVault Data Automation
- Build and maintain data pipelines (primarily batch, with exposure to near real-time)
- ETL/ELT development and data integration processes
- Contribute to development of data platforms including data lakes and data warehouses
- Follow established best practices for coding, testing, and performance optimization
- Support senior team members in troubleshooting and resolving data issues
- Participate in code reviews, testing, and quality assurance activities
- Manage assigned tasks and deliver them within project timelines with minimal oversight
- Assist with analytics and reporting by preparing curated datasets
- Support advanced analytics initiatives such as machine learning data preparation
- Stay current with tools, technologies, and best practices through continuous learning
- Support data governance, data quality, and documentation efforts
- Follow data security and compliance standards
- Contribute to maintaining metadata, lineage, and technical documentation
What You'll Bring
- Bachelor’s degree in Data Analytics, Business Analytics, Information Systems, Computer Science, Statistics, Mathematics, Economics, or related field
- 3-5 years of experience in data engineering, analytics, or related technical roles
- Foundational experience with:
- SQL and basic data modeling concepts
- ETL/ELT processes and data integration
- Exposure to cloud platforms such as AWS, Azure, or GCP
- Familiarity with tools such as Snowflake, Databricks, or similar platforms is a plus
- Exposure to programming languages such as Python or Scala is preferred
- Basic understanding of modern data architecture concepts (data lakes, warehouses)
- Exposure to data visualization tools (e.g., Power BI, Tableau) is a plus
- Strong analytical and problem-solving skills
How You Work
- Need to be proactive and look for ways to pitch in
- Someone who is customer oriented and quality driven
- Much be able to handle multiple priorities and have good time management
- This is an ever-changing landscape so the ability to be flexible with routines is important
- Thinking outside the box to find better ways of working to deliver for clients and internally
Bonus Points If You Have
- Datavault Experience - VaultSpeed, DataVault Builder, Wherescape
- High attention to detail and commitment to quality
- Effective communication and teamwork skills
- Ability to learn quickly and adapt in a consulting-driven, fast-paced environment
- Demonstrated curiosity and interest in data engineering, analytics, and emerging technologies
What Success Looks Like
- Quick to develop strong client relationships
- Assist leadership with growing business
- Identifying new ways to contribute
- Become invaluable to clients
- Is a go to person for leadership to develop and deliver
- Working in a collaborative environment and supporting those around them
FormativGroup operates within the critical middle layer of business technology, where applications and systems connect infrastructure to business processes. We are specialists who help the middle market take full advantage of their technology investments with deep, industry-centric expertise, all in one place, to unify fragmented systems. With deep technical expertise across cloud architecture, system integration, AI, and data strategy, we bridge the gap between business goals and modern platforms.
FormativGroup is an equal opportunity employer providing opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
ADA Specifications: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.
#formativgroupcareers #WorkWithUs
Click here to view our Privacy Policy
Skills Required
- Bachelor's degree in Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Economics, or related field
- 3-5 years of experience in data engineering, analytics, or related technical roles
- Foundational experience with SQL and basic data modeling concepts
- Experience with ETL/ELT development and data integration processes
- Exposure to cloud platforms (AWS, Azure, or GCP)
- Familiarity with Snowflake or similar data warehousing platforms
- Familiarity with Databricks and Spark workloads
- Exposure to programming languages such as Python or Scala
- Basic understanding of modern data architecture concepts (data lakes, data warehouses)
- Exposure to data visualization tools (Power BI, Tableau)
- Awareness of data governance, data quality, metadata, and lineage practices
- Attention to detail, strong analytical and problem-solving skills
- Experience or exposure to DataVault tools/automation (VaultSpeed, DataVault Builder, Wherescape)
What We Do
Modern organizations depend on business systems that work in concert. FormativGroup enables our clients by connecting their processes and workflows, applications, and layers of data in ways that reflect how the business needs to operate. We help organizations knock down technology barriers, integrate workflows, and design connected data ecosystems, so information is available where and when they need it most. We are industry-centric consultants with expertise in design AND execution, working across your ecosystem to future-proof your business environment. See how you can transform possibility into progress with FormativGroup.
