Data Engineer, Data Platform - IntelliScript (Remote)

Milliman•Brookfield, WI

13h•$93,700 - $177,675•Remote

About The Position

IntelliScript’s Data has been a key part of our success and is critical to our future. In this position as a 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.

Requirements

3+ years of relevant experience in design, development, and testing of Data Platform solutions, such as Data Warehouses, Data Lakes, and Data Products
Experience working in Databricks and AWS
Experience working in both relational and non-relational 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
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
Familiarity with building and deploying IAC using terraform, asset bundles and github
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

Nice To Haves

Bachelor's degree or master's degree in computer science, data engineering or related field
3+ 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

Responsibilities

Creation of a Databricks Data Warehouse(s) and Lakehouse solutions for a healthcare data focused enterprise
Configuring and maintaining unity catalog to enable enterprise data lineage and data quality
Building out Data Security protocols and best practices including the management of identified and de-identified (PHI/PII) solutions
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
You will help architect, build, and maintain robust and scalable data pipelines, monitoring, and optimizing performance
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 cloud-based ‘big data’ technologies
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
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

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 12 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