Data Modeler

• Design and maintain conceptual, logical, and physical data models
• Develop scalable dimensional models for analytics and reporting
• Collaborate with data architects and engineers to align models with platform and architectural standards
• Translate business requirements into high-quality, reusable data structures
• Ensure data consistency, integrity, and performance across data layers
• Support impact analysis, data lineage, and metadata documentation

• Translate business needs into data models supporting long-term solutions
• Work with Application Development to implement data strategies, build data flows, and develop conceptual data models
• Create and maintain conceptual, logical, and physical data models and corresponding metadata
• Optimize and update data models for new and existing projects
• Develop naming conventions and coding practices for consistent data models
• Recommend reuse of data models in new environments
• Reverse-engineer physical data models from databases and SQL scripts
• Evaluate data models and physical databases for variances and discrepancies
• Validate business data objects for accuracy and completeness
• Analyze data-related system integration challenges and propose solutions
• Guide analysts, engineers, programmers, and others on project limitations, capabilities, performance requirements, and interfaces
• Review software modifications to improve efficiency and performance
• Examine application designs and recommend corrections
• Support data architecture direction, strategy, standards compliance, implementation, and technical developers
• Coordinate with project managers, client business and technical staff, and project developers on data architecture best practices
• Develop and govern RDBMS, ODS, data marts, and data lakes on SQL/NoSQL platforms
• Oversee expansion of existing data architecture and optimize data query performance

• Design conceptual, logical, and physical data models for midstream data domains, including pipeline scheduling and nominations, volumetric measurement and allocations, gathering and processing, terminal/storage inventory, tariffs and regulatory reporting, and commercial contracts
• Own the Bronze → Silver → Gold layering strategy with data engineering
• Build and maintain dimensional models, including fact/dimension design, SCD Type 1/2 strategy, surrogate versus natural keys, and conformed dimensions
• Partner with data engineers to translate models into dbt sources, staging models, and marts, and review pull requests for modeling and naming standards
• Define and maintain the enterprise data dictionary, entity relationship documentation, and column-level metadata
• Evaluate source systems ingested via Informatica IDMC/CDIR and dbt and model their reconciliation into a single conformed view
• Lead data model reviews with commercial, scheduling, accounting, and regulatory stakeholders
• Support master data management for assets, meters/measurement points, contracts, counterparties, and tariff schedules
• Contribute to data governance, including naming conventions, modeling standards, data quality rules, and stewardship processes
• Assess the impact of new data sources and business changes on existing models and propose schema evolution strategies that avoid breaking downstream consumers