Senior Snowflake Engineer

Title: Senior Snowflake Engineer

Job Description

APPLY NOW

Senior Snowflake Engineer – Remote Eligible

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

At Mathematica, we understand the importance of building relationships with colleagues. If you’re not located near one of our offices but would like opportunities to meet up with co-workers, we offer coworking spaces where available. Ask your Talent Acquisition partner for more information about this opportunity and whether it’s an option in your area.

Any offer of employment will be contingent upon passing a background check. Various federal agencies with whom we contract require that staff successfully undergo security clearance as a condition of working on the project. If you are assigned to such a project, you will be required to obtain the requisite security clearance. Additionally, if you participate in/complete the application process and are denied, Mathematica may choose to terminate your employment.

Although Mathematica does not require vaccination from COVID-19 as a condition of employment, various projects or agencies may require documentation of vaccination (or an approved exception/accommodation).

We take pride in our employees and in their commitment to excellence. We encourage staff to collaborate in developing creative solutions to difficult problems and to share the responsibility and enjoyment of carrying out complex projects. This collegial spirit has helped us earn our reputation for innovative and high quality work.

One of Mathematica’s core values is a deep commitment to diversity, equity, and inclusion. Our work is more robust because it is informed by a variety of diverse perspectives, and our mission to improve societal well-being is strengthened by a greater understanding of issues and challenges facing the populations we serve. Mathematica’s ongoing commitment to diversity and inclusion is woven into our everyday actions, policies, and practices—including decisions regarding recruitment, training, compensation, and promotion. We are dedicated to maintaining a work environment in which everyone is treated with respect and dignity.

APPLY NOW

Jobs By Category

Jobs By Location

Remote Jobs

Share this job

• Facebook
• X
• LinkedIn
• Email

Log in and search jobs that match your profile

Our Stories

Benefits At a Glance

Do you need assistance?

If you need an accommodation due to a disability to complete any part of the application or interview process (if selected), you can request an accommodation by contacting the Human Resources Department humanresources@mathematica-mpr.com or 609-799-3535. Accommodations are considered on a case-by-case basis.

EEO is the Law

Click here to learn more about your rights as an applicant.

About this location

Check out where you could be working before you apply.

VIEW MAP