Business Intelligence Programmer Analyst

Medical Mutual; Brooklyn (OH); Hybrid; USD 60,000 - 90,000; Full time

Benefits offered by this job

Parental leave

Tuition reimbursement

401(k) with company match

Health, dental, vision insurance

Job summary

Medical Mutual is seeking a BI/Data Analytics professional to design and implement analytics solutions supporting healthcare quality, outcomes, and cost efficiency. You will work with Business Analysts to translate requirements into scalable BI capabilities using SQL, Python, and Databricks.

The role emphasizes collaboration, documentation, and guidance on data modeling, enterprise data structures, and BI data marts, within a hybrid Brooklyn, OH setting.

Qualifications

• Bachelor's degree in MIS/IT/Computer Science or related field.
• 1–3 years of relevant work experience.
• Experience in data analysis and report design/development.
• Base SAS Certification preferred.
• Familiarity with SAS, SQL Server, Office, and other Microsoft technologies.
• Understanding of relational databases and query tools.
• Healthcare industry familiarity preferred.
• Advanced SAS Certification preferred.

Responsibilities

• Transform business requirements into BI solutions delivering reporting and analytics capabilities.
• Evaluate requirements for BI reporting and analytics deployment.
• Lead analytics development by writing and productionizing SQL, Python, and other code (Databricks).
• Provide technical guidance on approaches to meet client requirements.
• Collaborate with stakeholders and analysts to understand data needs and remedy discrepancies.
• Contribute to test plan reviews and UAT support.
• Create and maintain design/technical documentation for deliverables.

Skills

SQL

Python

Databricks

SAS

SQL Server

Education

Bachelor's degree in MIS/IT/CS

Bachelor's degree in IT/CS or related field

Tools

Databricks

Job description

parental leave, tuition reimbursement, 401(k)

Medical Mutual employees must submit their applications through MySource.

Note: This is a hybrid position located in Brooklyn, OH, with a three-day per week onsite requirement.

Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance companies based in Ohio. We provide peace of mind to more than 1.2 million members through our high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement, and individual plans.

Job Summary:

Works collaboratively with Business Analysts to design and implement innovative technical solutions that address customer information and analytics needs. Ensures the successful deployment of analytic capabilities and information assets. Primary responsibilities include designing, developing, maintaining, and enhancing analytics solutions and processes that help customers improve healthcare quality, outcomes, and cost efficiency.

Responsibilities:

• Transforms business requirements into Business Intelligence solutions using available development tools to deliver reporting and analytics capabilities that support customer information, data, and analytical needs.
• Evaluates functional and technical business requirements for designing, coding, testing, and deploying a business intelligence reporting and analytics capability.
• Serves as the technical development lead for assigned analytics projects by writing, optimizing, and productionizing SQL, Python and other code. Develop new programs and modify existing ones using the Databricks platform.
• Provides technical guidance to project team members and clients regarding the advantages and disadvantages of various technical approaches to ensure the successful achievement of client requirements.
• Collaborates with all business stakeholders and primarily business analysts in gaining understanding of requirements/data needs, remediating data discrepancies.
• Contributes to the review of test plans and test cases to ensure all requirements are adequately covered, and documentation is complete and thorough. Provides support for critical user acceptance testing scenarios.
• Creates and maintains design and technical documentation for solution deliverables and analytical capabilities.
• Develops and maintains strong working relationships with key stakeholders.
• Supports agile delivery practices.
• Performs other duties as assigned.

Job Summary:

Transform business requirements into Business Intelligence (BI) technical solutions that efficiently deliver analytics capabilities in support of the organization's business and strategic objectives. Provides subject matter expertise and technical leadership in the design and implementation of BI solutions to support analytical deliverables and capabilities. Collaborates closely with Business Analysts to ensure requirements are fully understood, thoroughly documented, and appropriately addressed within the technical solution.

Responsibilities:

