What We Do
Milliman IntelliScript is a group of a few hundred experts in fields ranging from actuarial science to information technology to clinical practice. Together we develop and deploy categorydefining datadriven softwareasaservice (SaaS) products for a broad spectrum of insurance health IT and life sciences clients. We are a business unit within Milliman Inc. a respected consultancy with offices around the world.
Candidates who have their pick of jobs are drawn to IntelliScripts entrepreneurial and collaborative culture of innovation excellence exceptional customer service balance and transparency. Every single person has a voice in our company and we challenge each other to push the outer limits of our full diverse potential. And weve shown sustained growth that ensures youll have room to grow your skillset responsibilities and career.
Our team is smart downtoearth and ready to listen to your best ideas. We reward excellence and offer competitive compensation and benefits. Visit our LinkedIn page for a closer look at our company and learn more about our cultural values here.
Milliman invests in skills training and career development and gives all employees access to a variety of learning and mentoring opportunities. Our growing number of Milliman Employee Resource Groups (ERGs) are employeeled communities that influence policy decisions develop future leaders and amplify the voices of their constituents. We encourage our employees to give back to their varied professions including leadership in professional organizations. Please visit our website to learn more about Millimans commitments to our people diversity and inclusion social impact and sustainability.
What this position entails
IntelliScripts Data has been a key part of our success and is critical to our future. In this position as a Senior Data Engineer of IntelliScripts Data Platform you will be responsible for designing and implementing robust Data Platform solutions that meet our business objectives while ensuring compliance with industryleading data privacy standards. You will collaborate closely with crossfunctional agile teams to drive data architecture decisions implement best practices and contribute to the success of our projects.
What you will be doing
- Data Platform: Creation of a Databricks Data Warehouse(s) and Lakehouse solutions for a healthcare data focused enterprise.
- Data Governance: Configuring and maintaining unity catalog to enable enterprise data lineage and data quality
- Data Security: Building out Data Security protocols and best practices including the management of identified and deidentified (PHI/PII) solutions
- External Data Products: Building data solutions for clients while upholding the best standards for reliability quality and performance
- ETL: Building solutions within Delta Live Tables and automation of transformations
- Medallion Architecture: Building out performant enterpriselevel medallion architecture(s)
- Streaming and Batch Processing: Building fitforpurpose near realtime streaming and batch solutions
- Large Data Management: Building out performant and efficient enterprise solutions for internal and external users for both structured and unstructured healthcare data
- Platform Engineering: Building out Infrastructure as Code using Terraform and Asset Bundles
- Costs: Working with the business to build cost effective and cost transparent Data solutions
- Pipeline/ETL Management: You will help architect build and maintain robust and scalable data pipelines monitoring and optimizing performance
- Experience working with Migration tools i.e. AWS DMS AWS Glue Fivetran integrate
- Identify and implement improvements to enhance data processing efficiency
- 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 cloudbased big data technologies.
- Data Modeling: 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 nonfunctional business requirements
- Develop and maintain data models ensuring they align with business objectives and data privacy regulations
- Collaboration: 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 nontechnical stakeholders and provide guidance on best practices.
- Ensure that technology aligns with business strategy and provides efficient secure solutions and systems
- Processes and Tools: Identify design and implement internal process improvements: automating manual processes optimizing data delivery redesigning 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.
What we need
- 7 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 nonrelational databases such as SQL Server PostgreSQL and MongoDB
- 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 CCDA 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)
- 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 deidentified data sets from multiple data sources
What you bring to the table
- Demonstrated lets find a way to do it attitude no task is too big or too small
- Effective collaboration and communication across multiple technical and nontechnical disciplines
- Comfortable working through ambiguous situations
- Able to teach & mentor others on new/emerging technologies
- Customer obsessed with a businesscentric focus
- Able to understand both strategic and tactical needs and balance appropriately
- Driven thorough and selfdirected
- Able to lead through influence and persuasion
Wish list
- Bachelors degree or masters degree in computer science data engineering or related field
- 10 years of relevant experience in design development and testing of Data Platform solutions such as Data Warehouses Data Lakes and Data Products
- Health and Life Insurance business experience
- Associate or Professional level solution architecture certification in Azure and/or AWS
- Experience in Snowflake
Location
The expected application deadline for this job is June 30 2025. This position is open to remote work. Applicants must be willing to travel to the Milliman office in Brookfield WI as needed and travel nationwide for meetings conferences and team events.
The salary range is $98000 $222000 depending on relevant factors including but not limited to education relevant work experience qualifications skills certifications location etc. If relevant experience is less than 10 years the range would be $98000 $198000; for experience of greater than 10 years the range would be $109000 $222000. In addition we offer a performancebased bonus plan prot sharing and generous benets.
Milliman Benefits (Full time U.S. positions only)
At Milliman we focus on creating an environment that recognizes and meets the personal and professional needs of the individual and their family. We offer competitive benefits which include the following based on plan eligibility:
- Medical dental and vision coverage for employees and their dependents including domestic partners
- A 401(k) plan with matching program and profitsharing contribution
- Employee Assistance Program (EAP)
- A discretionary bonus program
- Paid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; fulltime employees will accrue 15 days of PTO per year and employees working less than a fulltime schedule will accrue PTO at a prorated amount based on hours worked
- Family building benefits including adoption and fertility assistance and paid parental leave up to 12 weeks for employees who have worked for Milliman for at least 12 months and have worked at least 1250 hours in the preceding 12month period
- Commuter Program which allows you to use pretax dollars to pay for your parking or public transit expenses to get to and from work. You may utilize this benefit any time throughout the year and funds will be available the first of the month following your first contribution
- A minimum of eight paid holidays
- Milliman covers 100 of the premiums for life insurance AD&D and both shortterm and longterm disability coverage
- Flexible spending accounts allow employees to set aside pretax dollars to pay for dependent care transportation and applicable medical needs
Equal Opportunity
All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability or status as a protected veteran.
Required Experience:
Senior IC