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.