Demo

Senior Data Modeler

PTR Global
St. Louis, MO Full Time
POSTED ON 4/1/2025
AVAILABLE BEFORE 4/26/2025

W2 only

CST AND EST time zone preferred

remote role

Looking for who can create logical data models without any training or support

you will be responsible for using your technical knowledge of professional concepts to solve business problems. We are looking for a talented individual that can serve as a subject matter expert in their area of focus and represent their department on complex assignments. You will be responsible for evaluating elements of technology's effectiveness through requirements gathering, testing, research and investigation and make recommendations for improvements that result in increased quality and effectiveness. You will be required to listen to and evaluate customer needs to determine and provide high quality solutions that align with customer expectations.

As part of Cloud Data Engineering team, you will need to work with other others to help build enterprise conceptual, logical, and physical data models for Databricks and Azure SQL technologies necessary to support reporting, business intelligence, advanced analytics, and data science data requirements.We are looking for an individual with knowledge of building enterprise data models. If you have a passion for data modeling and empowering smart business decisions, this is the role for you.

Should excel at interpreting and analyzing data across different levels of detail (grain) and have worked with business stakeholders to extract insights that align with business goals. Proficient in creating and understanding conceptual, logical and physical data models and have hands-on experience with PowerDesigner or Erwin data modeling software.

Job Description

  • Protects our customers, our employees, and our brands by incorporating security and compliance in all decisions; ensures security policy and procedure requirements are met; continuously identifies opportunities for improving security and implements strategies to improve our security posture.
  • Provides technical expertise for the planning, analysis, design, implementation, and control of the organization's data.
  • Handles complex or critical data management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database design, integration, source-to-target mapping, data modeling, data rules management (access by roles and geography, data quality / validation rules, measurements).
  • Consults with multiple client groups to provide solutions, implementing long-range internal and enterprise data architecture and management strategies.
  • Understand and translate business needs into data models supporting long-term enterprise solutions.
  • Closely interact with business partners, stakeholders, functional experts, business analysts, other contractors, and engineers to understand the system requirements and architect and design the data model and database schema based on the requirements.
  • Collaborate with Analytics Team to ensure optimized use of Analytics-Specific Data Architectures - striving for efficient, performant footprint
  • Design data models to best support analytics needs of the business, consistent with data strategy principles
  • Collaborate with IT and analytics team to arrive at a mutually agreeable data model architecture, approve specs, and review / test / audit post-implementation to ensure objectives have been met

Qualifications

Required

  • Strong data analysis skills including oral and written communication skills to effectively communicate with IT and business representatives.
  • Strong enterprise data modeling expertise
  • Must have 3 or more years of experience using data modeling tools and methodologies
  • Must have 3 or more years of experience writing and tuning complex SQLs, and the ability to analyze and make recommendations on results.
  • Expertise building conceptual data models through to physical data models and DDL / DML generation
  • Knowledge of building data assets that are strategic, trusted, and agile with governance for data accountability and responsibility
  • Working knowledge of modeling data access layers in an enterprise lakehouse environment
  • Must be able to collaborate in a team-oriented environment as well as work independently with direction.
  • Well versed in different data modeling methodologies (3NF, Dimensional, Data Vault)
  • Experience with cloud data lake solutions
  • Expertise with cloud data, enterprise data lake, and business intelligence development technologies.
  • Must be committed to incorporating security into all decisions and daily job responsibilities
  • Experience using either PowerDesigner or Erwin modeling software
  • Expertise in performing data analysis and data profiling across a diverse set of data
  • Experience working within a medallion architecture
  • Preferred

  • Bachelors degree in computer science, Computer Information Systems, Management Information Systems, or related field preferred
  • Experience with cloud lakehouse solutionsExperience with the following technologies :
  • o Databricks

    o Azure SQL

    o Teradata

    o PowerBI

    o SSRS

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior Data Modeler?

    Sign up to receive alerts about other jobs on the Senior Data Modeler career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $170,841 - $219,163
    Income Estimation: 
    $170,841 - $219,163
    Income Estimation: 
    $159,552 - $206,899
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at PTR Global

    PTR Global
    Hired Organization Address Salt Lake, UT Contractor
    Job Title: .NET Developer Location: Salt Lake City, UT - Hybrid schedule: 3 days/week in-office Duration: 6 Month of Pro...
    PTR Global
    Hired Organization Address Tualatin, OR Full Time
    Hello applicants! We have new role with our leading client in Tualatin Oregon ( Onsite) Client is looking to hire profes...
    PTR Global
    Hired Organization Address Tualatin, OR Full Time
    Job Title: Limited Renewable Energy Technician (Solar Technician) Job Location: Tualatin, OR | Monday - Thursday. Every ...
    PTR Global
    Hired Organization Address Woodbridge, NJ Full Time
    Position : Java Full Stack Developer Work Location : Hybrid in Wilmington, DE / Iselin, NJ (3 days onsite per week) Dura...

    Not the job you're looking for? Here are some other Senior Data Modeler jobs in the St. Louis, MO area that may be a better fit.

    DATA MODELER

    NTT DATA, Marshfield, MA

    Data Modeler

    NTT DATA, Inc., Queens, NY

    AI Assistant is available now!

    Feel free to start your new journey!