Title: Decision Analytics Associate Consultant Location: Evanston United States Job Description: Insights & Analytics Decision Analytics $117,500.00 - $133,250.00 Comp package offers min/max salary + COLA, leave policies, bonus incentives, relo, med/den/life ins, retirement benefits. 31312 ZS is a place where passion changes lives. As a management consulting and technology firm focused on improving life and how we live it, we transform ideas into impact by bringing together data, science, technology and human ingenuity to deliver better outcomes for all. Here you’ll work side-by-side with a powerful collective of thinkers and experts shaping life-changing solutions for patients, caregivers and consumers, worldwide. ZSers drive impact by bringing a client-first mentality to each and every engagement. We partner collaboratively with our clients to develop custom solutions and technology products that create value and deliver company results across critical areas of their business. Bring your curiosity for learning, bold ideas, courage and passion to drive life-changing impact to ZS. Insights & Analytics ZS's Insights & Analytics group partners with clients to design and deliver solutions to help them tackle a broad range of business challenges. Our teams work on multiple projects simultaneously, leveraging advanced data analytics and problem-solving techniques. Our recommendations and solutions are based on rigorous research and analysis underpinned by deep expertise and thought leadership.    What You’ll Do - Collaborate with client teams to solve dynamic business issues using analytics, modeling, and storytelling as tools. - Design custom analytical approaches with a broader ZS team to address specific client business needs. - Synthesize and communicate results concisely to clients and ZS teams through oral and written presentations in PowerPoint or through whiteboarding. - Develop client relationships and serve as key point of contact on aspects of projects. - Provide client and ZS teams project status updates proactively on a regular basis. - Create project deliverables and implement solutions. - Advance problem-solving skills and improve ZS’s capabilities. - Guide and mentor Associates on teams. What You’ll Bring - Bachelor's or master's degree required in any discipline with strong record of academic success in quantitative and analytic coursework such as operations research, applied mathematics, management science, data science, statistics, econometrics or engineering. - 2-4 years of relevant post-collegiate job experience. A PhD may substitute in lieu of work experience. - Strong advanced knowledge of Excel including: pivot tables, conditional formulas, index matching, VLOOKUP/XLOOKUP, intelligent data visualization, automation tasks, etc. - Preferred knowledge of one or multiple of the following, and an aptitude to develop more skills on the job: SQL, Python, R, PowerBI, Tableau, VBA in Excel - High motivation, good work ethic, proactivity, maturity and personal initiative. - Exemplary accountability and ownership of tasks. - Strong and concise oral and written communication skills. - Empathy, adaptability, receptive to listening, and high emotional intelligence. - Close attention to detail, with a quality-focused mindset, looking for ways to consistently promote high quality assurance and control best practices across teams. - Self-discipline for planning and organizing tasks for yourself and any junior team members. - Aptitude for, and enjoyment of, working in teams - Fluency in English - Client-first mentality - Intense work ethic - Collaborative spirit and problem-solving approach How you’ll grow: - Cross-functional skills development & custom learning pathways - Milestone training programs aligned to career progression opportunities - Internal mobility paths that empower growth via s-curves, individual contribution and role expansions Perks & Benefits: ZS offers a comprehensive total rewards package including health and well-being, financial planning, annual leave, personal growth and professional development. Our robust skills development programs, multiple career progression options and internal mobility paths and collaborative culture empowers you to thrive as an individual and global team member. Hybrid working model: We are committed to giving our employees a flexible and connected way of working. A flexible and connected ZS allows us to combine work from home and on-site presence at clients/ZS offices for the majority of our week. The magic of ZS culture and innovation thrives in both planned and spontaneous face-to-face connections. Travel: Travel is a requirement at ZS for client facing ZSers; business needs of your project and client are the priority. While some projects may be local, all client-facing ZSers should be prepared to travel as needed. Travel provides opportunities to strengthen client relationships, gain diverse experiences, and enhance professional growth by working in different environments and cultures. Considering applying? At ZS, we honor the visible and invisible elements of our identities, personal experiences, and belief systems—the ones that comprise us as individuals, shape who we are, and make us unique. We believe your personal interests, identities, and desire to learn are integral to your success here. We are committed to building a team that reflects a broad variety of backgrounds, perspectives, and experiences. Learn more about our inclusion and belonging efforts and the networks ZS supports to assist our ZSers in cultivating community spaces and obtaining the resources they need to thrive. If you’re eager to grow, contribute, and bring your unique self to our work, we encourage you to apply. ZS is an equal opportunity employer and is committed to providing equal employment and advancement opportunities without regard to any class protected by applicable law. To complete your application: Candidates must possess or be able to obtain work authorization for their intended country of employment. An on-line application, including a full set of transcripts (official or unofficial), is required to be considered. NO AGENCY CALLS, PLEASE.

