Building digital businesses, together.
Data Architect, EDW
Location
Canada
Posted
7 days ago
Salary
$140K - $160K / year
Seniority
Lead
Job Description
Data Architect, EDW
3Pillar Global
• Architecture & Solution Design • Own full lifecycle delivery: requirements → design → build → deploy → adoption → optimization & support • Ensure performance, scalability, and reliability across EDW and BI platforms • Drive cloud deployment and production readiness of analytics solutions • Facilitate architecture and technical design sessions • Act as a trusted advisor bridging business strategy and technical delivery • Lead and mentor BI developers, data engineers, and analysts • Establish and enforce data governance, data stewardship, security, and reporting standards
Job Requirements
- 15+ years in data architecture, or data engineering roles
- Proven experience owning and delivering enterprise EDW/BI solutions end-to-end
- Demonstrated accountability for full lifecycle delivery (design, build, deploy, optimize, adoption)
- Expertise in cloud platforms such as AWS GLue and Amazon Redshift
- Deep expertise in dimensional modeling (star schema, fact/dimension design)
- Strong hands-on SQL and data modeling expertise using Microsoft SQL Server
- Experience building and optimizing ETL/ELT pipelines and large-scale data platforms using current ETL tools
- Proven Experience working with complex, high-volume, multi-source data environments
- Prior experience implementing or integrating BI solutions ideally using Tableau
- Experience deploying solutions in cloud environments (nice to have AWS, or Azure)
- Proven leadership experience mentoring teams and engaging senior stakeholders.
Benefits
- 100% 3Pillar funded medical and dental coverage for employees and their dependents
- Unlimited PTO
- Company paid disability and life insurance
- Generous Parental Leave
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Architect complex, high-volume data pipelines for production use. • Design and implement scalable data models serving multiple product and internal teams. • Own data quality frameworks and standards across key data products. • Build reusable patterns for transformations and metrics to drive efficiency. • Define and maintain core business metrics and Key Performance Indicators (KPIs) in partnership with Analytics. • Own the data products used across the company, ensuring reliability and performance. • Set and promote standards for data modeling and pipeline development. • Partner closely with Analytics, Data Science, and Machine Learning teams on requirements to reduce friction and accelerate their work. • Mentor engineers and actively participate in the hiring process.
• Design, develop, and maintain scalable data pipelines and analytics solutions in GCP. • Develop solutions for collecting, processing, and analyzing LLM token usage data. • Build forecasting and anomaly detection mechanisms to monitor AI consumption patterns. • Optimize and maintain BigQuery datasets and cloud-based processing environments. • Collaborate with cross-functional teams to translate business needs into scalable AI/data solutions. • Ensure high-quality data processing through testing, monitoring, and automation best practices. • Contribute to data architecture, analytics frameworks, and continuous improvement initiatives.
Role Description Corvi Technologies is building an AI-powered job matching platform for OPT, H-1B, and international job seekers in the USA — and we're currently developing a Chrome Extension that automates job discovery across top career portals. As a Data & Product Research Intern, you'll be a core part of this build. You'll navigate real-world job sites, validate how our extension behaves, and help us turn raw data into clean, structured insights. This is hands-on, meaningful work — not coffee runs or formatting decks. - Visit designated careers portals (Apple, Google, Microsoft, Amazon, and 20+ others) and systematically browse and interact with job listings as per a daily checklist. - Test Corvi's Chrome Extension in real-time — click through job listings, trigger extension actions, and observe how it captures and processes job data. - Log findings in structured Google Sheets — job title, location, posting date, URL, category, and any anomalies observed. - Report bugs, UI issues, or unexpected extension behaviour with clear steps to reproduce — no coding required, just clear observation. - Organize and clean collected job data: remove duplicates, standardize formats, and flag inconsistencies. - Compile brief weekly summaries of data patterns — which portals have the most OPT-friendly listings, trending roles, location clusters, etc. - Suggest improvements to the data collection checklist and testing workflows based on what you encounter daily. Qualifications - Currently pursuing a Bachelor's degree (3rd year preferred) in any stream — Engineering, BBA, BCA, B.Com, Statistics, or related fields are all welcome. - Detail-oriented and methodical — you notice when something looks off and you document it clearly. - Comfortable spending focused time browsing multiple websites and logging data systematically. - Basic familiarity with Google Sheets or Excel — if you know VLOOKUP or basic filters, you're ahead of the curve. - Reliable internet connection and a laptop with Chrome browser installed. - Good written English — your bug reports and data notes need to be clear and concise. - Curiosity about how tech products are built and how data powers decisions. Benefits - Work on a live product used by real users — not a mock project or case study. - Get a performance-based Letter of Recommendation from the founding team. - Flexible 4-hour schedule — fits perfectly around your college timetable. - Top performers may be offered a pre-placement or extended role post-graduation. - Direct exposure to a US-market SaaS startup — a strong resume differentiator.
Senior Data Engineer IS
ProvidenceProvidence caregivers are not simply valued – they’re invaluable. Join our team at Enterprise Information Services and thrive in our culture of patient-focused, whole-person care built on understanding, commitment, and mutual respect. Your voice matters here, because we know that to inspire and retain the best people, we must empower them. Working at our family of organizations means that regardless of your role, we’ll walk alongside you in your career, supporting you so you can support others. We provide best-in-class benefits and foster an inclusive workplace where diversity is valued, and everyone is essential, heard, and respected. Our 120,000 caregivers serve in over 50 hospitals, over 1,000 clinics, and a full range of health and social services across Alaska, California, Montana, New Mexico, Oregon, Texas, and Washington. As a comprehensive health care organization, we are serving more people, advancing best practices, and continuing our more than 100-year tradition of serving the poor and vulnerable.
• Apply knowledge of health care and database management to analyze clinical data, and to identify and report trends. • Design and build modern data-centric software applications to support clinical and operational processes across all parts of the healthcare system. • Work closely with the Product, Platform, and Architecture teams to deliver on joint efforts. • Build data pipelines and transformations, data enrichment processes, provisioning layers, and user interfaces to meet the requirements of key initiatives. • Mentor and assist less experienced Data Engineers and participate in research and development of new technologies to help set up repeatable processes or templates for other Data Engineers to follow.



