Job title: Senior/Lead Data ModelerLocation: Toronto, ON (Hybrid) Type: Contract Experience: 6–10 Years Must Have Skills: Java, SQL, Python (ETL scripting with pandas, polars, PySpark, ibis)Rate: $60/hr. on T4 and $70/hr. on INCAbout the RoleWe are looking for an experienced Senior/Lead Data Modeler to design, build, and optimize enterprise-grade data models and data pipelines for large-scale analytics and application workloads. The ideal candidate will have solid hands-on expertise in data modeling, ETL/ELT development, scripting, and experience working in modern cloud-based data platforms. This role requires technical leadership, excellent problem-solving skills, and the ability to collaborate with engineering, architecture, and business teams.Key ResponsibilitiesDesign and implement logical and physical data models for analytical and operational use cases.Develop scalable ETL/ELT pipelines using Python and associated libraries (pandas, polars, PySpark, ibis).Collaborate with architects and engineers to define data architecture standards and best practices.Analyze complex datasets, define data structures, and maintain data dictionaries, metadata, and schema definitions.Optimize SQL queries, data pipelines, and data transformations for performance and reliability.Integrate data from multiple structured and unstructured sources into centralized platforms.Work with Java-based services where integration of applications and data pipelines is required.Participate in sprint planning, technical reviews, and mentoring junior team members.Troubleshoot pipeline issues, validate data quality,



and ensure governance and compliance.Work cross-functionally with Cloud, DevOps, and Analytics teams in a hybrid cloud environment.Must Have SkillsJava – for integration, data ingestion frameworks, and backend workflow components.SQL – advanced querying, performance tuning, schema design, complex joins, stored procedures.Python – hands-on ETL scripting using libraries such as: pandaspolarsPySparkibisStrong understanding of data modeling (3NF, Star/Snowflake schema, Data Vault, Canonical models).Experience with large-scale distributed data processing.Good to Have Skills (Nice-to-Have)Azure Cloud PaaS Services (ADF, Databricks, ADLS, Azure Functions, Synapse).Databricks for Spark-based ETL, Delta Lake, and notebook development.Azure Data Factory for orchestration and pipeline automation.ADLS for data storage structures, partitioning, and access optimization.Experience with ETL orchestration tools such as: Apache NiFiGriffinHamiltonAirflowNoSQL databases – Cassandra, MongoDB.Docker & Kubernetes for containerized data applications.GitHub for version control and CI/CD workflows.DevOps CI/CD pipelines for automation and continuous integration.Familiarity with data governance, data quality, and lineage frameworks.QualificationsBachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or related field.6–10 years of experience in data engineering, data modeling, or ETL development.Proven background designing data models for enterprise environments.Strong communication, leadership, and analytical skills.Experience leading technical initiatives or data modeling workstreams.

📌 Data Modeler - $60 - $70 An Hour (Mississauga)
🏢 Hays
📍 Mississauga