Senior Business Intelligence and Analytics Developer

Magellan Health is a leading healthcare company seeking a Senior Business Intelligence and Analytics Developer. The role focuses on analyzing business requirements, creating technical specifications, and developing BI solutions to enhance business performance through data analysis and visualization.

Responsibilities:

• Analyze business requirements and create technical specifications for Business Intelligence (BI) systems
• Blueprint, gather requirements, design, roll out and maintain BI solutions for business owners
• Work with multiple types of healthcare customer data, designing and creating engaging, high-impact dashboards and visualizations
• Analyze 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 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 with client presentations and demonstrations
• Collaborate with other developers on the application of standards and best practices
• Contribute to the evolution of best practices and standards aimed at improving scalability, performance and maintainability; mentor 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
• 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

Requirements:

• 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