Consultant, Data Architecture & Engineering

DescriptionConsultant, Data Architecture & EngineeringAArete 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 RoleThe 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 DoDesign, develop, and deploy advanced data engineering solutions using Snowflake SQLApply data modeling principles to ensure data integrity and optimize data structuresBuild scalable ETL/ELT pipelines with Apache AirflowDevelop clean, efficient Python scripts for data transformation and analysisCollaborate with business stakeholders to translate their requirements into effective technical solutionsDocument technical processes and solutions comprehensively in ConfluenceCreate and maintain data visualization dashboards and reports using Power BIFacilitate collaboration through Microsoft Teams and manage code versioning with BitBucket Git repositoriesMaintain foundational AWS infrastructure componentsUtilize Jira for task tracking and service ticket managementRequirementsBachelor's degree in Computer Science, Engineering, or related field; or equivalent work experience3 to 5 years of experience in the healthcare industry, with a deep understanding of payer industry claims dataStrong knowledge of Snowflake SQLExperience with Apache AirflowProficiency in Python programmingBasic understanding of AWS infrastructureStrong experience with Data Modeling conceptsFamiliarity with technical writing and ConfluenceExperience using Git and BitBucketProficiency in Power BI for data visualizationFamiliarity with Jira for service ticket managementStrong verbal and written communication skillsAbility to work effectively in a collaborative team environmentMust be legally authorized to work in the United States without the need for employer sponsorshipPreferred RequirementsBased in Chicago, IL and flexible to work from our Chicago office as neededDevOps & DataOps experience, particularly in CI/CD pipelinesPulumi ExperienceWriting Unit TestsFamiliarity and experience with Agile (Scrum, Kanban, XP) way of workingAbility to convey technical concepts to non-technical business stakeholdersBenefitsFlexible PTO, monthly half-day refuels, volunteer time off, 10 paidholidaysOwn Your Day flexible workpolicyCompetitive majorityemployer-paidbenefits: Medical, Dental, Vision, 401KMatchEmployee Stock Ownership PlanGenerousmaternity/paternityleave optionsCompletely employer paid Life Insurance, STD, LTDCharitable contribution matching programNew client commission opportunities and referral bonus programVideo-freeFridaysBike share discountprogramAbout AAreteAArete 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 StatementAll 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