Business Data Analyst - IntelliScript (Remote)

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 Information Technology has been a key part of our success and is critical to our future. The Business Data Analyst acts as a crucial bridge between business objectives and technology solutions, transforming complex data into actionable insights and designing systems that drive operational efficiency. This role is responsible for understanding, analyzing, and improving business processes while leveraging data and technology to support organizational goals. 

What you will be doing

• Requirements Gathering & Analysis: collaborate with stakeholders to identify business needs, translate them into functional and technical requirements, and document them clearly for technical teams.
• Process & Data Analysis: examine existing business processes and data flows to identify areas for optimization, efficiency, and improved data integrity.
• Database Oversight & Querying: review and query SQL databases to proactively monitor for issues, troubleshoot identified issues, and perform root cause analysis.
• Ad Hoc Research & Cross-System Analysis: investigate API performance, host/server health, and other operational metrics by integrating data from multiple sources such as databases, CloudWatch, and S3 buckets.
• Scenario-Based Investigation: execute queries and analyses for specific business scenarios, such as assessing transaction volume impact on load distribution or identifying patient matching issues.
• Process & Data Flow Documentation: create and update process diagrams and data flow maps to visualize current and future-state workflows (e.g. patient matching, log message analysis, etc.).
• Solutions Evaluation & Technical Proposals: assess and propose system enhancements, including SQL table designs, logging improvements, and workflow changes to meet business objectives.
• Testing & Validation: support user acceptance testing, validate system changes, and ensure solutions meet business and technical requirements.
• Stakeholder Communication: serve has a liaison between business units, IT, and vendors, ensuring clear understanding and successful delivery of projects and enhancements.
• Change Management & Training: assist with user documentation, training, and adoption of new systems or processes.
• Continuous Improvement: monitor system performance and user feedback to recommend improvements and support business growth.

What we need

• 5+ years of relevant experience
• Proficiency in SQL and experience with B2B database environments
• Strong proficiency in Excel to