Job Information
Illinois Employer Data Engineer I in Deerfield, Illinois
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