Business Intelligence Developer Senior

Elevance Health•Tampa, FL

1d•$101,600 - $152,400•Hybrid

About The Position

The Business Intelligence Developer Senior is responsible for participating in all phases of the design and development life cycle of analytic applications and reporting tools, utilizing various BI technology platforms.

Requirements

Requires an BA/BS degree in Information Technology, Computer Science or related field of study and a minimum of 3 years’ experience on one platform, or any combination of education and experience, which would provide an equivalent background.

Nice To Haves

Advanced SQL skills including the ability to write, optimize, and troubleshoot complex queries, joins, CTEs, window functions, stored procedures, and large-volume data transformations across complex relational datasets highly preferred.
Experience designing, developing, and supporting data feeds for pharmaceutical manufacturers, specialty pharmacy, infusion pharmacy, hub services, or other healthcare data exchange environments highly preferred.
Experience working with patient- and prescription-level specialty pharmacy data, including demographics, prescription status, dispense activity, shipment, prior authorization, benefits investigation, adherence, and therapy lifecycle events highly preferred.
Experience interpreting manufacturer data specifications and translating source-to-target mapping requirements into scalable ETL/ELT solutions, standardized outbound feeds, validation rules, and transformation logic highly preferred.
Experience with data quality, operational controls, and healthcare data privacy, including reconciliation, exception/reject handling, duplicate management, historical corrections, reprocessing, HIPAA/PHI/PII requirements, and platforms such as Snowflake, SQL Server, or SSIS highly preferred.

Responsibilities

Maintains active relationships with customers to determine business requirements.
Anticipates opportunities for improvement and identifies alternate solutions.
Collaborates with engineers for creative ideas for Web portals supporting interactive content, analyzes and classifies complex change request and reviews and evaluates possible enhancements.
Works with development team to develop and define application scope and objectives and prepare functional and/or technical specifications.
Analyzes and evaluates detailed business and technical requirements.
Codes and maintains complex components of information systems.
Mentors others on coding standards and performs code reviews.
Develops and performs system testing and fixes defects identified during testing and re-executes unit tests to validate results.
Aids in integrating activities with other IT departments for successful implementation and support of project efforts.
Provides timely support to data information planning effort.
Maintains technical development environment and has responsibility for implementation plan.
Assists in developing training documentation including proactive identification of additional needs and enhancements.
Manages small projects, mentors and provides training to others.
Acts as subject matter expert of one or more Business Intelligence applications.
Establishes connectivity to operations source systems and data repositories.
Conducts data discovery work to understand strengths, limitations, and opportunities within the currently available data.
Develops strategic report applications from the data warehouse, using structured query language (SQL) to extract relevant sets of data.
Establishes and maintains excellent knowledge of data warehouse database design, data definitions, and data integrity issues.
Works as part of a cross-functional team of database developers, data analysts, project managers, program managers, IT engineers, and external partners to create solutions to meet contracted data requirements.
Helps with performance-tuning of existing SQL queries to ensure completion of business-essential processes in accordance with established partner service-level-agreements.