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.
Business Intelligence Programmer Analyst II
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.
Senior Business Intelligence Programmer Analyst
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:
Business Intelligence Programmer Analyst II
- 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.
Senior Business Intelligence Programmer Analyst
- 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.
- Business casual attire, including jeans.
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.