Senior Business Intelligence and Analytics Developer

Magellan Health Services, Inc.

Scottsdale, AZ

JOB DETAILS
JOB TYPE
Full-time
LOCATION
Scottsdale, AZ
POSTED
21 days ago
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.
The job duties listed above are representative and not intended to be all-inclusive of what may be expected of an employee assigned to this job. A leader may assign additional or other duties which would align with the intent of this job, without revision to the job description.

Other Job Requirements

Responsibilities
Required Bachelor's degree and 5 to 7 years of experience in Business Intelligence (BI) analysis and development.
Experience developing BI solutions in the QlikView/Sense or similar technologies.
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 Qlik data models.
Strong knowledge using set analysis and set expressions and creating data load scripts in data load editor to develop in Qlik Sense, HTML, JavaScript, CSS, VB, and JSON.
Experience in developing extensions in Qlik Sense, including JavaScript and D3, tune data loads and QlikView/Sense application for efficient performance.
Work experience on mashups and deploying Qlik applications on custom portals.
Experience with utilizing Qlik's in-memory data discovery architecture and advocate and communicate adherence to Qlik's best-practices and standards.
Experience with utilizing QlikView Publisher capabilities
Extensive use of SQL RDBMS (Oracle, SQL Server, etc.), Data warehouse and Hadoop/Big data systems and performance tuning experience required.
Extensive use of ETL tools like SSIS/Informatica/Snaplogic etc.
Requires strong analytical, conceptual and problem-solving abilities.
Excellent planning and organizational skills with good communication and interpersonal skills are desired.
Ability to perform and contribute in a strong team environment and to manage multiple priorities.

General Job Information

Title
Senior Business Intelligence and Analytics Developer

Grade
28

Work Experience - Required
Analytics/Informatics, Business Intelligence

Work Experience - Preferred

Education - Required
Bachelor's - Computer and Information Science, Bachelor's - Information Technology

Education - Preferred

License and Certifications - Required

License and Certifications - Preferred

Salary Range

Salary Minimum:
$83,890
Salary Maximum:
$142,610

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.

About the Company

M

Magellan Health Services, Inc.

Magellan Health Services is a leading specialty health care management organization with expertise in managing behavioral health, radiology and specialty pharmaceuticals, as well as public sector pharmacy benefits programs. We deliver innovative solutions to make a positive impact on the cost and quality of health care, keeping the best interests of the people we serve at the center of our decision-making. The breadth of our offerings, depth of expertise, clinical excellence and smart, talented employees is what makes us unique.

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 where we value professional growth and development, total health and wellness, rewards and recognition and employee unity. Magellan is a place where you can thrive.

Magellan is proud to be a founding member of Hero Health Hire, a coalition of health care companies committed to recruiting, hiring and training veterans, wounded warriors and military spouses. We are also proud to be an Equal Opportunity Employer.

COMPANY SIZE
5,000 to 9,999 employees
INDUSTRY
Healthcare Services
FOUNDED
1969