Data Analyst - Janesville, United States - Data Dimensions

Description

Purpose: The Data Analyst will be an integral part of the Data Team in building and scaling processing capabilities, data analysis and reporting. This role will center around supporting inbound data operations and mining complex data for valuable insights to support the team in making high quality, data driven decisions.

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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR c)