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

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 HIPAA regulations

Work Schedule:

Currently this company is following a hybrid work schedule. Staff are able to work from home 4 days a week and will report to the office 1 days a week. *****The company reserves the right to change the work schedules based on the company needs.

For more information please visit www.alignedtogether.com