• Transforms business requirements using available MMO development tools into Business Intelligence (BI) solutions that deliver reporting and analytics capabilities in support of the organization's business and strategic initiatives.
• Evaluates functional and technical business requirements to design, develop, test, and deploy business intelligence reporting and analytics solutions.
• Provides subject matter expertise in data modeling, application development practices, enterprise data structures, data transformation techniques, and BI data mart architecture.
• Collaborate with business stakeholders, primarily Business Analysts, to understand business requirements and data needs, resolve data discrepancies, and create design documentation for solution deliverables.
• Applies innovative approaches to develop robust analytics products and solutions that enhance the end-user experience and improve usability and accessibility.
• Contributes to the review of test plans and test cases to ensure all requirements are adequately covered, and documentation is complete and thorough. Provides support for critical user acceptance testing scenarios.
• Develops and maintains moderately complex data and analytics solutions using SQL, Python, Databricks, and related data management and cloud technologies.
• Develops and maintains strong working relationships with key stakeholders.
• Supports Agile delivery methodologies and practices.
• Performs other duties as assigned.

Qualifications:

• Bachelor's degree in MIS/IT/Computer Science or related field.
• 1 to 3 years of relevant work experience.
• Experience in data analysis and report design/development.
• Base SAS Certification preferred.
• Solid understanding and familiarity with SAS, SQL Server, Office, and other components of Microsoft technology.
• Familiarity with system analysis, design, development, quality assurance and integration methodologies.
• Knowledge and experience with relational databases/concepts and query tools.
• Knowledge and experience with relational databases/concepts and query tools.
• Bachelor's degree in IT/Computer Science or related field
• 3 to 5 years relevant work experience
• Experience in data analysis and report design/development
• Healthcare background preferred
• Advanced SAS Certification preferred
• Strong understanding and familiarity with SAS, SQL Server, Office and other components of Microsoft technology
• Familiarity with system analysis, design, development, quality assurance and integration methodologies
• In depth knowledge and experience with relational databases/concepts and query tools
• Detailed problem solving and troubleshooting skills

Medical Mutual is looking to grow our team! We truly value and respect the talents and abilities of all of our employees. That's why we offer an exceptional package that includes:

A Great Place to Work:

• We will provide the equipment you need for this role, including a laptop, monitors, keyboard, mouse and headset.
• Employees have access to on-site fitness centers at many locations, or a gym membership reimbursement when there is no Medical Mutual facility available. Enjoy the use of weights, cardio machines, locker rooms, classes and more.
• On-site cafeteria, serving hot breakfast and lunch, at the Brooklyn, OH headquarters.
• Discounts at many places in and around town, just for being a Medical Mutual team member.
• The opportunity to earn cash rewards for shopping with our customers.

Excellent Benefits and Compensation:

• Employee bonus program.
• 401(k) with company match up to 4% and an additional company contribution.
• Health Savings Account with a company matching contribution.
• Excellent medical, dental, vision, life and disability insurance - insurance is what we do best, and we make affordable coverage for our team a priority.
• Access to an Employee Assistance Program, which includes professional counseling, personal and professional coaching, self-help resources and assistance with work/life benefits.
• Company holidays and up to 16 PTO days during the first year of employment with options to carry over unused PTO time.
• After 120 days of service, parental leave for eligible employees who become parents through maternity, paternity or adoption.

An Investment in You:

• Career development programs and classes.
• Mentoring and coaching to help you advance in your career.
• Tuition reimbursement up to $5,250 per year, the IRS maximum.
• Diverse, inclusive and welcoming culture with Business Resource Groups.

About Medical Mutual:

Medical Mutual's status as a mutual company means we are owned by our policyholders, not stockholders, so we don't answer to Wall Street analysts or pay dividends to investors. Instead, we focus on developing products and services that allow us to better serve our customers and the communities around us.

There's a good chance you already know many of our Medical Mutual customers. As the official insurer of everything you love, we are trusted by businesses and nonprofit organizations throughout Ohio to provide high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement and individual plans. Our plans provide peace of mind to more than 1.2 million Ohioans.

We're not just one of the largest health insurance companies based in Ohio, we're also the longest running. Founded in 1934, we're proud of our rich history with the communities where we live and work.

We maintain a drug‑free workplace and perform pre‑employment substance abuse and nicotine testing.

#LI‑SC1 #LI‑HYBRID

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.