Data Engineer

Location: Madison, Wisconsin (Remote)

About the role

We are seeking an experienced Snowflake Data Engineering Consultant to support the design, development, and optimization of a foundational enterprise HR data warehouse initiative. This role combines hands‑on data engineering responsibilities with data architecture, governance, and future‑state planning to help establish a scalable analytics platform that will support reporting, advanced analytics, predictive modeling, and machine learning initiatives.

Everforth Apex is a world‑class IT services company that serves thousands of clients globally. The company values innovation, collaboration, and continuous learning, offering career resources, training, certifications, development opportunities, and a comprehensive benefits package.

Responsibilities

• Design, build, and optimize data pipelines feeding a Snowflake data warehouse.
• Evaluate and enhance existing data models, schemas, and data architecture for scalability and sustainability.
• Develop and maintain dimensional data models, including fact and dimension tables.
• Implement best practices for data governance, automation, and warehouse management.
• Collaborate with analysts and business stakeholders to translate reporting and analytics requirements into technical solutions.
• Assess current warehouse design and recommend improvements to support future growth and advanced analytics.
• Develop automation solutions leveraging Snowflake stored procedures and existing ingestion processes.
• Ensure data quality, integrity, and performance across the data environment.
• Work independently while partnering closely with a small analytics team.

Required qualifications

• Strong experience designing and developing solutions in Snowflake.
• Deep understanding of data warehousing concepts, data modeling, and dimensional modeling.
• Experience building and maintaining ETL/ELT pipelines.
• Advanced SQL development skills.
• Experience implementing scalable and sustainable data architectures.
• Strong understanding of data governance and warehouse best practices.
• Ability to evaluate existing environments and recommend future‑state improvements.
• Excellent communication skills and ability to collaborate with both technical and non‑technical stakeholders.
• Ability to work independently and drive project outcomes with limited oversight.

Preferred qualifications

• Experience with HR, workforce, or enterprise reporting data environments.
• Experience integrating data from Workday or similar HR systems.
• Experience with Alteryx or comparable data integration platforms.
• Exposure to Power BI reporting environments.
• Experience supporting predictive analytics, machine learning, or advanced analytics initiatives.

Benefits

• Medical, dental, vision, life, disability, and other supplemental insurance plans.
• Employee Stock Purchase Program (ESPP) and 401(k) with company match after 12 months.
• Health Savings Account (HSA) on HDHP plan.
• SupportLinc Employee Assistance Program (up to 8 free counseling sessions).
• Corporate discount savings program and other discounts.
• On‑demand training program, certification prep, and library of technical and leadership courses after 6+ months of tenure.
• Certification discounts and perks for associations such as CompTIA and IIBA.
• Dedicated customer service team for consultants and a certified Career Coach.