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.
- Collaborate with team members on translating business needs into
data solutions including data collection/source identification,
data selection criteria/filters, solution design, etc.
- Define data values, manage obsolete data, and coordinate user
access.
- Organize data into appropriate file structures using defined
standards.
- Integrate multiple data structures into common interrelational
database structures.
- Validate that data structures are assembled and linked
correctly.
- 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