The Sr Data Warehouse Analyst will be a technical leader on the data & analytics technology team. This position will be responsible for end-to-end data solutions, including business analysis, data analysis, SQL design and development, ETL requirements and design, unit testing, assisting users with UAT, and technical documentation. Must have the ability to understand business processes and their relationship with the data model and identify required ETL based on business process changes.
Lead the implementation of data strategies by analyzing and translating business needs into long-term solution data models that reduce data redundancy, streamline data movements, and improve enterprise information management.
Understands and analyzes business processes, and how they affect and integrate with the data model and ETL
Gathers, analyzes and develops, and refines requirements and technical specifications by acting as a liaison between technical and business departments in developing data marts, data models, and ETL assets.
Prior to coding the extract or ETL, analyzes data to determine data discrepancies, anomalies and outliers
Write SQL queries that clean, join, and extract data from our data warehouse to put together various types of analysis
Documents data elements, relationships, data flow, dependencies and their related interfaces
Performs Unit testing and resolves defects
Mentors peers and junior members of the Information Management team
Ability to Create lifecycle documents, including Business Workflow Diagrams, Business Use Cases, User Stories, User Interface Design Documents in the documentation of functional requirements, workflows and solutions.
Bachelors degree in Computer Science, MIS, Data Engineering or another relevant field or equivalent combination of experience and education
5 years experience in Data Warehousing
5 years experience SQL programming skills
5 years experience evaluating business requirements and translating them into a functional design
3 years experience with Clarity and Caboodle datasets
3 years experience with ETL programming and BI Reporting
3 years experience reporting & analyzing performance & data visualization
Proficient with Office products (Excel, PowerPoint, Word, Visio)
Excellent verbal and written communication skills
Ability to manage multiple efforts concurrently
Strong problem-solving skills
Strong knowledge of related emerging technologies and tools
Strong organizational and time management skills
Effective collaboration of tasks across the business and technical teams
Able to work quickly and under tight delivery deadlines with focus on details
Interface with key customers from all functional areas
Proven and recent experience of implementing solutions from requirements gathering and process design to functional production deployment
Demonstrated ability to produce high quality deliverables
Possesses strong business acumen, with ability to assist in development of business requirements definitions
Ability to establish and maintain positive and effective work relationships with management, coworkers, and business users
Masters degree in Computer Science, MIS, Data Engineering or another relevant field
Experience with OMOP common data models and standardization
Experience with Unified Medical Language System (UMLS)
Together with the University of Minnesota and University of Minnesota Physicians we have created M Health Fairview. M Health Fairview is the newly expanded collaboration among the University of Minnesota, University of Minnesota Physicians, and Fairview Health Services. The healthcare system combines the best of academic and community medicine — expanding access to world-class, breakthrough care through our 10 hospitals and 60 clinics.Fairview Health Services (fairview.org) is an award-winning, nonprofit health system providing exceptional care across the full spectrum of health care services. Fairview is one of the most comprehensive and geographically accessible systems in the state, with 10 hospitals—including an academic medical center and long-term care hospital—serving the greater Twin Cities metro area.Its broad continuum also includes 60 primary care clinics, specialty clinics, senior living communities, retail and specialty pharmacies, pharmacy benefit management services, rehabilitation centers, counseling and home health care services, medical transportation, an integrated provider network and health insurer PreferredOne. In partnership with the University of Minnesota, ...Fairview’s 32,000 employees and 2,400 affiliated providers embrace innovation to drive a healthier future through healing, discovery and education.