Milliman
Senior Data Engineer, Data Platform - IntelliScript (Remote)
Milliman, Brookfield, Wisconsin, United States, 53045
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 category-defining, data-driven, software-as-a-service (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 IntelliScript's 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 we've shown sustained growth that ensures you'll have room to grow your skillset, responsibilities, and career.
Our team is smart, down-to-earth, 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 employee-led 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 Milliman's commitments to our people, diversity and inclusion, social impact, and sustainability.
What this position entails
IntelliScript's Data has been a key part of our success and is critical to our future.In this position as a Senior Data Engineer of IntelliScript's Data Platform, you will be responsible for designing and implementing robust Data Platform solutions that meet our business objectives while ensuring compliance with industry-leading data privacy standards. You will collaborate closely with cross-functional 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 qualityData Security:
Building out Data Security protocols and best practices including the management of identified and de-identified (PHI/PII) solutionsExternal Data Products:
Building data solutions for clients while upholding the best standards for reliability, quality, and performanceETL:
Building solutions within Delta Live Tables and automation of transformationsMedallion Architecture:
Building out performant enterprise-level medallion architecture(s)Streaming and Batch Processing:
Building fit-for-purpose near real-time streaming and batch solutionsLarge Data Management:
Building out performant and efficient enterprise solutions for internal and external users for both structured and unstructured healthcare dataPlatform Engineering:
Building out Infrastructure as Code using Terraform and Asset BundlesCosts:
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 performanceExperience working with Migration tools i.e., AWS DMS, AWS Glue, Fivetran, integrate.ioIdentify and implement improvements to enhance data processing efficiencyExperience with building out effective pipeline monitoring solutionsBuild 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.
Data Modeling:
Lead design, implementation, and maintenance of standards based (FHIR, OMOP, etc.) and efficient data models for both structured and unstructured dataAssemble large, complex data sets that meet functional and non-functional business requirementsDevelop 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 dataEffectively 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
Processes and Tools:
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.
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 ProductsExpert level experience working in Databricks and AWSExpert level experience working in both relational and non-relational databases such as SQL Server, PostgreSQL, and MongoDBExperience managing and standardizing clinical data from structured and unstructured sourcesExperience building and managing solutions on AWSExpert knowledge in healthcare standards including FHIR, C-CDA, and traditional HL7Expert knowledge in clinical standards/ontologies including ICD10/SNOMED/NDC/LOINC/Rx NormExpert 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 de-identified data sets from multiple data sourcesWhat you bring to the table
Demonstrated "let's find a way to do it" attitude - no task is too big or too smallEffective collaboration and communication across multiple technical and non-technical disciplinesComfortable working through ambiguous situationsAble to teach & mentor others on new/emerging technologiesCustomer obsessed with a business-centric focusAble to understand both strategic and tactical needs and balance appropriatelyDriven, thorough and self-directedAble to lead through influence and persuasionWish list
Bachelor's degree or master's degree in computer science, data engineering or related field10+ years of relevant experience in design, development, and testing of Data Platform solutions, such as Data Warehouses, Data Lakes, and Data ProductsHealth and Life Insurance business experienceAssociate or Professional level solution architecture certification in Azure and/or AWSExperience in SnowflakeLocation
The expected application deadline for this job is February 28, 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 $98,000 - $222,000, 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 $98,000 - $198,000; for experience of greater than 10 years, the range would be $109,000 - $222,000. In addition, we offer a performance-based bonus plan, profit sharing, and generous benefits.
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 partnersA 401(k) plan with matching program, and profit-sharing contributionEmployee Assistance Program (EAP)A discretionary bonus programPaid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; full-time employees will accrue 15 days of PTO per year, and employees working less than a full-time schedule will accrue PTO at a prorated amount based on hours workedFamily 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 1,250 hours in the preceding 12-month periodCommuter Program, which allows you to use pre-tax 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 contributionA minimum of eight paid holidaysMilliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disability coverageFlexible spending accounts allow employees to set aside pre-tax 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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
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 category-defining, data-driven, software-as-a-service (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 IntelliScript's 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 we've shown sustained growth that ensures you'll have room to grow your skillset, responsibilities, and career.
Our team is smart, down-to-earth, 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 employee-led 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 Milliman's commitments to our people, diversity and inclusion, social impact, and sustainability.
What this position entails
IntelliScript's Data has been a key part of our success and is critical to our future.In this position as a Senior Data Engineer of IntelliScript's Data Platform, you will be responsible for designing and implementing robust Data Platform solutions that meet our business objectives while ensuring compliance with industry-leading data privacy standards. You will collaborate closely with cross-functional 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 qualityData Security:
Building out Data Security protocols and best practices including the management of identified and de-identified (PHI/PII) solutionsExternal Data Products:
Building data solutions for clients while upholding the best standards for reliability, quality, and performanceETL:
Building solutions within Delta Live Tables and automation of transformationsMedallion Architecture:
Building out performant enterprise-level medallion architecture(s)Streaming and Batch Processing:
Building fit-for-purpose near real-time streaming and batch solutionsLarge Data Management:
Building out performant and efficient enterprise solutions for internal and external users for both structured and unstructured healthcare dataPlatform Engineering:
Building out Infrastructure as Code using Terraform and Asset BundlesCosts:
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 performanceExperience working with Migration tools i.e., AWS DMS, AWS Glue, Fivetran, integrate.ioIdentify and implement improvements to enhance data processing efficiencyExperience with building out effective pipeline monitoring solutionsBuild 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.
Data Modeling:
Lead design, implementation, and maintenance of standards based (FHIR, OMOP, etc.) and efficient data models for both structured and unstructured dataAssemble large, complex data sets that meet functional and non-functional business requirementsDevelop 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 dataEffectively 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
Processes and Tools:
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.
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 ProductsExpert level experience working in Databricks and AWSExpert level experience working in both relational and non-relational databases such as SQL Server, PostgreSQL, and MongoDBExperience managing and standardizing clinical data from structured and unstructured sourcesExperience building and managing solutions on AWSExpert knowledge in healthcare standards including FHIR, C-CDA, and traditional HL7Expert knowledge in clinical standards/ontologies including ICD10/SNOMED/NDC/LOINC/Rx NormExpert 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 de-identified data sets from multiple data sourcesWhat you bring to the table
Demonstrated "let's find a way to do it" attitude - no task is too big or too smallEffective collaboration and communication across multiple technical and non-technical disciplinesComfortable working through ambiguous situationsAble to teach & mentor others on new/emerging technologiesCustomer obsessed with a business-centric focusAble to understand both strategic and tactical needs and balance appropriatelyDriven, thorough and self-directedAble to lead through influence and persuasionWish list
Bachelor's degree or master's degree in computer science, data engineering or related field10+ years of relevant experience in design, development, and testing of Data Platform solutions, such as Data Warehouses, Data Lakes, and Data ProductsHealth and Life Insurance business experienceAssociate or Professional level solution architecture certification in Azure and/or AWSExperience in SnowflakeLocation
The expected application deadline for this job is February 28, 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 $98,000 - $222,000, 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 $98,000 - $198,000; for experience of greater than 10 years, the range would be $109,000 - $222,000. In addition, we offer a performance-based bonus plan, profit sharing, and generous benefits.
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 partnersA 401(k) plan with matching program, and profit-sharing contributionEmployee Assistance Program (EAP)A discretionary bonus programPaid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; full-time employees will accrue 15 days of PTO per year, and employees working less than a full-time schedule will accrue PTO at a prorated amount based on hours workedFamily 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 1,250 hours in the preceding 12-month periodCommuter Program, which allows you to use pre-tax 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 contributionA minimum of eight paid holidaysMilliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disability coverageFlexible spending accounts allow employees to set aside pre-tax 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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)