Reporting Data Analyst
At a glance
Mid-level Data Analysis & BI role at Sonoma Consulting Inc. Naperville · full-time · no salary stated · we estimate $86,500–$135,038 across the United States.
Sonoma Consulting Inc. has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Analyze data warehouse information for user requests, then build reports around additional business needs you uncover
- Keep report filters and documentation current, and manage access for existing and new users
- Create database applications that automate business work and improve its quality
- Help shape ETL processes, check data loads and transformations, and work with developers on application requirements
- Program, test, maintain, and debug applications while supporting quality assurance and project updates
What you bring
- A bachelor’s degree and at least five years of experience in IT
- Working knowledge of SQL, business intelligence, programming languages, Microsoft Access, and data warehouse concepts
- Experience across multiple programming disciplines and business intelligence applications
- U.S. work authorization that does not require sponsorship
Who this fits
This full-time, mid-level role is based onsite in Naperville and suits an analyst comfortable with reporting, programming, and data warehouse work. You’ll also need to communicate project status and work with business users and application developers.
From the employer
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.
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.
** 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
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.