Sonoma Consulting Inc.
Reporting Data Analyst
Sonoma Consulting Inc., Naperville, Illinois, United States, 60564
Halo Group is a premier provider of IT talent. We place technology experts withinthe teams of the world’s leading companies to help them build innovativebusinesses that keep them one step closer to their customers and one stepahead of the competition. We offer a meaningful work environment foremployees, attractive and interesting engagements for consultants, and cutting-edgedigital innovation for our customers.We delight in helping our customers execute their digital vision. Big projects orsmall, Halo Group knows that by combining the highest quality talent with ourunwavering support, we will become an invaluable extension of the team. HaloGroup's experienced consultants in Detroit, Atlanta and Dallas specialize in allareas of product/project governance, UX/UI, multi-platform applications, qualityassurance/testing, cloud computing, and data analytics.Since its inception, Halo Group has been recognized for numerous awards, including:INC 5000Future 50101 Best and BrightestMichigan 50 Companies to WatchGoldline Research - “Most Dependable Companies”Ernst & Young - “Entrepreneur of the Year” FinalistJob 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 AnalystSkills: Reporting, ETL, SQL, Business Intelligence, SAP BO, SAP Business Objects, SAP BO
#J-18808-Ljbffr
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 AnalystSkills: Reporting, ETL, SQL, Business Intelligence, SAP BO, SAP Business Objects, SAP BO
#J-18808-Ljbffr