Data Warehouse Analyst Senior

Anticipated End Date: 2024-06-28 Position Title: Data Warehouse Analyst Senior Job Description: Data Warehouse Analyst Senior Location: Norfolk, VA (preferred). This position will work in a hybrid model (remote and office). The Ideal candidate will live within 50 miles of one of our Elevance Health PulsePoint locations. The Data Warehouse Analyst Senior is responsible for partnering with internal and external business clients and IT to fulfill information needs and support business decisions. How You Will Make an Impact: Guides and advises less experienced data warehouse analysts. Maintains information policies and procedures to support current and future data information needs and ensures proper data definitions, ownership, use, and integrity of data. Analyzes complex business user needs and documents information requirements. Facilitates the identification of potential gaps in available data and collaborates with business areas to determine the best means for acquiring the data needed. Collaborates with IT resources on the creation and maintenance of the content of the data warehouse. Establishes and maintains strong knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues. Completes metadata assessment and reviews feedback to determine changes. Ensures that data definitions are clear and current and communicates changes to data definitions to all users. Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule. Minimum Requirements: Requires Bachelor's degree in a related field and a minimum of 2 years experience in data analysis, data modeling, and working with automated data warehouse systems; or any combination of education and experience which would provide an equivalent background. Preferred Skills, Capabilities, & Experiences: Experience in SQL, GQL, SAS, Business Objects preferred. Strong PC skills, analytical, problem-solving ability, and communication skills are preferred. Demonstrated ability to lead and plan projects strongly preferred. Experience with relational databases and knowledge of query tools and statistical software is strongly preferred including SQL & Excel. The ability to manipulate large sets of data is strongly preferred; data mining experience is preferred. Strong analytical, organizational, presentation, and problem-solving skills strongly preferred. Experience with healthcare data & analytics. Experience with SQL Server relational database, developing complex queries, & querying data warehouse strongly preferred. Agile / Scaled Agile Framework (SAFe) experience. Job Level: Non-Management Exempt Workshift: 1st Shift (United States of America) Job Family: RDA > Data Warehouse/Data Mgmt 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. Elevance Health is a health company dedicated to improving lives and communities – and making healthcare simpler. Previously known as Anthem, Inc., we have evolved into a company focused on whole health and updated our name to better reflect the direction the company is heading.