Reporting Data Analyst at Sonoma Consulting in Naperville, IL

Company Description

Halo Group is a premier provider of IT talent. We place technology experts within the teams of the world’s leading companies to help them build innovative businesses that keep them one step closer to their customers and one step ahead of the competition. We offer a meaningful work environment for employees, attractive and interesting engagements for consultants, and cutting-edge digital innovation for our customers.

We delight in helping our customers execute their digital vision. Big projects or small, Halo Group knows that by combining the highest quality talent with our unwavering support, we will become an invaluable extension of the team. Halo Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all areas of product/project governance, UX/UI, multi-platform applications, quality assurance/testing, cloud computing, and data analytics.

Since its inception, Halo Group has been recognized for numerous awards, including:

• INC 5000
• Future 50
• 101 Best and Brightest
• Michigan 50 Companies to Watch
• Goldline Research - “Most Dependable Companies”
• Ernst & Young - “Entrepreneur of the Year” Finalist

Job Description

Job Description: OVERVIEW OF POSITION: • The Senior Reporting & Data Analyst is responsible for programming and analysis functions as a member of a technical team. Work assignments will normally be given verbally, in writing or self-developed through active participation in requirements gathering meetings.

DUTIES & RESPONSIBILITIES: • Support end user requests for timely report analysis from data warehouse using Business Object, SQL, Access or other tools (30%). • Investigate and evaluate business needs proactively in addition to requests from users and develop new reports to fulfill those requirements (25%). • Maintain existing reports including selection criteria and documentation (20%). • Build new database applications to increase automation and quality for the business (15%). • Ensure all reports delivered timely and accurately. • Maintain existing users’ and new users’ permissions for reports. • Participate in design of ETL process from various platforms for load into the enterprise data warehouse or client systems as necessary. • Validate data loads and transformations. • Work with application developer to develop requirements documents for potential new applications. • Periodically interview business users to identify areas that could benefit from new/revised applications. • Be knowledgeable about dental and life products. • Design, code, test, maintain, and debug simple to complex programs and/or make modifications to programs. • Assist in preparation of internal design specification, unit test plans, and software installation documentation. • Assist in research for development, modification or enhancement of systems. • Assist in quality assurance testing for various IT applications. • Report on the status of projects and tasks both orally and in writing. • Administration of CRM and Accelehealth systems. • Provide basic backup support for the Senior Business Systems Analyst/Project Manager. • Access EPHI following the current guidelines as established at the company-wide and department levels. • Maintain regular and punctual attendance. • Perform other work-related duties as assigned.

Qualifications

EXPERIENCE & QUALIFICATIONS: • Bachelor’s degree and 5+ years experience in the IT field. Knowledge of business intelligence, SQL, programming languages and Microsoft Access. Require experience in multiple programming disciplines, business intelligence applications, and familiarity with data warehouse concepts. Detail oriented, excellent communication skills and able to work in a fast-paced, high-pressure environment.

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time. This is a Full-Time / Permanent job opportunity. Only for US Citizen and Green Card Holder / GC EAD / H4 EAD / Canadian Citizen ** All your information will be kept confidential according to EEO guidelines.

Titles: Data Analyst, Reporting Analyst, Reporting Data Analyst, Senior Data Analyst, SQL Data Analyst

Skills: Reporting, ETL, SQL, Business Intelligence, SAP BO, SAP Business Objects, SAP BO