Senior Snowflake Engineer at Mathematica, Inc.Title: Senior Snowflake Engineer
Job ID: 2174
Position Description: Mathematica applies expertise at the intersection of technology, data, methods, policy, and practice to improve well-being around the world. We collaborate closely with public- and private-sector partners to translate big questions into deep insights that improve programs, refine strategies, and enhance understanding using technology and advanced analytics. Our work yields actionable information to guide decisions in wide-ranging policy areas, from health, education, early childhood, and family support to nutrition, employment, disability, and international development.
Mathematica is seeking a Senior Data Platform Engineer to join the Health Unit's Health Solutions Insights (HSI) team. We're looking for team members who want to apply their technical skills to shape an equitable and just world, where evidence drives decisions for global impact in healthcare.
Responsibilities: Provide technical leadership to multidisciplinary teams combining data analytics, visualization, and development of analytics products such as interactive dashboards and data driven applications.Lead the design of data pipelines and perform analytics involving large administrative data sources such as state Medicaid claims and APCDs, as well as clinical data sources such as EHRs and HIEs.Incorporate client and other stakeholder needs into solution design, communication planning, and project scope.Develop a budget and staffing plan to produce the required solutions.Evaluate internal project functions and processes and suggest improvements.Collaborate across internal technology, analytics, and advisory services teams.Actively support the advancement of organizational diversity, equity, and inclusion efforts.Interface with clients for 50% or more of your time (with occasional in-person meetings).Apply excellent critical thinking and problem-solving abilities to mitigate project risk.Contribute to the growth of the business through significant proposal contributions.Requirements: At least 7 years of relevant experience demonstrating: Hands on development with Amazon Web Services (AWS) services including RDS, Lambda, S3, API Gateway, and SageMaker.In-depth programming in Python and SQL in a professional environment.Strong database, data warehousing, and data modeling skills.Extract Transform and Load (ETL) and automation experience.System development lifecycle (SDLC), Agile Development, DevSecOps, and common software development tools such as Git and Jira.Excellent written and oral communication skills.Infrastructure as Code (IaC) technologies such as AWS CloudFormation or Terraform.At least 3 years of relevant experience with big data technologies including: Spark and related tools.Snowflake, including snowflake data modeling and ETL.Snowflake query performance tuning and optimization.Snowflake administration and security.Other Snowflake capabilities/tools.Desired Skills: Microsoft Azure, particularly Azure Synapse Analytics.Healthcare Interoperability Standards and Technology.The Serverless Framework.Docker orchestration tools.Commercial data warehouse/ETL tools.Additional programming languages common at Mathematica.Conceptual and practical knowledge of healthcare data.A demonstrated history of working collaboratively with clients.Previous experience working on Data Analytics or Data Science projects.This position offers an anticipated annual base salary range of $120,000 – $160,000. This position is eligible for a discretionary bonus based on company and individual performance. To apply, please submit cover letter, resume, coding sample, location preferences, and salary requirements via our online employment website.
Available Locations: Washington, DC; Princeton, NJ; Remote
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment.
Any offer of employment will be contingent upon passing a background check.
Although Mathematica does not require vaccination from COVID-19 as a condition of employment, various projects or agencies may require documentation of vaccination.
APPLY NOW
#J-18808-Ljbffr