Business Intelligence Developer (Hybrid-Home & Office)

Who We Are:

Managed Health Care Associates, Inc. (MHA), provides care communities with access, solutions, and insights to help them run their businesses more effectively. Our members include post-acute providers across the care continuum including long-term care, home infusion, and specialty pharmacies, as well as senior living and other group living facilities. Our team of associates are passionate about our common mission of helping people age with grace, and champion our core values of being Curious Learners, Selfless Advocates, and Relentless Finishers.

Who we're looking for:

You're engaged and self-motivated with a superior analytical approach to solving problems, constantly driving for improvement and innovation. Your strong communication and organizational skills make you an excellent team player that adds meaningful contributions to our collaborative and fast-paced work environment. As curious learners, we question the status quo and so should you.

The Cognos Business Intelligence Developer is responsible for the strategic design and implementation of BI software and systems, including integration with databases and the data warehouse. This requires understanding the key levers in our business and driving optimization and growth. As a Team Lead and an integral member of the Data & Analytics Team, you will be responsible for helping key business stakeholders make better, data-driven decisions to continue maximizing MHA's value to our members. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users.

What You'll Be Doing:

Essential Duties & Responsibilities:

• The Cognos BI developer is primarily responsible for developing new reports, enhancing existing reports and providing solutions to complex queries and questions from MHA's user community.

• Monitors, investigates, troubleshoots and resolves issues. Coordinates with vendors and partners to resolve complex issues related to Cognos reports.

• Drive pragmatic approaches to solving key, complex business problems through business intelligence tools such as Cognos and SQL Server.

• Understanding of data modeling practices and techniques in Cognos Framework modeling and Cognos Data Modules.

• Grow the technical environment by bringing new technologies and techniques to create efficient processes around data extraction, aggregation and analytics.

• Collaborate with clients to better understand needs and provide POC for software solutions using Cognos analytics or SQL Server.

• Use of new Business Intelligence software tools including Cognos Framework Manager, Transformer, Cognos Event Studio, Cognos Report Studio, Cognos Data Modules, Cognos DataSets and Cognos Dashboards.

• Design, code, test new or modified BI systems, applications, and programs using SQL Server or Cognos.

• Document specifications for business intelligence reports using Cognos analytics, dashboards, or other outputs.

• Collaborate with the business intelligence team in development and analyzing the business processes. Quickly understands business issues, strengths, weaknesses and data challenges

• Strong T-SQL database development skills

• Looking for self-motivated candidates who are hands on at their current positions and have hunger to learn new technologies

• Contribute to technical team to assist in delivering a flexible and scalable solution.

• Security and data integrity in a HIPAA compliant organization.

Minimum Qualifications & Competencies:

• BS or MS in Computer Science, Information Technology or related field

• Should have 5 to 7 years of experience with Cognos development and should have at least worked on Cognos 11.x versions.

• Should have hands experience on database development using SQL Server and can troubleshoot SQL queries efficiently.

• SQL Server, T-SQL, query optimization tools and techniques, data modelling techniques, and relational database design

• Experience architecting and building Data Warehouses, DataMarts

• Understanding of data modeling, data driven insight, data quality and governance

• Strong technical background, analytical, and problem-solving skills are required

• Ability to work collaboratively within a team environment and capable of delivering under aggressive timelines

• Must possess strong communication and interpersonal skills

• Looking for self-motivated candidates who are hands on at their current positions and have hunger to learn new technologies

• Able to work in a fast-paced, dynamic environment

• Capable of incident resolution during major incident process

• Good time management and prioritization skills; self-starters are especially welcome

• Maturity and ability to take responsibility for gathering additional information on requirements and design to effectively establish testing for the applications and processes

• Dedicated to excellence in quality, reliability, and thoroughness in all work tasks; detail-oriented with consistent follow-through

• Knowledge of emerging technologies

Why Join MHA

MHA continues to lead by providing purpose-driven and value-based solutions, which preserve the dignity and grace people deserve, regardless of age. Let us be the best place you'll ever work!

Our associates enjoy the following benefits, and you can, too!

• Staying Healthy

Comprehensive medical, dental, and vision plans with FSA/HSA options

Fitness reimbursement

Access to an Employee Assistance Program

• Enjoying Time-Off

Paid time off, holidays, floating time, paid parental leave and your birthday is a day off!

• Planning for the Future

Life Insurance, short-term & long-term disability insurance

401K match

Employee Stock Purchase Plan

• Learning Continuously

E-learning programs

Tuition Reimbursement

Ongoing Team Trainings

• Making an Impact

Paid volunteer time-off

Donation matching