OaklandRecruiter
the smart solution for Oakland jobs

Data Warehouse System Analyst

Company: Amerit Consulting
Location: Oakland
Posted on: May 17, 2018

Job Description:

Company Overview: Creating value by bringing together the right people to achieve results is our motto. Our clients and employees say they choose to work with us because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our client, with missions in University teaching, research and public service and half-million annual enrollments, seeks an accomplished Data Warehouse System Analyst. Description: Client is sponsoring development of a data repository solution serving the information and reporting needs. In this highly complex technical and organizational environment, the system analyst position will provide consultation and support in the analysis and interpretation of source systems, development of functional and technical specifications, and design and execution of system testing. The system uses Hadoop technologies, and a star schema data warehouse structure to deliver reporting requirements to the end user. The system analyst will work with the business subject matter experts to identity reporting requirements, and translate these to specifications. Work with business subject matter experts and bridge communication between the business and technical teams. Write functional requirements, report specifications and technical design documents. Collaborate with the development and reporting teams on the creation and testing of the business reports. Collaborate with data architect and data team to document functional requirements describing the data load workflow process. Must understand the entire end to end data process flow and work with the data analyst and data architect to understand content, structure and quality of the data. Understand data model and mapping specifications in order to create QA test plans. Validate data for accuracy using SQL and other data validation tools. Develop and execute system test plans. Ensure that any issues raised during testing are addressed prior to migration into production. Participate in and support functional unit testing, integration testing, system testing and user acceptance testing activities, including authoring test plans, scripts, and data validation and certification processes. Requirements: Bachelor's Degree in Mathematics, Economics, Computer Science, Information Management, Information Systems, Statistics or a related field, or an equivalent combination of education and experience. The ideal candidate will have experience with Report Environment and data warehouse concepts. The candidate must have experience with report testing, system test development, test execution, and data verification using SQL. Minimum seven years of experience with data related projects with at least five years performing system analysis and testing on large, complex data warehousing and business intelligence systems. Experience with RDBMS and data warehousing concepts including: star schema, change data capture (CDC), and ETL. Ability to interpret data modeling/data workflow diagrams (conceptual, logical and physical Experience gathering reporting requirements from end users and translating to specifications. Experience writing functional and technical specification documents. Technical skills to collaborate and communicate with the data architect, data analyst, and ETL and reporting team. High proficiency with SQL (extensive experience querying large, complex data sets), XML, MS Excel (pivoting capabilities, analysis modules), MS Word. Experience writing system test plans. Extensive experience in test execution and quality assurance (QA Preferred: Knowledge of operational healthcare hospital/clinical workflows, health care trends, policies, and regulations such as HIPAA. Experience with medical incident data and reporting (RL Solutions), and in the installation of health care information systems. Experience with business intelligence reporting environments like Cognos, Tableau. Familiarity with Big Data concepts and Hadoop eco system (HDFS, Impala, Hive I'd love to talk to you if you think this position is right up your alley. If you're looking for rewarding employment and a company that puts its employees first, we'd like to work with you. We're driven, people driven. NOTE: Candidates that are offered a position are required to pass pre-employment drug and background screening. Qualified candidates with criminal histories, are considered in a manner that is consistent with local, state and federal laws.

Keywords: Amerit Consulting, Oakland, Data Warehouse System Analyst, IT / Software / Systems, Oakland, California

Click here to apply!

Didn't find what you're looking for? Search again!


I'm looking for
in category
within


Other IT / Software / Systems Jobs


Software Engineer
Description: Let companies apply to you, not the other way around Sign up with Employer to get
Company: Hired
Location: San Mateo
Posted on: 05/25/2018

Mobile Developer
Description: Let companies apply to you, not the other way around Sign up with Employer to get access to thousands of companies currently hiring mobile developers. Are you a Mobile Developer Would you
Company: Hired
Location: Lagunitas
Posted on: 05/25/2018

web developer
Description: Location: San Francisco, CA- United States br br Job ID: 18WD28690 br br Position Overview br br Autodesk is seeking a hands-on, engineering manager to join our Autodesk Accounts Platform (more...)
Company: Autodesk
Location: San Francisco
Posted on: 05/25/2018


Java Backend Developer
Description: Java Backend Developer 13 13 Ref No.:18-09251 13 13 Location: Bay Area, California 13 13 Position Type:Contract 13 13 Start Date: 05/21/2018 13 13 Job Title: Java Backend Developer 13 (more...)
Company: Diverse Lynx
Location: San Francisco
Posted on: 05/25/2018

SOAP UI API's Tester
Description: Please contact your eDataForce recruiter Ms. TAS for immediate consideration. REQUIREMENT: Title: SOAP UI API''s
Company: eDataForce Consulting LLC
Location: San Francisco
Posted on: 05/25/2018

Database Administrator , 12+ Months Contract
Description: Job Title: Database Administrator Oracle / HANA / SQL Server / MySQL Job Location: Reston, VA or South San Francisco, CA Job Duration: 12 Months Contract Consultant can choose to work from either Reston, (more...)
Company: radgov inc
Location: San Francisco
Posted on: 05/25/2018

Earn 800-1200 Weekly as a Health Rep... Need a Computer and a Phone
Description: Get the Comprehensive full training and an excellent career path with our health care rep positions now available.
Company: Jumpstart consult
Location: Elk Grove
Posted on: 05/25/2018

Senior ORacle Apps DBA (Phone Hire)
Description: 2. 8y Oracle DBA experience, 3. 5y experience with R12, RAC 11g/12c, 4. Experience with WebLogic and Scripting As a Database Engineer at Salesforce IT, you will be part of a dynamic global team delivering (more...)
Company: InfoObjects Inc
Location: San Francisco
Posted on: 05/25/2018

Field Service Engineer- GC/ GCMS - San Francisco Bay
Description: Agilent inspires and supports discoveries that advance the quality of life. We provide life science, diagnostic and applied market laboratories worldwide with instruments, services, consumables, applications (more...)
Company: Agilent Technologies
Location: San Francisco
Posted on: 05/25/2018

Full-Stack Software Engineer
Description: Let companies apply to you, not the other way around Sign up with Employer to get
Company: Hired
Location: San Rafael
Posted on: 05/25/2018

Log In or Create An Account

Username:
Password:
 

Forgot password?


Find us on Facebook

Find us on LinkedIn

Get the latest California jobs by following @recnetCA on Twitter!

Oakland RSS job feeds