Senior Business Intelligence Analyst

Position Summary:

The Senior Business Intelligence Analyst (SBIA) is responsible for developing complex projects using T-SQL language with tools such as Microsoft SQL Server Reporting Services (SSRS). This role focuses on creating and deploying reports, dashboards, and visualizations to meet the organization's reporting needs and support strategic decision-making. The SBIA will work collaboratively with business units to understand reporting needs, ensuring the delivery of meaningful insights that align with our mission of promoting healthier communities.

Essential Duties and Responsibilities:

• Develop and deploy reports and visual representations, including self-service dashboards, using tools like SSRS, Power BI, Excel, and Sharepoint.
• Manage the reporting development life cycle, including gathering requirements, designing, developing, testing, and implementing solutions.
• Create complex T-SQL queries for data extraction and develop a high volume of SSRS reports, both ad-hoc and scheduled, using SSIS packages.
• Design and implement reports using SQL Server and Excel to meet business needs.
• Develop reports that support a variety of business requirements, including pivot tables in Excel and matrix reports in SSRS.
• Identify data quality issues, perform root cause analysis, implement fixes, and develop exception reporting to improve data integrity.
• Collaborate with business teams to understand unique reporting needs, providing data analysis and insights as required.
• Establish and maintain best practices for data visualization and report standardization.
• Provide management with project status updates and feedback on assigned responsibilities.
• Conduct quality assurance to ensure the accuracy and performance of reports.
• Stay updated on current industry trends and technologies through continuous learning and training.

This job description in no way states or implies that these are the only duties performed by the employee occupying this position. Employees will be required to perform any other job-related duties assigned by their supervisor or management.

Skills and Abilities:

• Strong understanding of reporting best practices, including defining, developing, and delivering data to support business decisions.
• Excellent verbal and written communication skills for effective collaboration with business units and stakeholders.
• Solid understanding of the healthcare business and ability to translate complex data into meaningful insights for end users.
• Highly organized, results-oriented team player with time management skills to handle multiple projects simultaneously.
• Strong analytical skills with high attention to detail and the ability to prioritize tasks effectively.
• Knowledge of clinical and financial systems within a healthcare environment is a plus.
• Familiarity with coding standards, peer code review processes, and project management methodologies.
• Exceptional presentation skills with the ability to communicate technical information to non-technical stakeholders.
• Working knowledge of HIPAA regulations and compliance requirements.

Work Schedule:

As a continued effort to provide a safe and productive work environment, Community Care Plan is currently following a hybrid work schedule. Staff are able to work from home 3 days a week and will report to the office 2 days a week. *****The company reserves the right to change the work schedules based on the company needs.

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, use hands, reach with hands and arms, and talk or hear. The employee is frequently required to stand, walk, and sit. The employee is occasionally required to stoop, kneel, crouch or crawl. The employee must occasionally lift and/or move up to 15 pounds.

Work Environment:

While performing the duties of this job, the employee is occasionally exposed to vibration; whiteout; and toner. The noise level in the work environment is usually moderate. The noise level in the work environment is usually moderate.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.

We are an equal opportunity employer who recruits, employs, trains, compensates and promotes regardless of age, color, disability, ethnicity, family or marital status, gender identity or expression, language, national origin, physical and mental ability, political affiliation, race, religion, sexual orientation, socio-economic status, veteran status, and other characteristics that make our employees unique. We are committed to fostering, cultivating and preserving a culture of diversity, equity and inclusion.

#CCPDIC2024

Qualifications

• Associate degree required; Bachelor's degree (B.A. / B.S.) from a four-year college or university in a related field such as Computer Science, Information Technology, Data Analytics, or Business Administration preferred, OR a minimum of 7 years of relevant analyst work experience in lieu of a degree.
• Minimum of 7 years of hands-on experience with SQL Server technologies, Visual Studio Data Tools, relational databases, and complex T-SQL programming.
• At least 5 years of experience as a dedicated Report Developer or Reporting Analyst (Microsoft SSRS).
• Experience with ETL processes (Microsoft SSIS preferred).
• Knowledge of OLAP/Tabular Models (Microsoft SSAS preferred).
• Familiarity with dashboard development tools such as Power BI, Tableau, or Pyramid Analytics (preferred).
• Microsoft certifications (preferred).
• EPIC certifications in Tapestry Modules (preferred).

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.