Business Intelligence Developer Senior

Business Intelligence Developer Senior 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. 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: Virginia In 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. Elevance Health is a health company dedicated to improving lives and communities – and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve. We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few. Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process. The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19 and Influenza. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws. Elevance Health is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process should submit the Accessibility Accommodation Request Form and a member of the team will be in contact. Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws, including, but not limited to, the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act. Prospective employees required to be screened under Florida law should review the education and awareness resources at HB531 | Florida Agency for Health Care Administration. ANTHEM INSURANCE COMPANIES INC