Senior Snowflake Engineer - Remote Eligible

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 offers our employees competitive salaries, and a comprehensive benefits package, as well as the advantages of being 100 percent employee owned. As an employee stock owner, you will experience financial benefits of ESOP holdings that have increased in tandem with the company's growth and financial strength. You will also be part of an independent, employee-owned firm that is able to define and further our mission, enhance our quality and accountability, and steadily grow our financial strength. Read more about our benefits here: /mathematica.org/career-opportunities/benefits-at-a-glance

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.

Examples of recent work completed by this team include:

• As part of the AI Health Outcomes Challenge held by Centers for Medicare and Medicaid Services, members of this team developed a cloud data pipeline and machine learning architecture to make predictions with a large multiyear sample of Medicare beneficiaries with detailed claims data about millions of people. Mathematica's team reached the second round of the competition, with only six other teams, out of over 300 original entrants.
• As part of a state's efforts to support citizens with disabilities, Mathematica brought together a variety of data sources, developed specific monitoring measures, and designed a dashboard. The dashboard is designed to show measure results and trends to clearly identify areas of success and opportunities for improvement to help the state achieve its goals with evidence-based decision making.
• Developed applications and extract, transform, and load (ETL) processes to support a variety of health policy implementation and monitoring programs. One such program was the Capacity Building for Public Health Analysts in the Overdose Response Strategy, where the team designed, developed, and secured a cloud-based, web application to streamline data collection, management, and reporting for the public health-public safety collaboration to reduce drug overdoses.

Position Requirements:

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, to effectively answer research questions about health care policy.
• 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 in context of internal / external constraints and Mathematica's contractual and regulatory requirements.
• 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, and apply diversity, equity, and inclusion lens across job responsibilities.
• 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 (expressions of interest, planning / design, content, budget staffing, successfully directing projects, etc.)

Requirements:

/At least 7 years of relevant experience demonstrating:/

• Hands on development with Amazon Web Services (AWS) services commonly used by our team 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 to convey key choices, recommendations, and technology concepts to technical and non-technical audiences.
• Infrastructure as Code (IaC) technologies such as AWS CloudFormation or Terraform

/At least 3 years of relevant experience with big data technologies including:/

• Spark, the Spark ecosystem, and related tools like Databricks and Azure Synapse Notebooks
• Snowflake, including snowflake data modeling and ETL
• Snowflake query performance tuning, query trouble shooting, index design, and query plan optimization and analysis
• Snowflake cost optimization including virtual warehouse sizing and resource monitors
• Snowflake administration and security, as well as general data security concepts, such as RBAC controls, securing sensitive data such as PII/PHI, encryption in transit and at rest.
• Other Snowflake capabilities / Tools like zero copy clone, time travel, events, SnowSQL, and SnowPipe.

Desired Skills:

• Microsoft Azure, particularly Azure Synapse Analytics, Azure Data Factory and/or Azure Data Pipeline
• Healthcare Interoperability Standards and Technology, such as HL7, FHIR, Intersystems Iris for Health, Rhapsody, MirthConnect
• The Serverless Framework
• Docker orchestration tools, like Docker Compose or Kubernetes
• Commercial data warehouse/ ETL tools such as, Talend, Informatica, Apache Airflow, etc.
• Additional programming languages common at Mathematica like .NET, JavaScript, TypeScript, or R
• Conceptual and practical knowledge of healthcare data (e.g. clinical data, commercial claims, hospital claims, Medicare, Federal Medicaid (T-MSIS, TAF), State Medicaid, HL7-FHIR), healthcare informatics, or healthcare claims processing
• A demonstrated history of working collaboratively with clients to achieve project goals and / or leading technical teams
• Previous experience working or collaborating on Data Analytics or Data Science projects or initiatives

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, resum.