Senior Data Engineer

Summary

Join MediSpend, a market leader in life science compliance solutions, as a Senior Data Engineer. You will collaborate with clients and internal teams to design, operate, and enhance data integration and management platforms. Responsibilities include gathering client requirements, designing data transformations, working with Client Operations on implementation efforts, evaluating new data management tools, troubleshooting integrations, conducting peer code reviews, building data migration frameworks, monitoring infrastructure, and analyzing data transformation success rates. You will leverage your expertise in data integration platforms, Python-based data orchestration, RDBMS and other data warehousing platforms, and project management tools. This remote position offers a competitive salary, bonus, unlimited PTO, 401k matching, comprehensive health benefits, paid parental leave, and various wellness perks.

Requirements

• Skilled collaborator and data management/transformation architect/designer/developer who can effectively partner with clients to define and deliver robust solutions
• Excellent, hands-on knowledge of data integration platforms across commercial, cloud service, and/or open source distributions
• Many success stories of data integrations with typical enterprise systems including ERP, CRM, Expense Management, MDM, data warehouses, etc., using both batch and API methods
• Substantial programming experience with Python based data orchestration and transformation frameworks (i.e. Airflow, AWS Glue, Prefect, Dagster, Spark, Polars, Databricks, etc.)
• Strong working knowledge of traditional RDBMS data warehousing as well as other platforms like Snowflake, RedShift
• Experienced using standard project management tools (Jira) and processes to organize and advance task flows
• Experience mentoring other data engineers to adopt design and implementation best practices
• Substantial experience curating data for use in SaaS distributed applications, not internal data science use cases
• Passion for data driven approach to monitor and optimize operational processes and data flows is part of your DNA

Responsibilities

• Attend a technical working meeting with a client to gather requirements and design the integration of a new data source into MediSpend systems
• Design and build a new data transformation to support the addition of a new data source for the analytics platform
• Work closely with Client Operations to estimate levels of effort to support a prospective client implementation
• Evaluate a new open source data management tool or cloud service for possible adoption
• Assist one of the data engineers to determine root cause for a failed integration the previous night
• Conduct peer review for other data engineers code check-ins
• Design and build a data migration framework to move data from one portfolio product to another
• Monitor infrastructure capacity of the data transformation platform and make a recommendation to increase the configuration specification
• Compile and analyze last month’s data transformation success/failure rates and recommend a technical improvement

Benefits

• Competitive base salary plus bonus
• Work from anywhere – Roles are open to candidates located anywhere in the U.S (United States)
• Unlimited PTO (Paid Time Off), including Paid Holidays and Sick Leave
• 401k+ Match
• Comprehensive health, dental, and vision insurance
• Paid Parental Leave
• Health and wellness perks including life & disability insurance, healthcare funding options like FSAs (Flexible Spending Accounts) and HSAs (Health Savings Account), Dependent Care, an EAP (Employee Assistance Program) program, discounts, Learning and Development, internet and cellphone stipends