Description

Consultant, Data Architecture & Engineering

AArete is one-of-a-kind when it comes to consulting firm culture.

Why AArete?

We are aglobal,innovative management and technology consulting firm, with offices in the U.S., India, and the U.K. Our name comes from the Greek word for excellence: "Arete." And excellence is exactly what we strive for.

Our success starts with enriching and empowering our people. From robust career development planning to competitive life and wellness benefits,AArete's"Culture of Care" takes a holistic approach to the employee experience. At AArete, we encourage you to unlock your full potential by directly contributing to our mission and prioritizing space for personal development and fulfillment.

The Role

The Consultant, Data Architecture & Engineering is responsible for leading and executing data architecture and engineering initiatives for various clients. You will be working closely with cross-functional teams to design, build, and maintain scalable data solutions, ensuring the highest levels of data quality and availability.

Work You'll Do

Design, develop, and deploy advanced data engineering solutions using Snowflake SQL Apply data modeling principles to ensure data integrity and optimize data structures Build scalable ETL/ELT pipelines with Apache Airflow Develop clean, efficient Python scripts for data transformation and analysis Collaborate with business stakeholders to translate their requirements into effective technical solutions Document technical processes and solutions comprehensively in Confluence Create and maintain data visualization dashboards and reports using Power BI Facilitate collaboration through Microsoft Teams and manage code versioning with BitBucket Git repositories Maintain foundational AWS infrastructure components Utilize Jira for task tracking and service ticket management

Requirements

Bachelor's degree in Computer Science, Engineering, or related field; or equivalent work experience 3 to 5 years of experience in the healthcare industry, with a deep understanding of payer industry claims data Strong knowledge of Snowflake SQL Experience with Apache Airflow Proficiency in Python programming Basic understanding of AWS infrastructure Strong experience with Data Modeling concepts Familiarity with technical writing and Confluence Experience using Git and BitBucket Proficiency in Power BI for data visualization Familiarity with Jira for service ticket management Strong verbal and written communication skills Ability to work effectively in a collaborative team environment Must be legally authorized to work in the United States without the need for employer sponsorship

Preferred Requirements Based in Chicago, IL and flexible to work from our Chicago office as needed DevOps & DataOps experience, particularly in CI/CD pipelines Pulumi Experience Writing Unit Tests Familiarity and experience with Agile (Scrum, Kanban, XP) way of working Ability to convey technical concepts to non-technical business stakeholders

Benefits

Flexible PTO, monthly half-day refuels, volunteer time off, 10 paidholidays Own Your Day flexible workpolicy Competitive majorityemployer-paidbenefits: Medical, Dental, Vision, 401KMatch Employee Stock Ownership Plan Generousmaternity/paternityleave options Completely employer paid Life Insurance, STD, LTD Charitable contribution matching program New client commission opportunities and referral bonus program Video-freeFridays Bike share discountprogram

About AArete

AArete is a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and advisory services. Our cross-industry solutions are poweredbymodern technology, market intelligence, and big data to drive purposeful change and actionable outcomes.

AArete is guided by our deeply embedded principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusi

We are proud to have earned aGreat Place to Work Certification and named one ofAmerica's Best Management Consulting Firmsby Forbes, Vault'sTop 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000'sFastest