This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/11840389

About us:

AAAHC advocates for the provision of high-quality health care through the development and adoption of nationally recognized standards. We provide a valuable survey experience founded on a peer-based, educational approach to onsite review. The AAAHC Certificate of Accreditation demonstrates an organizations commitment to providing safe, high-quality services to its patientsevery day of the 1,095-day accreditation cycle.

Our work environment includes:

• Hybrid work schedule - in office Monday-Wednesday
• Brand new, modern office setting
• Complimentary snacks in the office
• 37.5 hour work week
• Growth opportunities
• Wellness programs

About the Role:

Reporting directly to the Assistant Director, Business Intelligence theData Engineer, Business Intelligenceis an important member of the BI team central to our ability to extract, transform and load data from AAAHC proprietary software applications generating useful data sets and designing dashboards, reports and data streams necessary to meet business requirements. This includes gathering and interpreting data requirements, research and analysis, business design, data mapping, partnering with technology to develop data flow, and performing business testing. This position will be exposed to multiple data sources to align information with the business of AAAHC.

Transform data into insight that can help to improve the value of the businessguide operations, inform and validate business decisions, and increase value for our clients and regulatory partners.

• Determine data structure that integrates information from core operating systemsAccreditation Management System (AMS; legacy and new applications), Financial Management System (FMS), Learning Management System, and Website
• Design and generate dashboards and ad hoc/routine reports through BI office applications and interfaces with AAAHC core systems that improve business processes and decisions for both AAAHC and our key clients. Transform AMS and other system data into reports and data streams that fulfill AAAHC contractual requirements/agreements for CMS, State agencies, and key client groups.
  1. Collaborate with team members on translating business needs into data solutions including data collection/source identification, data selection criteria/filters, solution design, etc.
  2. Define data values, manage obsolete data, and coordinate user access.
  3. Organize data into appropriate file structures using defined standards.
  4. Integrate multiple data structures into common interrelational database structures.
  5. Validate that data structures are assembled and linked correctly.
  6. Optimize data structures for efficient end-user querying and analysis.
• Perform routine data analysis on large data sets.
• Develop User instruction documentation for accessing data solutions.
• Provide operational support in a variety of capacities including data integrity, quality assurance, monitoring, and reporting.
• Support, monitor, and maintain data warehouse, monitor trends and performance.
• Create and maintain documentation that includes design, requirements, report/dashboard standards, report generation processes, programming procedures and code for repeat usage, and BI user manuals for the organization

Minimum Qualifications and Job-specific Competencies Required:

Bachelors Degree in Computer Science OR equivalent 4+ years experience in roles that demonstrate business analytics, project management, and coding proficiency

Superior research, analytical, planning, organizational skills, and detail-orientation

Abili y to coordinate several tasks at one time and perform well under pressure; excellent time and project management

Ability to work independently, exercise mature professional judgment, and use discretion.

Minimum 2 years of demonstrated experience writing and troubleshooting T-SQL statements, and creating stored procedures, views, and SQL functions

Strong knowledge of Data Warehouse design techniques and a good understanding of Kimball data warehouse development methodologies

Experience designing, implementing, and optimizing data lakes, data marts, and star schemas, and a good understanding of related components and dependencies

Experience in logical and physical database design using relational database platforms including SQL Server and Oracle;demonstrated experience developing ETL/ELT packages using SQL Server Integration Services (SSIS) to bring large, complex data sets from various sources into a data warehouse

Demonstrated proficiency using data visualization tools (e.g., Microsoft Power BI, Tableau, Qlik, Cognos)

Customer service oriented

Advanced proficiency with Microsoft Office