Consultant, Data Architecture & Engineering

Consultant, Data Architecture & Engineering

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

Why AArete?

We are a global, 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

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

Requirements

1. Bachelor's degree in Computer Science, Engineering, or related field; or equivalent work experience.
2. 3 to 5 years of experience in the healthcare industry, with a deep understanding of payer industry claims data.
3. Strong knowledge of Snowflake SQL.
4. Experience with Apache Airflow.
5. Proficiency in Python programming.
6. Basic understanding of AWS infrastructure.
7. Strong experience with Data Modeling concepts.
8. Familiarity with technical writing and Confluence.
9. Experience using Git and BitBucket.
10. Proficiency in Power BI for data visualization.
11. Familiarity with Jira for service ticket management.
12. Strong verbal and written communication skills.
13. Ability to work effectively in a collaborative team environment.

Preferred Requirements

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

Benefits

1. Flexible PTO, monthly half-day refuels, volunteer time off, 10 paid holidays.
2. Own Your Day flexible work policy.
3. Competitive majority employer-paid benefits: Medical, Dental, Vision, 401K Match.
4. Employee Stock Ownership Plan.
5. Generous maternity/paternity leave options.
6. Completely employer paid Life Insurance, STD, LTD.
7. Charitable contribution matching program.
8. New client commission opportunities and referral bonus program.
9. Video-free Fridays.
10. Bike share discount program.

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 powered by modern 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 Inclusion.

We are proud to have earned a Great Place to Work Certification and named one of America's Best Management Consulting Firms by Forbes, Vault's Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000's Fastest Growing Firms, Consulting Magazine's Fastest Growing Firms.

AAP/EEO Statement

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.