Data Architect GCP

3Pillar; Canada; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A prominent technology firm in Canada is seeking a knowledgeable Data Architect to drive business intelligence and analytics solutions. The role involves assessing data components, designing data platforms, and developing automated data pipelines. Ideal candidates should have recent experience in SQL, Python, and GCP, along with a solid understanding of data modeling. The firm offers a flexible work environment and opportunities for career growth.

Benefits

Flexible work environment

Career growth opportunities

Well-being initiatives

Qualifications

• Recent experience as a Data Architect.
• Hands-on expertise in SQL, Python, ERD, and GCP.
• Ability to design and optimize database models.
• Extensive experience in data modeling.
• Proficiency in system testing and troubleshooting.

Responsibilities

• Assess existing data components and consult with stakeholders.
• Propose end-to-end solutions for data-related business problems.
• Design large data platforms for Data Engineers and Analysts.
• Define tools for developing automated data pipelines.
• Perform database modeling and maintain documentation.

Skills

SQL

Python

ERD

GCP (BigQuery, GCS, Cloud Functions, Composer)

DBT

Data modeling

Data visualization tools

Job description

Distinguished Tech Innovator:

Embark on an exciting journey into the realm of data analytics with 3Pillar! We invite you to join our team and support our clients in harnessing the power of their data by defining reference architectures. As a Data Architect, you will work closely with business leaders and information management teams to develop and implement data management, business intelligence, or analytics solutions.

If you are passionate about data analytics solutions that have a real-world impact, consider this your gateway to the captivating world of Data Science and Engineering!

Responsibilities

• Assess existing data components, perform proof of concepts (POCs), and consult with stakeholders.
• Propose end-to-end solutions for enterprise data-related business problems, including data collection, extraction, integration, cleansing, enrichment, and visualization.
• Design large data platforms to enable Data Engineers, Analysts, and Scientists.
• Gain exposure to different data architectures, including data lakes and data warehouses.
• Define tools and technologies for developing automated data pipelines, ETL processes, dashboards, reports, and insights.
• Continuously reassess the current state to align with architecture goals, best practices, and business needs.
• Perform database modeling, decide on optimal data storage solutions, create data flow diagrams, and maintain documentation.

Requirements

• Recent experience as a Data Architect with hands-on expertise in SQL, Python, ERD, GCP (especially BigQuery, GCS, Cloud Functions, Composer), and DBT.
• Experience working with Big Data (100TB+).
• Knowledge of modern data technologies.
• Ability to design and optimize conceptual and logical database models.
• Extensive experience in data modeling.
• Ability to analyze system requirements, implement data strategies, and ensure system efficiency and security.
• Proficiency in system testing, troubleshooting, and system enhancement.
• Deep understanding of database structures.
• Expertise in implementing and maintaining data pipelines.
• Knowledge of data mining and segmentation techniques.
• Familiarity with data visualization tools.
• Candidates will need to attend a code assessment test in SQL and Python.

Benefits

• Flexible work environment – office, home, or hybrid, with a remote-first approach.
• Be part of a global team, learning from top talent worldwide and communicating in English daily.
• Focus on well-being with initiatives on fitness, mental health, and generous time off.
• Opportunities for career growth across projects, offerings, and industries.
• We are an equal opportunity employer committed to diversity and inclusion.

Join us and be part of a global tech community! Check out our LinkedIn and Careers pages to learn more about being part of our #oneteam!