Business Solutions yst

Role: Business Solutions Analyst

Location: Hybrid Sacramento California (Local only)

Duration: 12 months Contract

Visa: All Visa Except TN and CPT

Client: State of CA

Interview: Video

Your candidate must have experience with Oracle Autonomous Data Warehouse or they will be rejected and you will be removed from our vendor list..

Description

We are seeking a senior handson Senior Business Solutions Analyst with strong communication skills for a longterm hybrid assignment with our Sacramento California based client. This position requires that you be able to work onsite in Sacramento California for at least 2 days/wk as determined by the client.

Key Duties/Responsibilities:
Lead business and systems analysis for data warehouse solutions including needs assessment process improvement and requirements gathering
Develop and document functional and technical specifications translating business needs into system designs
Create system architecture scope and objectives ensuring integration of all components
Prepare business cases cost estimates and lead the development of requirements and design specifications
Collaborate with stakeholders to implement solutions facilitating requirements sessions and documentation
Oversee data quality including checks validation and troubleshooting performance issues
Provide postimplementation support and coordinate EDW incident response
Conduct system testing including developing test plans and documenting results
Review existing architecture propose improvements and ensure security policy compliance.
Translate business and functional requirements into technical requirements for Data Warehousing efforts.
Demonstrate through direct handson recent practical experience in the areas identified with specific examples.

Requirements:
Must have eight (8) to ten (10) years of experience applying analytical processes on IT projects.
Must have a minimum of three (3) years of verifiable experience in database design development and warehouse architecture supportive of key duties/responsibilities identified above in an Oracle environment.
At least three (3) years of experience in the last 6 years as a business and/or systems analyst on a data warehouse project. At least one project should have involved Oracle ADW.
Five (5) years of experience performing business solutions analysis within the last 10 years
A Bachelors degree is required. Additional qualifying experience may be substituted for the required education on a yearforyear basis.

Skills and Abilities required:
Excellent communication and collaboration skills to work effectively with technical stakeholders and team members.

Experience with Oracle ADW on at least one major project.
Demonstrate strong communication skills including the ability to:
Effectively present complex technical concepts to diverse audiences
Write clear concise reports and documentation
Collaborate with crossfunctional teams and stakeholders
Demonstrated experience in leading technical conversations with various stakeholder groups.
Advanced knowledge in data management and data warehousing concepts such as Kimball Snowflake Star and Hybrid schemas
Proficiency in structured analysis principles and methods for largescale data systems
Strong systems analysis skills including requirements gathering and specification development
Experience with modern data modeling and design tools
Knowledge of enterprise data architecture and integration strategies
Familiarity with data governance and quality management practices
Understanding of business intelligence and analytics processes
Ability to conduct costbenefit analyses for data warehouse initiatives
Proficiency in designing and documenting complex data systems
Experience with ETL processes and tools in an enterprise setting
Knowledge of data warehouse design standards policies and best practices
Skill in analyzing and optimizing business processes related to data management
Understanding of data lifecycle management in large organizations
Familiarity with cloudbased data warehouse solutions and technologies
Ability to evaluate and recommend data system development projects
Experience in leading process improvement initiatives for IT and data functions
Knowledge of current trends in data technologies and their business applications

Desired Skills:
Solid understanding of data warehousing concepts and dimensional modeling
Ability to perform data mapping data analysis data cleansing and data validation if needed