Data Warehouse Analyst SrLocation: This position will work a hybrid model (remote and office). An ideal candidate must live within 50 miles of one of our Elevance Health PulsePoint locations listed here: Chicago, IL; Norfolk, VA; Indianapolis. IN; Atlanta, GA; Mason, OH.The Data Warehouse Analyst Sr 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, documents information requirements.
Facilitates the identification of potential gaps in available data and collaborates with business areas to determine 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 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, Experiences and Competencies:
Experience writing transactional SQL statements
Experience in Teradata, and SAS preferred.
Additional technical skills in MS-Access, MS Excel and ETL preferred.
VBA coding experience
Strong analytical and problem-solving ability strongly preferred.
Demonstrated ability to lead and plan projects strongly preferred.