Senior Data Modeler – Mexico/India (Remote)
Full Time
India, Mexico
Posted 5 hours ago
Position Type: Full-Time Employment
Location: 100% Remote – Mexico or India
Experience: 5–7 years of hands-on experience designing and delivering data modeling and data warehousing solutions
Qualifications / Must-haves
- 5–7 years of hands-on experience designing and delivering data modeling and data warehousing solutions
- Requirements engineering: gathering, documenting, and translating business requirements into data models
- Strong understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas, fact and dimension design)
- Proficiency in data modeling techniques (conceptual, logical, and physical models; Kimball and/or Inmon)
- Advanced SQL skills
- Experience building and supporting reporting in Power BI
- English C1+ or equivalent (fluent written and verbal communication with US stakeholders)
Preferred Skills
- Experience with interactions data (calls and chats / contact center data)
- Familiarity with Cisco, ASAPP, and SQL Server platforms
- Knowledge of data quality concepts and practices
- Experience with Master Data Management (MDM)
- Experience working in SCRUM or other agile methodologies
Responsibilities
- Partner with business and technical stakeholders to gather, analyze, and document data requirements
- Design and maintain conceptual, logical, and physical data models for the enterprise data warehouse
- Build dimensional models (facts, dimensions, star/snowflake schemas) that support reporting and analytics
- Model interactions data (calls and chats) from contact center platforms into analytics-ready structures
- Write and optimize SQL to validate models, profile source data, and support data pipelines
- Collaborate with BI developers to ensure models power accurate, high-performing Power BI reports and dashboards
- Define and apply data quality rules, standards, and naming conventions across data assets
- Contribute to Master Data Management efforts, including defining golden records and key business entities
- Maintain clear documentation, including data dictionaries, model diagrams, and source-to-target mappings
- Participate in agile ceremonies and work closely with data engineers, analysts, and product owners in EST hours
ID: P31
Job Features
| Job Category | Data Engineering & Analytics |