Data Modeler (Oracle)

Beyondsoft
San Francisco, CA
Apply on Career Site Posted today

Job Description

Position Description

ESSENTIAL DUTIES / RESPONSIBILITIES:
• Collaborate with business areas and data owners to successfully implement business analytics and data warehousing solution
• Ensure operational and analytical business requirements for reporting across the organization
• Define and develop physical and logical data models to support reporting needs
• Experience with Flume, Hadoop, HBase and other open source projects.
• Experience with creating and interpreting map-reduce style data analysis.
• Experience with large distributed data and systems.
• Design, build and test extract, transform and load (ETL) functions following industry standards and best practices.
• Create, maintain, and manage documentation for all data warehouse design and development
• Design and implement data warehouse schema.
• Develop guidelines and best practices to ensure data standardization and consistency
• Perform data cleansing and data auditing as necessary to ensure data quality
• Solve problems and presents creative solutions to internal teams
• Work closely with engineers to design, implement and delegate components
• Develop and execute unit tests for product components
• Provide accurate work estimates for proposed projects
• Participate in resolving key issues that impact the performance of the product
• Work with QA to ensure high quality of delivered product
• Contribute ideas to improve product functionality, maintainability and/or performance of product.

SKILLS / EXPERIENCE:
Required:
• BS in Computer Science or equivalent degree required
• At least 2 years’ experience with ERWIN or similar data modeling tool.
• 4+ years hands-on experience with large scale data warehouses and analytics products.
• 4+ years of Relational and Dimensional Database Experience; Oracle Strongly Preferred
• 4+ years PL/SQL experience. Must be extremely proficient.
• 1+ years of big data analytics experience using Hadoop and Map Reduce.
• Performance tuning experience
• Data warehousing and modeling experience
• Good communication skills - able to communicate effectively with technical and product personnel
• Customer focused and team player

DESIRABLE:
• Experience with near real-time analytics process.
• Experience utilizing traditional BI and big data analytics products for reports.
• Knowledge of the implications of developing for high-availability clustered environments
• Experience with Oracle Loader and ODI.
• Experience with UNIX shell scripting
• Knowledge about Online game development
Apply Now

Company Info

Beyondsoft Consulting Reviews

19 Reviews
3.1
19 Reviews
Rating Trends

Recommend to a friend
Approve of CEO
(no image)
CEO
1 Rating
  •  

    A company with nice people

    • Comp & Benefits
    • Work/Life Balance
    • Senior Management
    • Culture & Values
    • Career Opportunities
    Current Employee - Anonymous Employee
    Current Employee - Anonymous Employee

    I have been working at Beyondsoft Consulting

    Pros

    The HRs are very nice, they will assist you with anything, proactively.

    Cons

    actually not yet found so far

    Advice to ManagementAdvice

    NA