Data Modeler - Plano, United States - Brooksource

    Brooksource
    Brooksource Plano, United States

    1 month ago

    Default job background
    Description

    Data Modeler

    If your skills, experience, and qualifications match those in this job overview, do not delay your application.

    Hybrid- Plano, TX

    Responsibilities:

    • Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
    • Primary focus would be to partner with Enterprise Architecture to create Data Models, establish data standards and govern across all development; advocate and assist in governing Enterprise Architecture standards and strategy via data solutions.
    • This would include independently analyzing project data needs, identifying and resolving data storage and integration needs/issues, and driving opportunities for data reuse; satisfying project requirements.
    • The Data modeler designs, implements, and documents data modelling solutions, which include the use of relational, dimensional, and NoSQL databases.
    • These solutions support enterprise information management, business intelligence, and other business interests.
    • Role will focus on data modeling, metadata management, data governance support of all business & subject areas.
    • Role will support data design activities to ensure alignment of key attributes across local, sector, and globally defined attributes
    • Governs Data design/modeling - documentation of metadata (business definitions of entities and attributes) and constructions database objects, for baseline and investment funded projects, as assigned; supports NAB/PBC Applications, Global MDM, EDW & Data lake /Lakehouse Modeling (Accountable)
    • Provides and/or supports data analysis, requirements gathering, solution development, and design reviews for enhancements to, or new, applications/reporting (Accountable/Consultation)
    • Independently complete designs and database object constructs on any supported platform, including Microsoft Azure, Synapse, Teradata, Sybase, Salesforce, Oracle
    • Supports assigned project contractors (both on- & off-shore), orienting new contractor standards, best practices, and tools (Accountable).
    • Advocates existing Enterprise Data Design standards; assists in establishing and documenting new standards (Accountable/Consultation).
    • Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL).
    • Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.
    • Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
    • Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
    • Knowledge on any cloud platforms, specifically Synapse and Azure is an added advantage.

    Requirements:

    • 5 + years' experience in Information Technology or Business Relationship Management
    • 3 + years' experience in performing data modeling/data design, hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
    • Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
    • Bachelor's degree in Computer Science, MIS, Business Management, or related field
    • Excellent remote collaboration skills
    • Advanced data modeling or database experience; experience with Data Lake/Lakehouse, Synapse, IDM, ER/Studio and/or Erwin modeling tools
    • Good knowledge of metadata management, data modeling, and related tools
    • Knowledge on Datalake/Cloud Platforms (Azure synapse/GCP Bigquery), ADF, Databricks, Pipeline Creations is a plus
    • Good understanding of CPG business processes, data, and EDW/MDM environments
    • Ability to work with agile delivery methodologies
    • Ability to ideate requirements & design iteratively with business partners without formal requirements documentation.
    • Exceptional written and verbal communication skills.