Reporting Data Analyst

Sonoma Consulting Inc.; Naperville (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

A prominent consulting firm in Naperville seeks a Senior Reporting & Data Analyst responsible for programming and analysis. The ideal candidate will support user report requests, maintain existing reports, and develop new database applications to enhance automation. A Bachelor's degree and 5+ years of IT experience are required, along with a strong background in SQL, business intelligence, and programming disciplines.

Qualifications

• 5+ years experience in the IT field with knowledge of business intelligence and SQL.
• Experience in programming disciplines, business intelligence applications, and data warehouse concepts.
• Detail-oriented with excellent communication skills.

Responsibilities

• Support end user requests for timely report analysis from the data warehouse.
• Investigate business needs and develop new reports.
• Maintain existing reports and manage users’ permissions.

Skills

Reporting

ETL

SQL

Business Intelligence

SAP BO

Education

Bachelor's degree

Tools

Business Object

SQL

Microsoft Access

Job description

A 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

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