Canada · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Azure SQL, Microsoft Fabric, Power BI, Python, SQL
Costa Rica · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Azure SQL, Microsoft Fabric, Power BI, Python, SQL
United States · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Unqork, Low-Code/No-Code Development, REST API Integration, HTML/CSS, Agile/Scrum
Guatemala · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Unqork, Low Code/No Code, REST API, HTML, CSS
India · Remote OK
3PILLAR GLOBAL Company 3PILLAR GLOBAL Company 3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With t…
Skills: Salesforce Development, Apex, Lightning Web Components, SOQL, SOSL
Guatemala · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Azure SQL, Microsoft Fabric, Power BI, Python, SQL
Costa Rica · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Unqork, Low Code/No Code, REST API, HTML, CSS
Mexico · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Azure SQL, Microsoft Fabric, Power BI, Python, SQL
Canada · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Unqork, Low Code/No Code, REST API, HTML/CSS, Agile/Scrum
Mexico · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Unqork, Low Code/No Code, REST API, HTML, CSS
Canada · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Technical Account Management, Governance Oversight, Product Delivery, Technical Discovery, Data Schema Analysis
Costa Rica · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: C, C++, Linux, Multithreaded Programming, Network Protocols
Guatemala · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: C, C++, Linux, Multithreaded Programming, Network Protocols
Mexico · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: C, C++, Linux, Multithreaded Programming, Network Protocols
United States · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Technical Account Management, Governance Oversight, Product Delivery, Technical Discovery, Data Schema Analysis
Guatemala · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Python, REST API, SQL, Git, Pytest
Mexico · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Python, REST API, SQL, Git, Pytest
Canada · Remote OK
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Product Development, Agile Methodologies, Backlog Management, Stakeholder Management, Team Leadership
Romania · Remote OK
🌟 Distinguished Tech Innovator: 3Pillar warmly extends an invitation for you to join an elite team of visionaries. Beyond software development, we are dedicated to engineering solutions that challenge conventional norms…
Skills: Snowflake, Python, SQL, Amazon QuickSight, dbt
United States · Remote OK
$140k–$180k/yr
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin Ameri…
Skills: Program Management, Agile Methodologies, Product Development, Stakeholder Management, Retail Technology Transformation
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Lead the design and implementation of robust data platforms using Azure ecosystem tools and Data Lakehouse architectures. Oversee end-to-end analytics projects, mentor junior engineers, and integrate GenAI capabilities into data products.
Requires 7-10 years of experience in data engineering and BI, with at least two years of hands-on expertise in Microsoft Fabric, Azure SQL, and Power BI. Proficiency in Python and advanced SQL is essential for building scalable enterprise-grade pipelines.
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin America, and Asia, we work with the most ambitious companies in financial services, healthcare, media, and technology — helping them move faster, modernize boldly, and compete on their own terms. Our HelixAI platform and Helix Pods delivery model put our engineers at the center of real agentic transformation — doing work that is open, portable, and built to last. We are building the future of enterprise AI.
Embark on an exciting journey into the realm of software product development with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure. At 3Pillar, our focus is on leveraging cutting-edge technologies that revolutionize industries by enabling data-driven decision-making. As a Lead, Data Engineering, you will hold a crucial position within our dynamic team, actively contributing to thrilling projects that reshape data analytics for our clients, providing them with a competitive advantage in their respective industries.
If your passion for data engineering solutions that make a real-world impact, consider this your pass to the captivating world of Data Science and Engineering! 🌍🔥
\nKey ResponsibilitiesUnderstand client requirements and lead the creation of robust data platforms leveraging Data Lakehouse architectures, serving as the primary subject matter expert for the Azure data ecosystem (Microsoft Fabric, Azure SQL, and Power BI).
Design and implement scalable data models, ETL/ELT pipelines, and analytics layers using modern cloud ecosystems.
Architect Microsoft Fabric reporting solutions, establishing medallion layering, managing capacity planning, ensuring freshness governance, and configuring CDC/mirroring from Azure SQL into Fabric.
Enforce strict data-layer segregation ensuring PII is excluded by construction, maintaining multi-tenant isolation within the analytics layer, and strictly adhering to 10+ year regulated data retention policies.
Lead complex migration efforts off legacy systems (e.g., AirTable, Smartsheet) to Microsoft Fabric, effectively managing mid-program form and rule drift, and establishing reliable, per-client export channels.
Lead end-to-end analytics projects — from requirement gathering to deployment.
Mentor junior team members, perform code reviews, and ensure adherence to quality standards.
Work closely with cross-functional teams (engineering, product, business) to align data strategy with business goals.
Develop and optimize complex SQL queries, Power BI semantic models, dashboards, and reports (transitioning from legacy LookML/BigQuery paradigms).
Troubleshoot performance bottlenecks, data inconsistencies, and integration challenges.
Stay up to date with advancements in the analytics and cloud data ecosystem.
Drive innovation in reporting and analytics capabilities.
Recommend and implement new tools, frameworks, and practices to enhance the data platform.
Define best practices, coding standards, and governance for analytics projects.
Monitor data systems performance and implement optimization strategies.
Ensure data accuracy, integrity, privacy, security, and compliance through quality control procedures.
Build and oversee AI-ready data pipelines, focused on feeding scrubbed, segmented data to assistive AI (embeddings, vector stores, and feature stores) and integrating GenAI into analytics and data products.
Drive adoption of AI-assisted data engineering across the team: copilots for SQL/transformation/pipeline code, plus automated testing and documentation.
Define governance and quality standards for data consumed by LLMs and agents.
Demonstrated expertise with a minimum of 7 - 10 years of relevant experience in data engineering and business intelligence domain.
Strong primary expertise in the Azure Data Stack, specifically Azure SQL, Microsoft Fabric, and Power BI (semantic layer design, robust dashboard development), with a minimum of two years of hands-on experience in these specific tools.
Advanced SQL skills and a solid understanding of modern data architecture, including Data Lakehouse concepts, medallion architecture, star/snowflake schemas, and dimensional modeling.
Proficiency in Python for data engineering, ETL/ELT workflows, and automation tasks.
Experience designing and maintaining enterprise-grade data pipelines — specifically in Azure environments.
Proven track record of leading analytics projects and delivering scalable data solutions.
Ability to function as a player-coach — leading while also contributing hands-on.
Solid understanding of data governance, security (especially around PII and multi-tenant architectures), and performance optimization practices.
Strong communication skills and ability to translate complex technical concepts for business stakeholders.
Experience working with DBT
Experience working with other BI Tools
Any experience of working with Gen AI tools or technologies
Medical & dental insurance - with employee contributions
LTD, Life & AD&D insurance - employee paid
Paid time off
10 Paid Holidays
RRSP with Employer Matching
Flexible work policy
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!
Together we create incredible
At 3Pillar, we believe something truly incredible happens at the intersection of product engineering and cognitive computing. As the leading modern application strategy, design and engineering firm, 3Pillar brings unrivaled expertise that enables clients to execute the mission-critical software development initiatives needed to compete in the modern digital economy. Our global team doesn't just develop software—we help clients set bold ideas into motion and accelerate innovation.
Offices: 4100 Monument Corner Drive, Suite 200, Fairfax, VA 22030, US · IMPS Moara Business Center, Buftea No. 1, Second Floor, Cluj-Napoca, Cluj-Napoca 400606, RO · B-25, Sector 58, Noida, 201301, IN · City Business Centre, Coriolan Brediceanu No. 10, Building B - 1st Floor, Timisoara, Buenos Aires 300011, RO · San Joaquin, Heredia, CR
Together we create incredible
At 3Pillar, we believe something truly incredible happens at the intersection of product engineering and cognitive computing. As the leading modern application strategy, design and engineering firm, 3Pillar brings unrivaled expertise that enables clients to execute the mission-critical software development initiatives needed to compete in the modern digital economy. Our global team doesn't just develop software—we help clients set bold ideas into motion and accelerate innovation.
Offices: 4100 Monument Corner Drive, Suite 200, Fairfax, VA 22030, US · IMPS Moara Business Center, Buftea No. 1, Second Floor, Cluj-Napoca, Cluj-Napoca 400606, RO · B-25, Sector 58, Noida, 201301, IN · City Business Centre, Coriolan Brediceanu No. 10, Building B - 1st Floor, Timisoara, Buenos Aires 300011, RO · San Joaquin, Heredia, CR
