Business Intelligence Developer Senior

Business Intelligence Developer SeniorBusiness Intelligence Developer SeniorLocation: This role requires associates to be in-office 1-2 days per week, fostering collaboration and connectivity, while providing flexibility to support productivity and work-life balance. This approach combines structured office engagement with the autonomy of virtual work, promoting a dynamic and adaptable workplace. Ideal candidates will be able to report to one of our Pulse Point locations in Richmond, VA, Grand Prairie, TX, Lake Mary, FL, Tampa, FL, St. Louis, MO, or Atlanta, GA. Alternate locations may be considered if candidates reside within a commuting distance from an office.Please note that per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from the posting location(s) will not be considered for employment, unless an accommodation is granted as required by law.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.How You Will Make An Impact: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.Minimum Requirements:Requires a 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.Preferred Skills, Capabilities and Experiences: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.For candidates working in person or virtually in the below location(s), the salary* range for this specific position is $101,600 to $152,400.Locations: VirginiaIn addition to your salary, Elevance Health offers benefits such as a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). The salary offered for this specific position is based on a number of legitimate, non-discriminatory factors set by the Company. The Company is fully committed to ensuring equal pay opportunities for equal work regardless of gender, race, or any other category protected by federal, state, and local pay equity laws.