Emphasis on data warehousing, data cleansing and data quality.
Essential Functions & Accountabilities:
Works as primary data analyst on moderately or significantly complex projects and initiatives. Coordinates with project manager to document change requestsfor in-flight projects.
Follow established data analysis practices to elicit needs, analyze opportunities,and recommend solutions that deliver maximum value.
Utilizes Jama to record requirements and ensure signoff is obtained sorequirements are delivered on or before the due date.
Champions department standards for documentation and ensures that allassigned projects are complying and able to withstand audit scrutiny.
Participates in business process and technology initiatives to improve businessperformance.
Provides guidance in QA work when requested so the appropriate level oftesting is planned and executed.
Ensures that all items under their responsibility follow the SDLC including allapplicable change management processes.
Recommends best in class solutions to complex data questions and challenges.
Creates technical design document, source to target mapping that meets technical solutions and business needs of with end user, managers, and projectteams.
May provide system design input/recommendations as it relates to businessrequirements.
Required Skills:
Must have background and experience with Data Analysis toolkit including an understanding of systems development lifecycles, architecture and frameworks, strong analytics skills, problem solving and root cause analysis methods, Use cases, data and process modeling skills and document business process models.
Competency of data warehouse solution and design concepts, and dimensional modeling
Familiar with data cleansing and data quality
Requires a bachelor's degree in computer science, Information Systems, or Business Administration, Healthcare Administration, or related field.
Requires 5-9 years of relevant technical or business work experience with demonstrated experience within healthcare industry or data warehouse/analytics.
Strong ability to digest detailed information and apply critical thinking skills to business requirements, specifically in Healthcare Enterprise Datawarehouse environment.
Knowledge of vendor and/or internally developed systems including system interfaces, user functionality and various system environments.
Strong ability to generate options and facilitate decisions across business and IT partners while documenting business processes and system solutions.
Ability to communicate effectively, lead meetings, prepare documentation and present recommendations.
Organizational skills with the ability to multi-task, set priorities, follow up on open items and attention to detail.
Healthcare domain, SSIS & SQL Server knowledge
Experience:
7 years of IT Business Data Analyst experience with advanced experience working on ETLs for Datawarehouse in SQL Server databases
Experience with Azure, Azure DevOps, Azure Data Lake, Azure SQL Server is a plus.
Advanced experience with T-SQL, data warehousing design, BI concepts, and best practices
Bachelor Degree from an accredited college or university or equivalent practical and relevant experience.
Clear verbal and written communication skills.
Previous experience in the health industry, SSRS, or Power BI is a plus.