Data Engineer Senior

Anticipated End Date:
2024-02-09
Position Title:
Data Engineer Senior
Job Description:
Data Engineer Senior
Location: Norfolk, VA preferred. This position will work a hybrid model (remote and office). The Ideal candidate will live within 50 miles of one of our Elevance Health PulsePoint locations.
TheData Engineer Senior is responsible for delivery of end-to-end application, system development and maintenance on complex multi technology platforms within assigned client group, business unit or corporate department and utilizing various customer technology platforms.
How you will make an impact:

• Maintains active relationships with customers to determine business requirements and leads requirements gathering meetings; collaborate closely with business analysts, data scientists, and other stakeholders to deliver effective and efficient data warehousing solutions.
• Owns the change request process and may coordinate with other teams as necessary.
• Provides technical advice and weighs in on technical decisions that impact cross functional teams.
• Researches and may propose new technologies; stay up-to-date on the latest trends and advancements in the data warehousing and business intelligence domain, sharing knowledge and insights with the team.
• Utilize Informatica to architect and implement scalable and reliable data integration solutions, adhering to industry best practices.
• Develops and defines application scope and objectives and prepares technical and/or functional specifications from with programs will be written.
• Leverage experience with SSIS to create and maintain data integration workflows, extracting, transforming, and loading (ETL) data from diverse sources into the data warehouse.
• May own technical testing to ensures unit test is completed and meets the test plan requirements, system testing is completed, and system is implemented according to plan.
• Assesses status and supports data information planning; coordinates on-call support and ensures effective monitoring of system.
• Optimizing query performance, ensuring data integrity, and implementing efficient database structures using MSSQL.
• Maintains technical development environment; Design, develop, and deploy robust and efficient data warehousing solutions, utilizing advanced proficiency in MSSQL, SSIS, and Informatica.
• Mentors others and may lead multiple or small to medium sized projects.
• Will begin to set direction at the project/service level and influences decision-making; explore innovative approaches and technologies to enhance data warehousing practices, ensuring scalability, reliability, and improved performance.
• Provides technical guidance, and mentoring.
• Understands the tradeoffs between technical, analytical and product needs of the technical solutions. Identifies and propose strategies around technical problems affecting team, communicates standards and gets buy-in on solutions.
• Facilitates group sessions to elicit complex information on requirements clarification, design sessions, code reviews and troubleshooting issues.
• Supports vendor evaluation.

Minimum Requirements:

• Requires an BA/BS degree in Information Technology, Computer Science or related field of study
• Minimum of 5 years related experience; multi-dimensional platform experience; expert level experience with business and technical applications.
• Or any combination of education and experience, which would provide an equivalent background.

Preferred Skills, Capabilities, and Experiences:

• Experience mentoring others, leading multiple small projects and providing troubleshooting support is preferred.
• Multi database and/or multi language strongly preferred.
• Hands-on experience with MSSQL, SSIS, and Informatica.
• Experience optimizing query performance, ensuring data integrity, and implementing efficient database structures using MSSQL.
• Experience writing complex SQL queries involving intricate logic to extract, manipulate, and analyze data efficiently.
• Extensive experience with SSIS with proven ability to design and maintain data integration workflows, ETL processes, and data transformations.
• In-depth knowledge of the Software Development Life Cycle (SDLC) and experience working on end-to-end development projects.
• Excellent problem-solving skills and the ability to analyze complex data requirements to design optimal solutions.
• Excellent communication skills, both verbal and written, enabling effective collaboration with technical and non-technical stakeholders.

Job Level:
Non-Management Exempt
Workshift:
1st Shift (United States of America)
Job Family:
IFT > Engineering/Dev
Please be advised that Elevance Health only accepts resumes for compensation from agencies that have a signed agreement with Elevance Health. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health.
Who We Are
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.
How We Work
At Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business.
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. Candidates must reside within 50 miles or 1-hour commute each way of a relevant Elevance Health location.
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. 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 may contact elevancehealthjobssupport@elevancehealth.com for assistance.