Reporting Data Analyst

Posted 3 Days Ago
Be an Early Applicant
Naperville, IL, USA
In-Office
Senior level
Information Technology • Professional Services • Consulting
The Role
Provide and develop timely reports from the data warehouse using BI tools and SQL; maintain and build reports and database applications; design and validate ETL processes and data transforms; administer CRM and Accelehealth; support QA, documentation, and project reporting; ensure EPHI access compliance and provide backup to senior systems analysts/project managers.
Summary Generated by Built In
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

Skills Required

  • Bachelor's degree
  • 5+ years experience in IT
  • Proficiency with SQL
  • Experience with Microsoft Access
  • Experience with SAP BusinessObjects / Business Object reporting tools
  • Experience with ETL design and validating data loads/transformations
  • Familiarity with data warehouse concepts
  • Experience administering CRM and Accelehealth systems
  • Knowledge of business intelligence applications
  • Experience developing and maintaining database applications and reports
  • Knowledgeable about dental and life products
  • Ability to access and handle EPHI following company guidelines
  • Strong attention to detail and excellent communication skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
80 Employees
Year Founded: 2011

What We Do

Sonoma Consulting Inc. is a national IT consulting and executive search firm founded in 2011 by Mark McGee. The company operates through two business divisions—IT Consulting Services and Executive Search—serving approximately 150 national clients that range from entrepreneurial start-ups to Global Fortune 500 companies. It specializes in harmonizing systems and application or infrastructure development projects.

Similar Jobs

In-Office
3 Locations
257 Employees
75K-93K Annually
In-Office or Remote
2 Locations
353 Employees

Cox Enterprises Logo Cox Enterprises

Portfolio Manager, NextGear Capital (Chicago Central Market)

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Hybrid
Joliet, IL, USA
50000 Employees
50K-148K Annually

Cox Enterprises Logo Cox Enterprises

Fixed Operations Performance Manager

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Remote or Hybrid
IL, USA
50000 Employees
42K-124K Annually

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account