Staff Data Engineer, Data Platform - IntelliScript (Remote)

Milliman • Brookfield, WI

20h • Remote

About The Position

Milliman IntelliScript is seeking a Staff Data Engineer for its Data Platform team. This role is crucial for the future success of IntelliScript's data initiatives. The Staff Data Engineer will be a trusted advisor, responsible for technical decisions and ensuring data systems function effectively across hybrid environments with a focus on scale and performance. The position involves leading technical and architecture decisions in collaboration with other teams, while adhering to industry-leading data privacy standards. Milliman IntelliScript offers an innovative, collaborative, and entrepreneurial atmosphere with opportunities for skill expansion, career advancement, and competitive compensation and benefits.

Requirements

• 15+ years of relevant experience in design, development, and testing of Data Platform solutions, such as Data Warehouses, Data Lakes, and Data Products
• Expert level experience working in Databricks and AWS
• Expert level experience working in both relational and non-relational databases such as SQL Server, PostgreSQL, DynamoDB, DocumentDB
• Experience managing and standardizing clinical data from structured and unstructured sources
• Experience building and managing solutions on AWS
• Expert knowledge in healthcare standards including FHIR, C-CDA, and traditional HL7
• Expert knowledge in clinical standards/ontologies including ICD10/SNOMED/NDC/LOINC/Rx Norm
• Expert in building out data models, data warehouses, designing of data lakes for enterprise and product use cases
• Familiarity with designing and building APIs, ETL and data ingestion processes and utilization of tools to support enterprise solutions
• Experience in performance tuning, query optimization, security, monitoring, and release management
• Experience working with and managing large, disparate, identified and de-identified data sets from multiple data sources
• Experience with building and deploying IAC using terraform, asset bundles and GitHub
• Experience collaborating with Data Science teams and building AI based solutions to drive efficiencies and business value
• Demonstrated “let’s find a way to do it” attitude – no task is too big or too small
• Effective collaboration and communication across multiple technical and non-technical disciplines
• Comfortable working through ambiguous situations
• Able to teach & mentor others on new/emerging technologies
• Customer obsessed with a business-centric focus
• Able to understand both strategic and tactical needs and balance appropriately
• Driven, thorough and self-directed
• Able to lead through influence and persuasion
• Curiosity to explore industry trends and drive the organization to utilize fit for purpose solutions

Nice To Haves

• Bachelor's degree or master's degree in computer science, data engineering or related field
• Health and Life Insurance business experience
• Professional level solution architecture certification in AWS

Responsibilities

• Acts as a subject matter expert and thought leader within the Data Platform Domain
• Serves as a thought leader in data processing design and implementation, defining advanced structure for moving, storing, and maintaining high-quality data.
• Leads projects by managing timelines, coordinating teams, and communicating project statuses.
• Influences organizational direction through effective leadership and strategic collaboration
• Serves as a subject matter expert on governance standards, continuously aligning data practices with evolving industry best practices and requirements
• Contributes to defining the overall vision and strategy for data engineering within the organization, ensuring alignment with organizational goals and long-term objectives
• Establishes visionary goals, advises on strategic plans, employs advanced monitoring, influences high-level stakeholders, and delivers transformative results
• Expansion of our Data Warehouse(s) and Lakehouse solutions for a healthcare data focused enterprise
• Configuring and maintaining unity catalog to enable enterprise data lineage, data quality, auditability and data stewardship
• Building out Data Security protocols and best practices including the management of identified and de-identified (PHI/PII) solutions
• Always ensure a policy of least privilege is followed for anything being implemented
• Building data solutions for clients while upholding the best standards for reliability, quality, and performance
• Building solutions within Delta Live Tables and automation of transformations
• Building out performant enterprise-level medallion architecture(s)
• Building fit-for-purpose near real-time streaming and batch solutions
• Building out performant and efficient enterprise solutions for internal and external users for both structured and unstructured healthcare data
• Building out Infrastructure as Code using Terraform and Asset Bundles
• Working with the business to build cost effective and cost transparent Data solutions
• Architect, build, and maintain robust and scalable data pipelines, monitoring, and optimizing performance
• Help architect, build, and maintain robust and scalable data pipelines, monitoring, and optimizing performance
• Experience working with Migration tools i.e. Fivetran, AWS technologies and custom solutions
• Identify and implement improvements to enhance data processing efficiency
• Design and implement reliable and resilient Event Driven data processing
• Experience with building out effective pipeline monitoring solutions
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Delta Live Tables, Python, Scala, and cloud-based ‘big data’ technologies
• Drive our design and implementation of internal APIs for integrating data between different systems and applications
• Develop APIs built on top of datasets for internal systems to consume data from Databricks
• Experience integrating with external APIs including but not limited to Salesforce, Financial systems, HR systems and other external systems
• Lead design, implementation, and maintenance of standards based (FHIR, OMOP, etc.) and efficient data models for both structured and unstructured data
• Assemble large, complex data sets that meet functional and non-functional business requirements
• Develop and maintain data models, ensuring they align with business objectives and data privacy regulations
• Partner internally and externally with key stakeholders to ensure we are providing meaningful, functional, and valuable data
• Effectively work with Data, Development, Analysts, Data Science, and Business team members to gather requirements, propose, and build solutions.
• Communicate complex technical concepts to non-technical stakeholders and provide guidance on best practices.
• Ensure that technology execution aligns with business strategy and provides efficient, secure solutions and systems
• Gather requirements and build out project plans to implement those requirements with forecasted efforts to implement
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build analytics tools that utilize the data pipeline to provide actionable insights into operational efficiency and other key business performance metrics.
• Create data tools for clinical, analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Lead investigation of new tooling, develop implementation plans, and deployment of necessary tooling

Benefits

• Medical, Dental and Vision – Coverage for employees, dependents, and domestic partners
• Employee Assistance Program (EAP) – Confidential support for personal and work-related challenges
• 401(k) Plan – Includes a company matching program and profit-sharing contributions
• Discretionary Bonus Program – Recognizing employee contributions
• Flexible Spending Accounts (FSA) – Pre-tax savings for dependent care, transportation, and eligible medical expenses
• Paid Time Off (PTO) – Begins accruing on the first day of work. Full-time employees accrue 15 days per year, and employees working less than full-time accrue PTO on a prorated basis
• Holidays – A minimum of 10 paid holidays per year
• Family Building Benefits – Includes adoption and fertility assistance
• Paid Parental Leave – Up to 11 weeks of paid leave for employees who meet eligibility criteria
• Life Insurance & AD&D – 100% of premiums covered by Milliman
• Short-Term and Long-Term Disability – Fully paid by Milliman

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree