Consultant, Data Architecture & Engineering

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 Inclusion.
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 Growing Firms, Consulting Magazine'sFastest 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.
• LI-DNI