Position: Business data analyst (Oracle Autonomous Data Warehouse)
Location: Hybrid in Sacramento, California – 2 day/weekly onsite (local only)
Duration: 6+ Months Contract role
Visa:-USC GC
Must have experience with Oracle Autonomous Data Warehouse
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 post-implementation 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 hands-on, 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 Bachelor’s degree is required. Additional qualifying experience may be substituted for the required education on a year-for-year 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 cross-functional 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 large-scale 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 cost-benefit 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 cloud-based 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.
Thanks & Regards
Ankit Rav
Sr. Technical Recruiter
E-Mail: ankit.rav@sibitalent.com
Linkedin:- linkedin.com/in/ankit-choudhary-944b99238
image001.png@01DB0B5E.58D691D0” alt=”cid:image001.png@01D858E4.8AC3B8A0“>
Sibitalent Corp.
Website: www.sibitalent.com
101 E. Park Blvd., Suite 600, Plano, TX – 75074