Data Modeller

Company Overview

Milestone Technologies is a global IT managed services firm that partners with organizations to scale their technology, infrastructure and services to drive specific business outcomes such as digital transformation, innovation, and operational agility. Milestone is focused on building an employee-first, performance-based culture and for over 25 years, we have a demonstrated history of supporting category-defining enterprise clients that are growing ahead of the market. The company specializes in providing solutions across Application Services and Consulting, Digital Product Engineering, Digital Workplace Services, Private Cloud Services, AI/Automation, and ServiceNow. Milestone culture is built to provide a collaborative, inclusive environment that supports employees and empowers them to reach their full potential.

Our seasoned professionals deliver services based on Milestone's best practices and service delivery framework. By leveraging our vast knowledge base to execute initiatives, we deliver both short-term and long-term value to our clients and apply continuous service improvement to deliver transformational benefits to IT. With Intelligent Automation, Milestone helps businesses further accelerate their IT transformation. The result is a sharper focus on business objectives and a dramatic improvement in employee productivity. Through our key technology partnerships and our people-first approach, Milestone continues to deliver industry-leading innovation to our clients. With more than 3,000 employees serving over 200 companies worldwide, we are following our mission of revolutionizing the way IT is deployed.

Job Overview

Certainly. Here's a polished and hiring-manager-ready Data Modeler Job Description that would fit a modern Data & Analytics team supporting Data Engineering, Governance, Analytics, and Product organizations.

About the Role

We are looking for a highly skilled Data Modeler to design, develop, and maintain enterprise-wide data models that support reporting, analytics, operational systems, data products, and AI-driven initiatives.

The ideal candidate will work closely with Data Engineering, Product Management, Data Governance, Analytics, Architecture, and Business teams to ensure data is structured, scalable, governed, and aligned with business objectives. This role is critical in building trusted, reusable, and high-quality data assets across the organization.

Key Responsibilities

Data Modeling & Design

• Design and maintain conceptual, logical, and physical data models for enterprise data platforms.
• Develop scalable data structures to support analytics, reporting, operational applications, and data products.
• Define entities, attributes, relationships, hierarchies, and business rules.
• Create dimensional, relational, and canonical data models based on business requirements.
• Ensure data models support current and future business needs while maintaining consistency across domains.

Data Architecture & Engineering Collaboration

• Partner with Data Engineering teams to implement data models across data lakes, warehouses, and lakehouse architectures.
• Support design and optimization of enterprise data platforms and data pipelines.
• Translate business requirements into technical data structures and schemas.
• Collaborate with solution architects to ensure alignment with enterprise architecture standards.
• Drive adoption of best practices in data modeling and database design.

Product & Analytics Partnership

• Work closely with Product Managers to understand business requirements and define data structures that support product capabilities.
• Collaborate with Analytics teams to enable reporting, dashboards, KPIs, and self-service analytics.
• Support the design of reusable and governed data products that can be leveraged across multiple business functions.
• Participate in discovery sessions and solution design workshops with business stakeholders.

Data Governance & Quality

• Partner with Data Governance teams to establish and enforce data standards, naming conventions, and modeling guidelines.
• Support data lineage, metadata management, and master data initiatives.
• Ensure compliance with data privacy, security, and regulatory requirements.
• Proactively identify and address data quality and consistency issues.
• Promote data stewardship and governance practices across the organization.

Documentation & Standards

• Maintain comprehensive documentation for data models, definitions, and business rules.
• Create and manage data dictionaries, metadata repositories, and lineage documentation.
• Conduct model reviews and recommend improvements.
• Establish and maintain enterprise data modeling standards and best practices.

Stakeholder Management

• Act as a trusted advisor on data structures and information architecture.
• Collaborate with Engineering, Product, Project Management, Governance, and Analytics teams to deliver enterprise data solutions.
• Communicate data design decisions and recommendations to technical and non-technical audiences.
• Support project teams in assessing the impact of business and system changes on data assets.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Data Science, or related field.
• 5+ years of experience in Data Modeling, Data Architecture, or Data Warehousing roles.
• Strong expertise in conceptual, logical, and physical data modeling techniques.
• Experience designing relational and dimensional data models.
• Strong understanding of data warehousing and modern data platform architectures.
• Advanced SQL skills and understanding of database design principles.
• Experience working with large-scale enterprise data environments.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• Experience with AWS Iceberg, Snowflake, Databricks, Redshift, or similar cloud data platforms.
• Experience using data modeling tools such as Erwin, ER/Studio, PowerDesigner, Enterprise Architect, or equivalent.
• Strong understanding of Data Vault, Kimball, and dimensional modeling methodologies.
• Experience supporting Power BI, Tableau, Looker, or other BI platforms.
• Knowledge of Master Data Management (MDM), Metadata Management, and Data Governance frameworks.
• Experience within Payments, Financial Services, FinTech, Risk, or Fraud domains.
• Exposure to AI/ML data requirements and feature engineering concepts.

Technical Skills

• Data Modeling (Conceptual, Logical, Physical)
• Dimensional Modeling
• Data Warehousing
• SQL
• Data Architecture
• Metadata Management
• Data Governance
• Master Data Management
• ETL/ELT Concepts
• Cloud Data Platforms
• Database Performance Optimization
• Data Quality Frameworks

Key Competencies

• Strong Business Acumen
• Stakeholder Management
• Analytical Thinking
• Problem Solving
• Collaboration & Teamwork
• Attention to Detail
• Communication Skills
• Documentation Excellence
• Strategic Thinking
• Continuous Improvement Mindset

Success Measures

The successful candidate will:

• Deliver scalable and reusable enterprise data models.
• Improve data consistency, usability, and quality across platforms.
• Enable faster delivery of analytics and reporting solutions.
• Support governance, compliance, and data stewardship initiatives.
• Reduce data redundancy and improve enterprise-wide data standardization.
• Drive adoption of trusted, well-documented, and governed data assets across the organization.

Ideal Candidate: A collaborative data professional who can bridge business requirements and technical implementation while working effectively with Engineering, Product, Analytics, Data Governance, and Architecture teams to build a trusted data foundation for the enterprise.

Compensation

Estimated Pay Range:

Exact compensation and offers of employment are dependent on circumstances of each case and will be determined based on job-related knowledge, skills, experience, licenses or certifications, and location.

Our Commitment to Diversity & Inclusion

At Milestone we strive to create a workplace that reflects the communities we serve and work with, where we all feel empowered to bring our full, authentic selves to work. We know creating a diverse and inclusive culture that champions equity and belonging is not only the right thing to do for our employees but is also critical to our continued success.

Milestone Technologies provides equal employment opportunity for all applicants and employees. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, gender identity, marital status, age, disability, veteran status, sexual orientation, national origin, or any other category protected by applicable federal and state law, or local ordinance. Milestone also makes reasonable accommodations for disabled applicants and employees.

We welcome the unique background, culture, experiences, knowledge, innovation, self-expression and perspectives you can bring to our global community. Our recruitment team is looking forward to meeting you.