
Data Designer I
TD
full-time
Posted on:
Location Type: Hybrid
Location: Toronto • Canada
Visit company websiteExplore more
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