Developer Sr

Elevance Health•Baltimore, MD

3d•Hybrid

About The Position

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. 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 accommodation is granted as required by law. Wellpoint Federal, a subsidiary of Elevance Health, brings deep industry expertise and healthcare service capabilities to support federal programs. The organization delivers solutions across claims administration, data, and care delivery to help address complex challenges and improve health outcomes for federal populations. Responsible for participating in all phases of the development and maintenance life cycle, typically for an assigned business unit, client program, or corporate department and utilizing various customer technology platforms. This role will also support the automation, orchestration, processing, and full data lifecycle of data transformation, management, security, performance tuning, and monitoring. Responsibilities include the administration and support of data platform tools and the design, development, implementation, and ongoing monitoring of data processes to support organizational data needs. Collaborates with data architects, product owners, data governance, technical teams, and other developers/admins to align with organizational standards and requirements surrounding platform administration, security, patching, and data processing. Responsible for requirements gathering, process mapping, data processing requirements, and managing and assessing data platform performance, while supporting data security, compliance, collaboration, communication, and continuous improvement.

Requirements

Requires a BA/BS degree in Information Technology, Computer Science, or related field of study and a minimum of 3 years of experience on one platform, or any combination of education and experience, which would provide an equivalent background.
This position is part of our Wellpoint Federal division which, per CMS TDL 190275, requires foreign national applicants meet the residency requirement of living in the United States at least three of the past five years.

Nice To Haves

Experience as a Report administrator, Developer, ETL tool administrator, or similar role in a data-centric environment.
5+ years of experience in administering, testing, and implementing enterprise data process automation and orchestration.
Experience with Data processing platforms and technologies such as Microsoft SSIS, Informatica, ActiveBatch, Power Apps, Apache Airflow, Apache Nifi, Job Schedulers, File transfer tools, etc.
Knowledge of or experience with data virtualization technology (Denodo currently at WF).
Responsible for providing full lifecycle administration of data platform tools (patches/updates, AD security, account management, capacity management, documenting processes).
Primary platform support would revolve around PowerBI and supporting user security, but also serve as a backup for other department software platforms (Denodo, Informatica, ActiveBatch, etc.).
Data management & modelling: Connect and manage data pipeline tools to various data sources, including on-premise and cloud-based data sources.
Implement and maintain semantic models to ensure data integrity and performance optimization.
Perform data cleansing and transformation tasks (ETL) to prepare data for analysis.
Technical support: Provide technical guidance and support to consumers of data services, ensuring effective adoption and utilization of enterprise data and the fabric/virtual layer.
Performance monitoring: Monitor and optimize Data Pipeline (ETL) performance, including capacity planning and server performance.
User management: Manage user access and permissions to enterprise data platforms and resources, ensuring compliance with security policies.
Troubleshooting: Conduct thorough testing, debugging, and troubleshooting of Data Pipleline (ETL) tools and solutions.
Governance: Maintain governance policies, best practices, and security standards for the enterprise data platforms.
Training and knowledge sharing: Provide training and share knowledge with colleagues to enable the delivery of data for enterprise needs.
Roadmap building and prioritization: Support the data architecture team with data pipeline (ETL) roadmap, prioritizing initiatives based on business needs and strategic goals
Skilled in analyzing and automating manual processes to reduce manual interaction
Experience with data virtualization/fabric platforms such as Denodo, CData, Talend, Data Virtuality
Experience with and utilizing development skills such as SQL, PL/SQL, T-SQL, Shell Scripting (Powershell, Unix Shell, etc.)
Able to analyze, troubleshoot and tune SQL queries and recommend enhancements.
Analyzing and monitoring server resources and implement proactive alerts and notifications based on SLAs.
Performance tuning and analysis of SQL code and logic in data transformations and queries.
Relevant certifications related to data platforms and relevant technologies.
Experience in the healthcare claims processing industry and understanding of associated data security and privacy concerns.

Responsibilities

Maintains active relationships with customers and stakeholders to determine business requirements.
Collaborates with engineers, graphic designers, data architects, database administrators, and development teams; analyzes and classifies complex change requests and reviews and evaluates possible enhancements.
Works with development teams to develop and define application and data processing scope and objectives and prepare functional and/or technical specifications.
Analyzes and evaluates detailed business, data, and technical requirements.
Codes and maintains complex components of information systems, including SQL queries, views, stored procedures, data transformations, and data processing solutions.
Supports data integration, ETL, automation, and orchestration processes across database and technology platforms.
Mentors others on coding standards and performs code reviews.
Develops and performs system testing, troubleshooting, and performance tuning and fixes defects identified during testing and re-executes unit tests to validate results.
Assists with monitoring and optimizing data processing, queries, system performance, and data delivery processes.
Aids in integrating activities with other IT and data departments for successful implementation and support of project efforts.
Provides technical support and troubleshooting for applications, databases, data platforms, and related tools.
Supports data quality, security, governance, and compliance requirements and assists with user access, platform maintenance, and monitoring activities.
Provides on-call support, monitors systems and data processes, identifies system deficiencies, and recommends enhancements and improvements.
Documents processes, programs, and solutions in accordance with established standards.