This role is responsible for analyzing business requirements and creating the technical specifications for Business Intelligence (BI) systems to integrate with databases, data warehouses/marts and Intelligence Data Management (IDM). The primary focus of the role is blueprinting, gathering requirements, designing, rolling out and maintaining BI solutions for business owners. In this role, incumbents will work with multiple types of healthcare customer data, designing and creating engaging, high-impact dashboards and visualizations and analyzing data, processes, and systems to identify opportunities for process and performance improvement.

• Work closely with Business Intelligence (BI) architects to gather and document required BI system requirements.

• Translate business requirements into specifications that will be used to develop data objects and/or framework ensuring business smart resource allocation.

• Extract, transform and load data into BI applications (requires data modeling across multiple data sources).

• Develop, test and debug BI applications and ad-hoc reports. Develop front end reporting applications using Tableau and Cognos.

• Utilize scripting language to meet complex business requirements.

• Provide support as required to ensure the data availability and performance of enterprise data and BI environments for both external and internal users. Resolve data and reporting issues from business partners.

• Assist architects, as needed, with client presentations and demonstrations.

• Collaborate with other developers on the application of standards and best practices and contribute to the evolution of best practices and standards aimed at improving scalability, performance and maintainability; as well as, mentoring junior staff on the use and value of those standards.

• Be involved in all aspects of the development life cycle including, requirements gathering, architecture, development, testing, training, implementation, and support of reporting applications to be used internally by our employees.

• Use creativity and curiosity to partner with associates in other business areas to define business needs and help translate those needs into reporting system requirements.

• Interface with other teams and departments to develop new and modify existing reporting applications.

• Provide data and programming expertise to meet internal ad hoc data requirements.

• Provide technical assistance and cross training to other team members as needed.

  Other Job Requirements

Responsibilities

Bachelor’s degree and 7+ years of experience in Business Intelligence (BI) analysis and development OR an equivalent combination of education and experience.

Experience setting business requirements for BI tools and translating business requirements into technical requirements.

Experience working in Data Warehouse environments reporting on dimensions/hierarchies with experience in Star-Schema/Snowflake modeling, Fact and Dimensions tables; Solid experience developing complex data models.

Requires strong analytical, conceptual, and problem-solving abilities.

Excellent planning and organizational skills with good communication and interpersonal skills required.

Ability to perform and contribute to a strong team environment and to manage multiple priorities.

General Job Information

Title

Lead Business Intelligence and Analytics Developer

Grade

29

Work Experience - Required

Analytics/Informatics, Business Intelligence

Work Experience - Preferred

Education - Required

A Combination of Education and Work Experience May Be Considered., Bachelor's

Education - Preferred

License and Certifications - Required

License and Certifications - Preferred

Salary Range

Salary Minimum:

$93,955

Salary Maximum:

$159,725

This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors permitted by law.

This position may be eligible for short-term incentives as well as a comprehensive benefits package. Magellan offers a broad range of health, life, voluntary and other benefits and perks that enhance your physical, mental, emotional and financial wellbeing.

Magellan Health, Inc. is proud to be an Equal Opportunity Employer and a Tobacco-free workplace. EOE/M/F/Vet/Disabled.Every employee must understand, comply with and attest to the security responsibilities and security controls unique to their position; and comply with all applicable legal, regulatory, and contractual requirements and internal policies and procedures.

Magellan is the employer of choice for hard working people interested in making a difference in the health care industry and in the communities where we work and live. Our strong culture of caring is the common thread in both our business strategy and our work environment. We value professional growth and development, total health and wellness, rewards and recognition as well as employee unity. Magellan is a place where you can thrive.

Magellan is committed to providing equal employment opportunities to employees and applicants for employment without regard to race, color, creed, religion, sex, gender identity and expression, sexual orientation, marital status, age, national origin, ancestry, citizenship, physical or mental disability, disabled veteran or veteran of the Vietnam Era status, or any other factors protected by law.

Magellan is committed to meeting applicable Federal labor and employment law posting requirements by providing necessary posters in a format which is easily accessible and conspicuous to all applicants. Copies of applicable posters are accessible by clicking here (https://www.magellanhealth.com/media/760295/mg-federal-contractors-applicant-english.pdf) .

Warning: Employment Scam

It has come to our attention that a false representative is contacting potential candidates and offering them work at home positions with Magellan Health. “Interviews” are conducted completely through email and the false job offer includes the promise of a check to be issued to the candidate for the purposes of setting up a home office.

Please know that Magellan Health does not interview any candidate through email, nor do we issue checks to candidates to set up home offices. All of our available positions are posted on legitimate job boards and our recruitment team directly contacts candidates should there be a fit.

If you suspect you are being contacted by a false representative of Magellan Health, please call 410-953-2911