Senior Data Engineer

Summary

Join Gravie's growing data team as a Senior Data Engineer and play a pivotal role in designing, building, and maintaining scalable data pipelines and solutions for our healthcare insurance analytics and operations. Leverage your expertise in data engineering best practices, cloud technologies (AWS), and visualization platforms (Tableau) to deliver high-quality data assets. Your deep understanding of healthcare data and the insurance landscape will be essential. You will lead data model implementation, develop and optimize data pipelines, implement data governance best practices, build data solutions within the AWS ecosystem, and manage data workflows using Apache Airflow. Collaborate with data analysts and stakeholders to meet reporting and analytical needs, and troubleshoot data-related issues. This role requires a strong background in data engineering, healthcare data, and AWS technologies.

Requirements

• Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related quantitative field
• 5+ years of progressive experience as a Data Engineer, with a strong focus on data modeling, data pipeline development, and data management
• Minimum 2+ years of experience working specifically within the healthcare insurer industry, with a solid understanding of claims data, enrollment data, provider data, clinical data, and related healthcare datasets
• Proficiency in designing and implementing data models (e.g., star schemas, snowflake schemas, 3NF)
• Extensive experience with AWS data services (e.g., S3, Redshift, Glue, EMR, Athena, Lambda, Kinesis, Lake Formation)
• Strong experience with Apache Airflow for workflow orchestration, scheduling, and monitoring
• Proficient in SQL for complex data manipulation, querying, and optimization
• Experience with at least one scripting/programming language for data engineering tasks (e.g., Python, Scala)
• Hands-on experience supporting reporting and analytics teams with data preparation and optimization for tools like Tableau. (Direct Tableau development experience is a plus, but primarily focus on data enablement)
• Experience with data warehousing concepts and technologies
• Familiarity with data governance principles and healthcare data privacy regulations (e.g., HIPAA)
• Excellent problem-solving skills and attention to detail
• Strong communication and collaboration skills, with the ability to translate technical concepts to non-technical stakeholders
• You must be eligible to work in the United States without need of sponsorship now or in the future

Responsibilities

• Lead the design and implementation of efficient, scalable, and well-documented data models (dimensional, relational, and potentially NoSQL) for various analytical and reporting needs within a healthcare insurance context
• Develop, optimize, and maintain complex data pipelines using various tools and technologies, ensuring data quality, integrity, and timely delivery
• Implement and enforce data governance best practices, including data lineage, metadata management, data quality checks, and data security protocols specific to healthcare regulations (e.g., HIPAA)
• Design, build, and optimize data solutions within the AWS ecosystem (e.g., S3, Redshift, Glue, EMR, Athena, Lambda, Kinesis), ensuring cost-effectiveness and performance
• Develop, manage, and monitor data workflows using Apache Airflow to automate data ingestion, transformation, and loading processes
• Collaborate closely with data analysts, business intelligence developers, and business stakeholders to understand reporting and analytical requirements and provide robust data foundations
• Identify and resolve data performance bottlenecks, ensuring efficient query execution and data retrieval for various use cases
• Promote and enforce best practices in data engineering, including version control, testing, documentation, and code reviews
• Troubleshoot complex data-related issues, identify root causes, and implement sustainable solutions

Preferred Qualifications

• Experience with other BI tools or data visualization platforms
• Knowledge of Big Data technologies beyond AWS native services (e.g., Spark, Hadoop)
• Experience with real-time data streaming technologies
• Familiarity with CI/CD practices for data pipelines
• Relevant AWS certifications (e.g., AWS Certified Data Analytics – Specialty, AWS Certified Solutions Architect – Associate)

Benefits

• Standard health and wellness benefits
• Alternative medicine coverage
• Flexible PTO
• Up to 16 weeks paid parental leave
• Paid holidays
• A 401k program
• Cell phone reimbursement
• Transportation perks
• Education reimbursement
• 1 week of paid paw-ternity leave