TD

Data Designer I

TD

full-time

Posted on:

Location Type: Hybrid

Location: TorontoCanada

Visit company website

Explore more

AI Apply
Apply

Salary

💰 CA$69,700 - CA$98,400 per year

About the role

  • Develop and promote data models using industry standard modeling tools
  • Assess business requirements by researching / analyzing and documenting business data requirements
  • Define, build and manage data dictionary / catalog for respective data platforms, systems / servers /applications
  • Ensure metadata and data lineage is captured and compatible with enterprise metadata and data management tools and processes
  • Run quality assurance reports and resolve data integrity issues to ensure accurate reporting and data records
  • Gather, review, analyze, profile, validate, and map system data into the prototyping solution for further integration within data warehouse.
  • Develop solutions and recommendations for improving data quality and data integrity issues.
  • Analyze data issues and work with development teams to resolve issues
  • Ensure business data and information is retained and disposed in compliance with enterprise data standards, policies and guidelines
  • Collaborate with technology and business teams to ensure alignment and successful delivery of data solutions.

Requirements

  • Undergraduate degree or Technical Certificate and/or 2+ years of relevant experience from a business administration, statistical, mathematical, scientific or financial background
  • 2+ years of data engineering experience, with a strong focus on big data technologies, preferably Azure.
  • Strong SQL skills for data querying, transformation, and analysis, including joins, aggregations, and performance considerations.
  • Hands on experience with the Azure ecosystem; Azure Data Lake Storage, Azure Data Factory, Synapse and other related services.
  • Proficient in Python and PySpark.
  • Analytical mindset, critical thinking, and problem solving.
  • Experience in the Insurance Domain would be an asset.
Benefits
  • 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data modelingdata analysisdata dictionarydata qualitySQLPythonPySparkbig data technologiesdata integrationdata profiling
Soft Skills
analytical mindsetcritical thinkingproblem solvingcollaboration
Certifications
Undergraduate degreeTechnical Certificate