OaklandRecruiter
the smart solution for Oakland jobs

Data Warehouse System Analyst

Company: Amerit Consulting
Location: Oakland
Posted on: September 13, 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: Software Engineers x2013 2 needed at junior, intermediate or senior levels xA0 Our client is a dynamic, growing young organization involved in data center monitoring, security and data analytics, (more...)
Company: Job Juncture
Location: Palo Alto
Posted on: 09/26/2018

Senior Software Engineer- Java (Metadata Foundation Team)
Description: Senior Software Engineer- Java Metadata Foundation Team br br Our Team br br https://youtu.be/SdDJB1ZkVXQ br br The Metadata Foundation team is on an ambitious mission to discover, analyze (more...)
Company: Informatica
Location: Redwood City
Posted on: 09/26/2018

Mobile Developer
Description: Let companies apply to you, not the other way around Sign up with Hired to get access to thousands of companies currently hiring mobile developers. Are you a Mobile Developer Would you like
Company: Hired
Location: Bolinas
Posted on: 09/26/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: Mill Valley
Posted on: 09/26/2018

4960 : APIGEE Lead
Description: VDart is an IT staffing firm based out of Atlanta, GA specializing in Digital Emerging technologies. Founded in 2007, VDart has over 1700 employees and contractors spread across 3 continents. We specialize (more...)
Company: VDart Inc
Location: San Francisco
Posted on: 09/26/2018

Sales Representative for Software San Mateo 2058927
Description: We are looking for a Sales Rep We require at least 1 year of previous software or hardware sales experience We Offer Great pay Great benefits Supportive work environment We have been recognized as (more...)
Company: NetHire
Location: San Mateo
Posted on: 09/26/2018

Java Technical Lead
Description: Responsibilities: Deliver solutions that are of high quality, scalable, cloud-based, re-usable and with intuitive user experience Work collaboratively
Company: Innova solutions Inc
Location: Santa Clara
Posted on: 09/26/2018

Cable: Become a Home-Based Satellite TV Technician/Installer
Description: Job Duties and Responsibilities br br Do you enjoy physical indoor/outdoor work, talking with people, providing customer service and learning new technologies Are you seeking an opportunity where (more...)
Company: DISH
Location: San Anselmo
Posted on: 09/26/2018

Technology Lead - US
Description: Role Technology Lead - US Auto req ID 27904BR Domain Manufacturing Skillset Java EE , J2EE Country USA State / Region / Province California Work Location Sunnyvale, CA Company ITL USA Job Description (more...)
Company: infosys
Location: Sunnyvale
Posted on: 09/26/2018

Software Engineer (Spark/Microservices) (Staff/Senior Level)
Description: Now is a great time to join as a software engineers and be at the center of the action. The role involves replatforming our current platform into distributed microservices and data pipelines, implementing (more...)
Company: Marin Software
Location: San Francisco
Posted on: 09/26/2018

Log In or Create An Account


Find us on Facebook

Find us on LinkedIn

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

Oakland RSS job feeds