Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data Modeler/Architect

Human Capital Ventures, LLC

Data Modeler/Architect

San Francisco, CA
Paid
  • Responsibilities

     

    DATA MODELER/ ARCHITECT 

    Location: United States - California - San Francisco

    Position: Data Modeler/ Architect

    The Opportunity

    • The Data Modeler/ Architect in our organization designs, deploys and manages systems, databases, business applications, and data relationships, content, and application to more effectively
    • Serves as a primary contributor in the department's vision and implementation of the Business Intelligence program.
    • Partners with Data Engineers, DBAs, Data Operations and customers to guide development for enterprise Data Warehouse/Hadoop solutions.
    • Maintains and supports a culture of compliance, ethics and integrity.
    • Responsible for ensuring ongoing compliance with development practices in the data & analytics program.
    • Maintains knowledge of policies and procedures and performs in accordance with applicable regulatory requirements, external laws and accreditation standards as they relate to data and analytics

    You Will:

    • Leads business information modeling for large, complex projects and ensures that project information conforms to corporate information architecture standards.
    • Collaborates with business partners, data engineers, DBAs and analytics staff, and management to assess information and resource needs, identifies data sourcing, application, and maintenance, determines project impact, and ensures integration across projects.
    • Researches and evaluates alternative solutions and recommends the most efficient and cost-effective data management solutions. Identifies researches and recommends new methods for supporting information management as it relates to data management.
    • Develops high-level database architectures and ensures that database designs are consistent with information architecture and information management standards as well as industry standards.
    • Works with data engineers to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas. Performs other duties as assigned.

     

    You Bring:

    • Understanding of Oracle, Hive Tables, Hadoop partitioning
    • Data integration tools (Informatica, etc.), and metadata repository processes and tools.
    • Proven track record coordinating with project managers, participating in project planning and coordinating with development teams using agile methodologies delivering successful business intelligence solutions with complex data sources.
    • Strong oral, written and interpersonal skills for interacting and collaborating with analysts, data engineers, and business staff throughout all levels of the organization;
    • Ability to clearly communicate complex business problems and technical solutions.
    • Designs, deploys and manages systems, databases, business applications, and data relationships, content, and application to more effectively and efficiently manage business operations.

     

    You Have:

    • Bachelor's degree in computer information systems, computer science, business or related field.
    • Eight (8) years of information technology experience including a minimum of four (4) years experience designing, deploying, and maintaining relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence.
    • Extensive experience integrating disparate systems into conformed dimensions.
    • Strong hands-on ER-Studio data modeling tool experience.
    • Experience with a range of relational database management systems (RDBMS) (Oracle, SQL, MySQL, etc.) and RDBMS tuning.
    • Experience with Big-data (Hadoop) a Plus
    • Experience deploying and supporting large, complex data warehouse/business intelligence solutions (full life cycle).
    • Google Cloud Experience.

     

    IDEAL CANDIDATE Must haves:

     

    1. Enterprise Data Warehouse experience

    2. 4+ yrs designing, deploying and maintaining Conceptual, Physical and Logical models.

    3. ER Studio

    4. Oracle is our preferred RDBMSv + tuning expertise

    5. Hadoop

    6. Google Cloud experience

    Client offers an above average compensation plan, benefits, relocation and where appropriate, H1-B sponsorship.

    For these or other opportunities nationwide, please contact us at:

    robert@erecruitingsolutions.com

    949.680.6121c

    415.314.4990c