• lead the design, development, and evolution of our enterprise analytics platform • blend hands-on technical ownership with team leadership • own critical components of our Data Vault 2.0 warehouse on Snowflake • mentor a growing team of Analytics Engineers • serve as the connective layer between raw operational data and business critical insights • work across the full analytics stack—from staging and raw vault to business vault, prime stage, and client specific information marts • deliver clean, tested, and well documented models that support finance, operations, and compliance reporting

Role Description We are looking for a skilled DBT (Data Build Tool) Data Engineer to design, build, and optimize modern data transformation pipelines. The ideal candidate has strong SQL skills, hands-on experience with cloud data warehouses, and a solid understanding of data modeling and ELT best practices. You will work closely with analytics, data science, and business teams to deliver clean, reliable, and well-documented data models. Key Responsibilities - Data Modeling & DBT Development: - Develop and maintain DBT models (staging, intermediate, mart layers) following modular design and best practices. - Implement dbt tests, documentation, sources, macros, and packages. - Build reusable and scalable data transformation frameworks. - Data Pipeline Engineering: - Design and optimize ELT workflows using DBT integrated with orchestrators (Airflow, Dagster, Prefect, etc.). - Work with cloud data environments such as Snowflake, BigQuery, Redshift, Databricks. - Ensure high performance of SQL transformations and warehouse queries. - Data Quality & Governance: - Implement and maintain data quality tests within DBT (unique, not null, referential integrity). - Contribute to version control, CI/CD, documentation standards, and best practices. - Collaboration & Stakeholder Support: - Work with analysts and business teams to understand requirements and convert them into scalable data models. - Support data consumers with well-structured data and documentation (dbt docs). - Participate in code reviews and provide engineering guidance. Qualifications - 3+ years’ experience in Data Engineering / ELT development. - Strong SQL proficiency, with experience writing optimized queries. - Hands-on experience with DBT Core or DBT Cloud. - Experience with any cloud data warehouse: Snowflake, BigQuery, Redshift, Azure Synapse. - Familiarity with Git, CI/CD pipelines, and modern data stack principles. - Understanding of data modeling techniques (Kimball, Data Vault, Star/Snowflake). - Experience integrating DBT with orchestrators (Airflow, Dagster, Prefect, etc.). Company Description Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. - For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes. - Datavail is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. - Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. - Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. - Datavail’s data intelligence consultants are experienced, knowledgeable, and certified in the best in breed BI and analytics software applications and technologies. - Our proven methodology can help your project succeed, regardless of stage. - With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. - Datavail’s flexible and client-focused services always add value to your organization.

• Supports the Bluhm Cardiovascular Institute (BCVI) • Uncovers insights that drive strategy and optimal decision making for the executive team • Works cross-functionally to realize the value of NM’s data assets • Responsible for delivering data warehouse and analytic solutions by writing ETL packages, developing visualizations, performing data and statistical analyses, and administering systems • Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures • Assists with the design and development of information delivery components including dashboards, reports, and cubes • Evaluates data quality and interprets results in a clear, concise manner • Owns analytics projects and collaborates with the business to gather and execute on requirements