Entry Level Data Analysis Excel Jobs in Illinois

Summary
Skyway is looking for a Data Analytics Lead, who is comfortable within multiple, technical knowledge domains. We are open to hiring a recent graduate or entry level data analytics professional (2-3 years professional experience preferred) with the right mix of skills, experience with physical data modeling, good interpersonal skills as well as open-mindedness, and a background in a STEM discipline. This is a growth role that is designed to support the organization's short, medium, and long-term goals. For the ideal candidate, the responsibilities included reflect opportunities for development over a multi-year period, through both the technical and non-technical layers. Additionally, this position is based in Skokie, Illinois. Therefore, having the ability to commute and work on-site at least two times per week is required.
A critical element of the Skyway mission is to ensure that all team members, even those not providing direct clinical care, know and believe they can change and improve patient's lives. When serving with integrity and in alignment with the Skyway Mission, we create a reverberating positive impact on the patients.
Essential Functions/Core Responsibilities
• Collaborate with IT vendors and colleagues in physical modeling of data architecture.
• Build data infrastructure, data warehouse(s) in support of company strategic initiatives.
• In collaboration with IT vendor, participate in the management of separate virtual instances of:
o SQL databases
o Python
o Power BI
o ETLs between three separate data warehouses
• Lead, design, and maintain data ingestion in Microsoft SQL Server and MySQL.
o Write and deploy scripts that ingest the data verbatim in its logical model state.
o Possessing general awareness of gaps in the data will be critical to ensure data integrity.
o Ensure data quality and identify errors or abnormalities in data set with routine maintenance and validation.
• Lead the extraction of data from the Electronic Health Records ("EHR") software.
• Design reporting tools to identify trends for analysis.
• Utilize data and reporting to assist in building plans and strategic initiatives.
• Communicate and present analytical findings and gained insights to Skyway Leadership.
• In collaboration with IT vendor, participates in the establishment of secure servers and launch of Integrated Development Environment ("IDE") platforms.
• Assist the COO in maintaining model interoperability back to strategic KPIs owned by Finance.
• Ensures HIPAA compliance with any data extraction, ingestion, and distribution.
• Works with end user to present findings and assist in data interpretation.
• Establish and maintain good working relationships with internal stakeholders.
• Maintain end user engagement and backlog of currently known use cases.
• Maintain completion of all competencies associated with role and in accordance with Skyway Behavioral Health policies and subsequent Joint Commission standards.
• Supports the organization's mission, vision, values and strategic initiatives.
• Develops, implements, and improves processes to ensure that established policies, goals, and objectives are achieved.
• Ensures compliance with all applicable local, state, federal regulations, and guidelines.
• Perform other duties as assigned.
Minimum Requirements
• Bachelor's degree in data science, statistics, computer science or related field.
• 2+ years of professional experience in data modeling, visualization, and analysis.
• Proficient in use of data analytic tools, programming languages, and software (Python, R, PyCharm, Tableau, Power BI, Alteryx, Excel, Google Analytics).
• Proficient in database programming and software installation.
• Strong analytical, critical thinking, and problem-solving skills.
• Excellent written, verbal, and interpersonal communication skills.
• Attention to detail and ability to simultaneously work through multiple work priorities.
• Proactive self-starter with effective time management.
• Capable and adaptable to working in different settings.
• Exceptional organization skills, reliable and timely.
• Considerate, empathetic, and respectful of other's perspectives.
• Must be fluent in reading, writing, and speaking English
• Reliable form of transportation to work. Must be able to report on-site in Skokie, IL at least two times per week.
Additional Preferred Skills
• Exposure to clinical settings and familiarity with EHR systems.
• A passion for coaching, mentorship, and team-development.
• Passion for business, process transformation, collaboration, reporting, and all things digital.
• Ability to guide non-technical, clinical staff who have an interest in technology (both software tools and agile principles).
• A problem-solving orientation and eagerness to identify process gaps and implement practical solutions.
• Ability to work independently and recognizes the need for support while also demonstrating the willingness to ask for help.
• Ability to grow one's acumen so to continue building SBH's foundational business elements.
• Respond respectfully and with confidence during challenging or chaotic situations.
• Someone who embodies Skyway values:
o Embraces the whole person.
o Commits to innovative research-based programs.
o Believes we are better together.
o Celebrates expressions of diversity.
o Believes in service and supporting our communities.
o Views leadership as a privilege to elevate others to their highest potential.
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 accommodation 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 and talk or hear. The employee frequently is required to stand; use hands to finger, handle, or feel; reach with hands and arms; stoop, kneel, crouch, or crawl; and taste or smell. The employee is occasionally required to walk and climb or balance. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.
Benefits:
• Medical benefits- Blue Cross Blue Shield of Illinois
• Dental benefits- Blue Cross Blue Shield of Illinois
• Vision benefits- Blue Cross Blue Shield of Illinois
• Short & Term Disability- Blue Cross Blue Shield of Illinois
• 401K Safe Harbor Match- Ameritas BlueStar
• PTO
• Paid Holidays
• Paid Floating Holidays
• Paid Sick Time
• Paid Wellness Days
• Regular clinical supervision
• Collaborative professional growth development
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is occasionally exposed to wet and/or humid conditions and outside weather conditions. The noise level in the work environment is usually moderate. Work hours may vary in this leadership role and may require responding to phone calls from direct reports during off hours.
Skyway Behavioral Health is proud to be an Equal Opportunity Employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
We celebrate diversity and are committed to creating an inclusive environment for all employees.