Data Architect

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

Job summary

A global technology company is seeking a Data Architect to design and implement data architecture solutions. You will work closely with stakeholders to leverage data for business insights and create high-performance data platforms. The ideal candidate is proficient in AWS, SQL, and data visualization tools. Join a flexible, remote-first organization focused on well-being and career growth.

Benefits

Flexible work environment

Well-being programs

Career growth opportunities

Qualifications

• Experience in designing large data platforms.
• Strong hands-on experience with either Databricks or Snowflake.
• Proficiency in data validation processes.

Responsibilities

• Translate business requirements into data requests.
• Design secure and scalable data architectures.
• Coordinate with data scientists and analysts for data-related needs.

Skills

Data architecture

ETL processes

Data visualization

Database management

Data security regulations

Tools

AWS

Azure

Python

SQL

Tableau

Job description

Data Architect

Embark on an exciting journey into the realm of data engineering and architecture with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure. As a Data Architect you will be at the heart of the organization and support our clients to take control of their data and get value out of it by defining a reference architecture for our customers. This means that you will work closely with business leaders and information management teams to define and implement a roadmap on data architecture, data management, business intelligence or analytics solutions..If your passion for data analytics solutions that make a real-world impact, consider this your pass to the captivating world of Data Engineering!

Requirements

• Assessments of existing data components, Performing POCs, Consulting to the stakeholders
• Proposing end to end solutions to an enterprise's data specific business problems, and taking care of data collection, extraction, integration, cleansing, enriching and data visualization
• Ability to design large data platforms to enable Data Engineers, Analysts & scientistsStrong exposure to different Data architectures, data lake & data warehouse
• Define tools & technologies to develop automated data pipelines, write ETL processes, develop dashboard & report and create insights
• Continually reassess current state for alignment with architecture goals, best practices and business needsDB modeling, deciding best data storage, creating data flow diagrams, maintaining related documentation
• Taking care of performance, reliability, reusability, resilience, scalability, security, privacy & data governance while designing a data architecture
• Apply or recommend best practices in architecture, coding, API integration, CI / CD pipelines
• Coordinate with data scientists, analysts, and other stakeholders for data-related needs
• Help the Practice grow by mentoring junior Practice members, leading initiatives, leading Data OfferingsProvide thought leadership by representing the Practice / Organization on internal / external platforms

Responsibilities

• Translate business requirements into data requests, reports and dashboards.
• Strong Database & modeling concepts with exposure to SQL & NoSQL Databases
• Strong data architecture patterns & principles, ability to design secure & scalable data lakes, data warehouse, data hubs, and other event-driven architectures
• Expertise in designing and writing ETL processes in Python / Java / Scala
• Understanding of Hadoop framework - Exposure to PySpark, Spark, Storm, HDFS, Hive
• Strong hands‑on experience with either Databricks or Snowflake; experience with both is desirable.
• Knowledge of Master Data management and related tools
• Strong exposure to data security and privacy regulations (GDPR, HIPAA) and best practices
• Skilled in ensuring data accuracy, consistency, and quality
• Experience with the AWS / Azure / GCP data engineering services
• Knowledge of AWS services viz., AWS S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lakeformation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, API Gateway, CloudWatch
• And / OR
• Knowledge of Azure services viz., ADF, Data Catalog, Databricks, Azure Synapse Analytics, ADLS Gen2, Azure Devops
• Ability to implement data validation processes and establish data quality standards.
• Experience in Linux
• Proficiency in data visualization tools like Tableau, Power BI or similar to create meaningful insights

Desired

• Experience working with data ingestion tools such as Fivetran, stitch, or Matillion
• AWS IOT solutions
• Apache NiFi, Talend, Informatica
• Exposure to AI / ML technologies

Benefits

• At 3Pillar, we offer a world of opportunity :
• Imagine a flexible work environment whether it's the office, your home, or a blend of both. From interviews to onboarding, we embody a remote-first approach.
• You will be part of a global team, learning from top talent around the world and across cultures, speaking English everyday. Our global workforce enables our team to leverage global resources to accomplish our work in efficient and effective teams.
• Were big on your well-being as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging generous time off, we want all of our team members operating at their best.
• Our professional services model enables us to accelerate career growth and development opportunities - across projects, offerings, and industries.
• We are an equal opportunity employer. It goes without saying that we live by values like Intrinsic Dignity and Open Collaboration to create cutting-edge technology AND reinforce our commitment to diversity - globally and locally.
• Join us and be a part of a global tech community! Check out our site and Careers page to learn more about what its like to be part of our #oneteam!