Role overview

Qualifications

Strong database modeling concepts with exposure to SQL and NoSQL databases
Strong data architecture patterns and the ability to design secure, scalable data lakes, data warehouses, data hubs, and other event-driven architectures
Expertise in designing and writing ETL processes in Python/Java/Scala
Experience with AWS/Azure/GCP data engineering services and knowledge of data security and privacy regulations (GDPR, HIPAA) and data quality standards

Responsibilities

Translate business requirements into data requests, reports and dashboards; define data architecture roadmaps and implement data management, BI and analytics solutions
Assess existing data components, perform POCs, and consult stakeholders; propose end-to-end data solutions including data collection, extraction, integration, cleansing, enrichment and visualization
Design secure, scalable data platforms (data lakes, data warehouses, data hubs) and establish data governance, quality, security, privacy standards; define data flows and maintain related documentation
Collaborate with data scientists, analysts, and other stakeholders; mentor junior team members, lead initiatives, and contribute to thought leadership to grow the practice

Key facts

Remote from: Canada
Full time
Data Architect
English

Hard skills

Data Architecture Data Modeling Xplenty (ETL Tools) Data Warehouse Architectures Data Integration Data Cleansing Data Discovery Data Visualization Analytical Dashboard CI/CD Database Systems SQL (Programming Language) NoSQL Database Design Event-Driven Programming Data Hub Data Flow Diagram Performance Improvement Reliability Engineering Compliance Management Data Governance Master Data Management Data Quality Assessment Data Validation Linux Python (Programming Language) Java (Programming Language) Scala (Programming Language) Apache Hadoop Apache Hive Apache Spark Apache Storm Databricks Amazon Web Services Microsoft Azure Google Cloud Platform (GCP) Amazon S3 Amazon Redshift AWS Lambda Amazon DynamoDB AWS Elastic MapReduce (EMR) AWS Glue Amazon Athena Amazon QuickSight AWS Kinesis Apache Kafka Amazon API Gateway Amazon CloudWatch Azure Data Factory Azure Data Catalog Azure Databricks Azure Synapse Analytics Azure Data Lake Azure DevOps General Data Protection Regulation (GDPR) Data Consistency Matillion Apache NiFi Talend Informatica Thought Leadership Business Analysis Good Documentation Practices

Other skills

Communication
Collaboration
Mentorship
Leadership
Problem Solving

About the company

3Pillar

3Pillar Global builds breakthrough software products that power digital businesses. 3Pillar is an innovative product development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing and Information Services. Leveraging a lean and agile approach, 3Pillar delivers value-generating, digital solutions with specialized product strategy and management, user experience design, as well as software and data engineering expertise across mobile, cloud, and disruptive technologies. For more information on the company and our services, please visit https://www.3pillarglobal.com. For current job openings in North America, APAC, LATAM and EMEA, please visit https://www.3pillarglobal.com/career-opportunities/.

Company details

Company typeLarge

Industry

Company size1001 - 5000

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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.

We’re 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 Linkedin site and Careers page to learn more about what it’s like to be part of our #oneteam!