Data Architect

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 Data Architect to join our Information Technology department to propose and support the implementation of systems and technology plans, architectures and standards in order to meet the company's strategic goals.

As part of our Employee Promise, here are some of the many perks of working with us:

• Flexible health and dental insurance benefits package
• Personal Spending amount to invest in your healthy lifestyle
• RRSP - Registered Retirement Savings Plan with Company matching
• ESPP - Employee Share Purchase Plan (TSX:IFC) program with matching aspect
• 'Dress for your day', dress according to your daily schedule
• Competitive compensation package with bonus aspect
• Employee discount program, including Apple, Bell, Rogers and more!
• Paid Time Off in the form of: Personal days, Volunteer days, Exam/Study Time, Jury Duty and starting at 3 weeks of vacation per year!
• Working for an employer who is regularly recognized as one of Canada's best employers such as Kincentric 2023.

What the Role Entails:

• Work closely with business stakeholders and analysts to develop data strategies and architectures that align with business goals
• Conduct data discovery and trace data lineage
• Create and maintain data architecture blueprints and roadmap
• Write complex SQL queries for intricate data analysis, profiling, and retrieval
• Develop and maintain technical documentation including database designs, ER diagrams, data flow charts, system architecture diagrams, data lineage, metadata, and other relevant details
• Manage and update a data dictionary, source inventories, and reference/master data sets
• Create and refine data models to accurately represent the organization's data assets and inter-relationships, based on a clear understanding of business requirements
• Develop and maintain conceptual, logical, and physical data models
• Design and implementation of schemas, tables, views, indexes, stored procedures, and other database objects.
• Establish and enforce data quality and governance to ensure data accuracy, reliability, and compliance
• Integrate diverse data sources ensuring that data can be combined and accessed effectively
• Collaborate with team members to achieve objectives and adhere to deadlines.
• Collaborate with data governance teams to uphold 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.
• Assess and recommend data-related technologies and tools

The Successful candidate will have:

*If you feel you have the equivalent skills, please apply*

• Bachelor's or master's degree in computer science.
• Minimum of 7 years of experience in data modeling, including experience with relational, star and snowflake schemas.
• Strong expertise in database design principles, data architecture, ETL/ELT and data warehousing concepts.
• Experience with various database including Microsoft SQL Server
• Experience with various data platforms such as Microsoft Power BI, Databricks, Apache Spark, Snowflake.
• Experience with Azure Cloud, Python development,
• Familiarity with data integration, ETL, visualization tools and technologies.
• Proficiency in data modeling tools.
• Strong understanding of data governance, data quality and security best practices.
• Ability to work collaboratively in a team environment and strong customer focus.
• Strong analytical and problem-solving skills, with the ability to troubleshoot complex issues.
• Ability to work in a fast-paced environment and managed multiple tasks simultaneously.
• Excellent verbal and written communication skills to work effectively with cross-functional teams.
• Property and Casualty insurance background (Nice to have).
• Ability to pass a criminal background check and credit check.

We thank all applicants for their interest, but only those selected for an interview will be contacted.

BrokerLink is committed to providing an accessible environment. Accommodations are available on request for candidates taking part in the selection process.

BrokerLink is committed to creating and maintaining an inclusive environment which embraces our diversities and sees them as our strength! We want to foster a workplace that makes all our team members and customers feel welcome and appreciated.

Discover more about BrokerLink! Visit our new dedicated Webpage - https://www.brokerlink.ca/campaign/discover-brokerlink

At BrokerLink, we value diversity and are committed to creating an inclusive workplace that inspires each of us to be the best we can be. Join our team and make a difference!