Milliman SkySail is looking for a Senior Analytics Engineer to join our team. Your role will be to support our Analysts within our data platform, with a focus on ingesting, transforming, and presenting data within the Databricks platform.

Milliman Skysail is a consulting and software-as-a-service (SaaS) unit of Milliman that leads the way in pharmacy claims analysis and reporting. SkySail Rx was founded in 2015 and acquired by Milliman in 2021. We are a fast-growing team of around fifty expert individual contributors. We specialize in analyzing pharmaceutical claims, data engineering, and application development. We place a strong emphasis on individual contribution and continuous learning.

By joining our data platform team as a Senior Analytics Engineer, you will play a critical role in bridging the gap between complex data environments and actionable business insights. By enhancing our data platform's capabilities, you'll enable Analysts to extract meaningful patterns, trends, and metrics from vast datasets. Within our organization, SQL is used extensively and will be an important tool for you in preparing data to be utilized in Semantic Layers by Analysts and the Applications they use. As an Analytics Engineer, you will also utilize languages such as Spark and Python as well as visualization tools such as Power BI to prepare tools and data for our Analysts. Collaborating closely with data analysts, application developers, and the other members of the Data Platform team, you will help build robust, scalable data solutions, ensuring secure and efficient data processing and analysis. Your expertise will be key in driving our data strategy, supporting the delivery of industry-leading services and products, and maintaining the highest standards of data quality, security, and integrity across our data initiatives.

Job Responsibilities

What you'll do as a Senior Analytics Engineer at Milliman SkySail

• Diligently and rapidly execute data processing and analysis tasks as directed by our Analysts, focusing on ingesting, transforming, and presenting data within the Databricks platform.
• Implement and optimize data pipelines and workflows using SQL, Python, and Spark based on Analyst requirements, ensuring best practices for scalability and efficiency.
• Create and manage data visualizations and reports using tools like Power BI, directly aligning with Analysts' specifications to support data-driven insights.
• Provide technical feedback, suggesting optimizations and enhancements to data models and analytics approaches based on technical assessments.
• Work collaboratively with data analysts, application developers, and other data platform team members to ensure seamless integration and high-quality data solutions, maintaining a service-oriented approach to support the analytics and application development team's objectives.
• Participate in peer review processes, providing and receiving constructive feedback to improve the quality and efficiency of data solutions.

Being Successful at SkySail

• At SkySail, you'll have the opportunity to both contribute in your area of expertise and collaborate cross-functionally with other experts. Our most successful contributors are excited to learn from the other experts in our company as well as teach about their area of expertise.
• We place a strong emphasis on peer review. We believe in the power of constructive critique. Our most impactful contributors welcome critical feedback and also excel in providing insightful and appropriate feedback to their peers.
• We are disrupting our industry by introducing more efficient ways to quickly analyze pharmacy claims data. We apply that same disruption internally as we will adapt new processes and tools and throw out old ones. We're quick to adopt better tools and processes, and unafraid to discard what doesn't serve us.
• At SkySail, flexibility is at our core; we favor timely reactions to market and client changes over rigid plans. This agility is embraced by our top contributors, who thrive by embracing change and quickly pivoting when opportunities evolve.
• As an Analytics Engineer at SkySail, you'll have many opportunities and be encouraged to develop your personal subject matter expertise within the pharmacy claims domain as well as provide ideas to Analysts and Subject Matter Experts on new tools and approaches to pull insights from vast data sets.

Minimum Requirements

• High school degree required. Associate or bachelor's degree is preferred.
• 5+ years of relevant work experience as an Analytics Engineer or related role.
• Familiarity with Databricks.

Competences and Behaviors that Support Success in this Role

• Experience working with datasets with 100MM+ rows.
• Experience using the databricks platform.
• Familiarity with multiple approaches to dealing with enterprise data. e.g. Kimball approach, Inmon approach, Lakehouse, etc.
• Familiarity with AWS.
• Proven ability to work independently and with teams to identify and overcome challenges and roadblocks.
• Excellent verbal and written communication skills.

Salary: The salary range is $96,000 to $194,000, depending on relevant factors, including but not limited to education, work experience, qualifications, skills, certifications, location, etc.

Location: This is a remote position with periodic travel within the US, particularly to our offices in Cleveland, Denver, and Dallas.

Benefits

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 profit sharing 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; 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 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 1,250 hours in the preceding 12-month period
• A minimum of 8 paid holidays
• Milliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disability coverage
• Flexible spending accounts allow employees to set aside pre-tax dollars to pay for dependent care, transportation, and applicable medical needs

This job posting is expected to close on July 3, 2024.

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)