Data Warehousing Director jobs in Rockford, IL

Essential Duties and Responsibilities:

• Write complex SQL queries and troubleshoot data extractions.
• Validate completeness and accuracy of client data.
• Serve as subject-matter-expert on claims, eligibility, authorization, and assessment datasets.
• Develop and monitor metrics related to client data quality and day-to-day operations.
• Collaborate with data engineers to automate and scale data processing capabilities.
• Identify and communicate potential data impacts on downstream users.
• Required to attend mandatory meetings and trainings, work scheduled overtime with minimal notice, and perform other duties as assigned per business needs.

Qualification Requirements –

 To perform the job successfully, an individual should demonstrate the following:

• Must be at least 18 years of age.
• Able to read, write and speak English.
• Successfully pass and maintain acceptable background checks and security clearances.
• Associate degree in business administration, finance or related field; 2 years’ experience as a Data Analyst, experience working with health care datasets is a plus.
• Strong SQL skills, ability to aggregate and analyze large data sets involving multiple tables and subqueries.
• Experience working with reporting tools to create and maintain dashboards / reports.
• Strong problem solving, quantitative and analytical abilities.
• A demonstrated track record of accomplishing goals, managing numerous processes and projects simultaneously, meeting deadlines, and holding yourself and others to a high standard.
• Excellent communication and collaboration skills.

Certificates and Licenses:

• No certificates or licenses needed.

Computer Skills:

• Must have knowledge of and work experience with Microsoft technologies, including SQL Server (2012 and higher), SSIS (or other ETL technologies), SSRS, PowerBI, and Office tools (Word, Excel, Outlook).
• Understanding of HA technologies including Availability Groups and SQL Clustering.