Talent.com
Senior Data Modeler / data Engineer

Senior Data Modeler / data Engineer

BrokerLink InsuranceToronto, ON
30+ days ago
Salary
CA$40.00–CA$75.00 hourly
Job description

Being a part of BrokerLink, means you live our values : to act with integrity, be respectful of others, have a customer-driven mindset, strive for excellence and always treat others with generosity. These values drive our diversity and inclusion efforts to ensure a respectful and inclusive work environment is present.

We want like-minded individuals who want to provide the highest level of customer service, who carry themselves with utmost professionalism.

We want to invest in you! Your success is our success and our purpose of "we're here to help people" is what motivates us to keep the amazing talent we attract, for a long time. We want to bring out the best of all our team members! Offering countless opportunities to grow and an environment which values our most important assets, you, our team members. We have over 200 offices across Canada, ask us about our flexible work arrangements!

We are seeking a Senior Data Modeler / Data Engineer to join our Information Technology Department to play a crucial role in designing and implementing data models for a data warehouse / lakehouse that support our business requirements. The ideal candidate will have a strong background in data modeling, deep understanding of relational and multi-dimensional databases, OLTP and OLAP systems. This role involves making sure that the data solutions are scalable, repeatable, and effective in delivering insights and analytics to the business using Microsoft technology stack and Databricks.

What the role entails :

  • Collaborate with business stakeholders, analysts to align data needs and business requirements with the organization's strategic direction.
  • Perform data discovery tasks and tracing data lineage.
  • Create and maintain comprehensive technical documentation for database designs, solutions including ER, data flow, System architecture diagrams, data lineage, metadata and other relevant information.
  • Maintain a data dictionary, data source inventories, reference, and master data sets.
  • Create data models that accurately represent the organization's data assets and their relationships.
  • Develop and maintain conceptual, logical, and physical data models.
  • Design and implementation of schemas, tables, views, indexes, stored procedures, and other database objects.
  • Implement data quality measures and governance practices to ensure that the data being used is accurate, reliable, and compliant.
  • Integrate various data sources ensuring that data can be combined and accessed effectively.
  • Collaborate effectively with team members to achieve objectives and meet deadlines.
  • Collaborate with data governance teams to enforce data quality, security and compliance standards within the data lakehouse environment.
  • Provide technical guidance, and support to team members, fostering a culture of continuous learning and innovation.

The Successful Candidate will have :

  • If you feel you have the equivalent skills