Business Intelligence Analyst II

Position Summary: 

Business Intelligence Analyst II (BIA) is responsible for developing complex reporting using T-SQL language using various tools such as Microsoft SQL Server Reporting Services (SSRS) and other data visualization tools.  They are also responsible for developing and deploying new reports including self-service reports, dashboards, and visual representations to meet the needs of the organization. Ultimately, the goal is to aid in fulfilling our mission of positively impacting the health and wellness of those we serve in our community.

Essential Duties and Responsibilities: 

• Develops and deploys new reports and various visual representations including self-service reports using SSRS, Power BI, Excel, Pyramid Analytics and other BI Tools to meet the reporting needs of the organization
• Works closely with BI reporting development life cycle, including identifying Subject Matter Experts; Requirement Gathering; Requirement Gathering Documentation; Analysis, Design and Development; Testing, and Implementation
• Creates complex T-SQL queries for data extracts to create a large volume of SSRS and ad-hoc reports
• Designs, develops, modifies, and implements reports, including self-service reports, using Excel and/or SQL Server Reporting Services (SSRS) to meet the reporting needs of the organization
• Creates reports using SQL Server (2008, 2012, 2016) environment with an In-depth understanding of the report life cycle
• Creates reports that support different business requirements, with ability to create sub-reports and summary reports such as pivot tables in Excel or matrix reports in SSRS
• Works to proactively identify data quality issues, coordinate root cause analysis, implement fixes, and perform QA validations to build exception reporting where needed
• Provides management with project status updates, feedback, and appropriate reporting on responsibilities
• Resolves performance issues by performing data integrity and audit checks to ensure accuracy of reports
• Researches, reviews, and analyzes the effectiveness and efficiency of existing reports, and develop strategies for enhancing and improving the performance of these reports
• Participates in peer reviews as well as actively participate in improving project backlogs(s)
• Works with Business Teams to develop an understanding of each department's role within the company and to understand their unique reporting requirements to assist in the development of reports
• Maintains professional and technical knowledge by attending educational workshops and other 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.

Qualifications:  

• Must have Bachelor's degree (B. A. / B. S.) from a four-year College/university preferred
• Minimum of three (3) - five (5) years hands on experience in SQL Server technologies in Visual Studios Data Tools; Relational Database and proven SQL & Query writing skills
• Minimum of three (3) years in building Microsoft SSRS reports, data visualizations and designing dashboards 
• Minimum of two (2) – three (3) years working in a data warehouse environment
• Must have Advanced Microsoft Excel, PowerPoint, Tableau/Power BI skills, financial modeling, statistical modeling, descriptive analysis
• Strong business acumen with advanced analytical and problem-solving skills
• Experience in Extraction, and Transformation and Loading (ETL) (Microsoft SSIS preferred)
• Experience in dashboard development such as Power BI, Tableau, or Pyramid Analytics (preferred)
• Microsoft Certifications (preferred)
• EPIC Certifications in Tapestry Modules (preferred)

Skills and Abilities:  

• Strong understanding of reporting best practices and experience with defining, developing, and delivering data that enables various business teams to make critical business decisions
• Excellent communication skills, both written and verbal, to interact with the business in gathering requirements and presenting data from the reports
• Understanding of the healthcare business and works with end users to define reporting needs, deliver reports, and provide analysis and visualization of data
• Well-organized, action and results oriented team player with exceptional time management skills to support multiple initiatives simultaneously in a fast-paced environment with excellence in planning and execution.
• Proven ability to establish and articulate a vision, set goals, develop and execute strategies, and track and measure results with high attention to detail and the ability to prioritize
• Team oriented individual with good interpersonal skills and the ability to interact professionally with a diverse group, including executives, managers, and subject matter experts
• Knowledge of clinical and financial systems within a Healthcare environment desired
• Ability to adhere to coding standards and participate in peer code reviews
• Knowledge of project management methodologies and best practices
• Excellent presentation skills with solid communication capabilities and practices, both oral and written
• Ensure systems comply with HIPPA regulations

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 may occasionally lift and/or move up to 15 pounds.

 Work Environment: 

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. The environment includes work inside/outside the office, travel to other offices, as well as domestic, travel.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.

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.