Business Intelligence Developer Senior

Elevance Health•Richmond, VA

6d•Hybrid

About The Position

The Business Intelligence Developer Senior participates in all phases of the design and development life cycle for analytic applications and reporting tools across BI technology platforms. The role works with customers and cross-functional teams to understand business and technical requirements, develop reporting and data solutions, and support successful implementation and operation. It establishes connections to operational source systems and data repositories, explores available data, and develops strategic reports from the data warehouse using SQL. The position also maintains knowledge of data warehouse design, definitions, and integrity, and helps tune queries to meet partner service-level agreements. This hybrid position requires associates to work in an office 1–2 days per week. Ideal candidates can report to a Pulse Point location in Richmond, Virginia; Grand Prairie, Texas; Lake Mary or Tampa, Florida; St. Louis, Missouri; or Atlanta, Georgia. Alternate locations may be considered for candidates within commuting distance of an office; candidates outside a reasonable commuting distance will not be considered unless an accommodation is granted as required by law. The role is classified as Non-Management Exempt and works the first shift.

Requirements

BA/BS degree in Information Technology, Computer Science, or a related field, and at least 3 years of experience on one platform; an equivalent combination of education and experience is also acceptable.

Nice To Haves

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

Responsibilities

Maintain active relationships with customers to determine business requirements.
Anticipate opportunities for improvement and identify alternate solutions.
Collaborate with engineers on Web portal ideas for interactive content; analyze and classify complex change requests and evaluate possible enhancements.
Work with the development team to define application scope and objectives and prepare functional and/or technical specifications.
Analyze and evaluate detailed business and technical requirements.
Code and maintain complex information-system components.
Mentor others on coding standards and perform code reviews.
Develop and perform system testing, fix defects, and re-execute unit tests to validate results.
Coordinate with other IT departments to support successful project implementation and delivery.
Provide timely support to data information planning efforts.
Maintain the technical development environment and take responsibility for the implementation plan.
Assist with training documentation, proactively identifying additional needs and enhancements.
Manage small projects, mentor others, and provide training.
Act as a subject matter expert for one or more Business Intelligence applications.
Establish connectivity to operational source systems and data repositories.
Conduct data discovery to understand the strengths, limitations, and opportunities of available data.
Develop strategic report applications from the data warehouse using SQL to extract relevant data.
Maintain knowledge of data warehouse database design, data definitions, and data integrity issues.
Collaborate with database developers, data analysts, project and program managers, IT engineers, and external partners to meet contracted data requirements.
Help performance-tune existing SQL queries so business-essential processes meet established partner service-level agreements.