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: https://www.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, resume, coding sample, location preferences, and salary requirements via our online employment website.

STAFFING AGENCIES AND THIRD-PARTY RECRUITERS:

Mathematica is not accepting candidates for this role or any technical role from staffing agencies or third-party recruiters. Please do not contact technical or senior staff at Mathematica or share unsolicited resumes. All agency inquiries go through the talent acquisition team and will be routed accordingly.

Staff in our Health unit will eventually work with our largest client, Centers for Medicaid & Medicare Services (CMS). Most staff working on CMS contracts will be required to complete a successful background investigation including the Questionnaire for Public Trust Position SF-85. Staff that are unable to successfully undergo the background investigation will need to be able to obtain work outside CMS. Staff will work with their supervisor to get re-staffed, however if they are unable to do so it may result in employment termination due to lack of work.

Available Locations:

Washington, DC; Princeton, NJ; Remote

#remote-usa

#LI-AR1

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.