The Business Intelligence (BI) Analyst will work with the BI team to deliver BI Solutions. This individual will help set the direction, strategy, and deployment of data that is critical to the success of the business. Incumbent will perform requirements analysis, data integration, data modeling, design, and BI development to deliver short and long term data solutions.
Nature and Scope
This position serve as a technical BI resource for Business Analysts, EDW Data Architects, as well as perform modeling, analysis, design and deployment of data delivery methodologies. Additionally, the candidate will assist with data governance, master data management and process documentation.
This position will also provide instruction and guidance to internal and external customers to ensure effective and efficient use of system resources. This position will be involved in selection, implementation and training of data tools and systems. Responsibilities include analysis of data requirements, resolution of data management and reporting related issues and participation in vendor and/or tool selection.
The incumbent will assist staff with data management and reporting system maintenance and troubleshooting as needed. The incumbent may work with outside vendors to provide and collect data needed in order to meet contractual obligations, reporting requirements, and/or company goals. This role requires strong technical ability as well as strong business acumen.
Additional responsibilities include:
â•– Building innovative data management and real-time analytic capabilities needed by the business
â•– Translate critical business requirements into actionable tasks
â•– Identify ways that the data infrastructure can best support or optimize business growth
â•– Recommend/set standards to improve quality of data and speed of analysis
â•– Collaborate with Data Architects and Application Specialists on changes associated with systems and interfaces
â•– Perform high level and detailed data requirements analyses, design and deploy complex data models
â•– Assist technical teams with data capture, ETL, validation, and test methods
â•– Perform data validation tests, QA testing of developed solutions
â•– Maintain and assist in data model documentation, data dictionary, and other MDM\\Data Governance documentation
â•– Provide analysis, recommendations to overall strategy to build data warehouse environment and supporting toolsets
Incumbent must possess:
â•– Thorough knowledge of physical database design and data structures (e.g. OLAP, Dimensional, Snowflake)
â•– Knowledge of one or more client-side development environments (e.g. Visual Studio .NET, Eclipse).
â•– Thorough knowledge of one or more database systems (e.g. Postgres, SQL Server, Oracle, Hadoop, MongoDB).
â•– Experience with data management platforms (e.g. SSIS, SSAS, SSRS)
â•– Proficiency in SQL.
This position does not provide patient care.
The foregoing description is not intended and should not be construed to be an exhaustive list of all responsibilities, skills and efforts or work conditions associated with the job. It is intended to be an accurate reflection of the general nature and level of the job.
Requirements – Required and/or Preferred
A Bachelor’s degree in Computer Science, Information Systems, Operations, Management, or other related field is required. Experience may be substituted for required education on a year-for-year basis.
Requires a minimum of three (3) years IT\\IS experience with at least one (1) year working in data management, analysis, governance, reporting, or other BI related experience. At least two (2) years healthcare data experience is preferred, but not required. SQL experience and proficiency is required.
Computer / Typing:
Must be proficient with Microsoft Office Suite, including Outlook, PowerPoint, Excel and Word and have the ability to use the computer to complete online learning requirements for job-specific competencies, access online forms and policies, complete online benefits enrollment, etc.