3Pillar Global Logo

3Pillar Global

Data Engineer

Sorry, this job was removed at 08:34 a.m. (EST) on Thursday, Feb 13, 2025
Remote
Hiring Remotely in Canada
Remote
Hiring Remotely in Canada

3PILLAR GLOBAL Company 

At 3Pillar, culture is more than a buzzword. The power of culture, teamwork, and open collaboration drive our commitment to building breakthrough software solutions that power digital businesses. Our passion for products has gained us recognition in some of software’s most innovative spaces, including a spot on the Inc. 5000 list ten times, an Institute of Excellence in Sales (IES) Premier Sales Employer winner, a three-time winner of the Washington Post Top Workplaces Award, and notable features in Forbes, Fortune, and the Washington Business Journal. 


We work with clients to build incredible innovative products as their development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing, Information Services, and Retail. Our key differentiator is our Product Mindset and Lightwave Methodology. Our development teams focus on building for outcomes and all of our team members around the globe are trained on the Product Mindset’s core values – Minimize Time to Value, Solve for Need, and Excel at Change. Our teams apply this mindset to build digital products that are customer-facing and revenue-generating. Our business-minded approach to agile development ensures that we align to client goals from the earliest conceptual stages through market launch and beyond. 


WHAT WE BELIEVE

At 3Pillar, our core values – Intrinsic Dignity, Outsized Impact, Open Collaboration, and Continuous Improvement – drive our commitment to providing best in class product development services to high growth businesses across the globe. We’ve spent more than fifteen years building innovative software solutions. Our executive team has always held our values to the highest standard which has led to active participation on the Forbes Tech Council, a winner of the Ernst & Young Entrepreneur of the Year Award, and a spot on the Washington Business Journal’s Women Who Mean Business list. 

RESPONSIBILITIES

  • Craft data pipelines that are accurate, performant, testable, scalable, secure, and generally of the highest quality
  • Apply industry-leading design patterns to ensure resilience, traceability, and predictability of the ETL process.
  • Actively contribute to agile project teams during scrums, sprint planning, and code reviews.
  • Participate in requirements analysis sessions, technical design, implementation, testing, problem analysis and resolution, and technical documentation.
  • Responsible for integration testing
  • Articulate technical issues to peers, architects and project managers while recommending creative solutions.
  • Diagnose process failures and data quality issues and devise remediation solutions in a timely fashion.
  • Client-facing experience and strong communication skills.
  • Actively participate in accurate planning and estimation efforts, utilizing project methods and tools.
  • Promote client success across the team by collaborating with engineers, designers, and managers to understand user pain points, anticipate potential problems, and iterate on solutions that drive client success.
  • Actively participate in the Engineering Practice community, mentoring others through Communities of Practice (CoPs) or on project teams, and supporting the growth of technical capabilities.
  • Independently drive project delivery within defined architecture, demonstrating autonomy and accountability in all stages from conceptualization to deployment.

REQUIREMENTS

  • Bachelor’s degree in Computer Science or Software Engineering with a thorough understanding of CS fundamentals and theory relevant to application development.
  • A minimum of 4 years of experience/expertise in the following areas specified below*:
  • Oracle PL/SQL OR SQL Server T-SQL OR any equivalent procedural database language 
  • SSIS OR Datastage OR Informatica OR any equivalent graphical ETL tool
  • SQL- candidate should be able to demonstrate mastery 
  • Industry standard approaches to dev ops, including version control systems (GIT etc.) automated deployment (Jenkins, Azure Devops etc) database deployment tools (Liquibase, MS DACPAC etc)
  • Ingesting large volumes of data to a Data Warehouse or Data Lake, from diverse data sources - flat files, various relational databases, web services, JSON, XML etc.
  • Transforming and loading large volumes of data to a data model adhering to Kimbal design concepts 
  • Experience in Agile software development methodologies.
  • Client-facing experience and strong communication skills.

NICE TO HAVE

  • Prior experience with Cloud (e.g. AWS) data warehouse platforms (e.g. Redshift) is nice-to-have

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!

Similar Jobs

12 Days Ago
Remote
Canada
Senior level
Senior level
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
As a Senior Data Engineer, you will lead data migrations to Databricks, build scalable data pipelines, and integrate data health metrics. Responsibilities include enhancing data governance, troubleshooting data issues, collaborating with teams to drive business outcomes, and applying Agile methodologies for project success.
Top Skills: AirflowCi/CdData GovernanceDatabricksEmrGitJavaPythonQuality ManagementScalaSnowflakeSQLTest Automation
20 Days Ago
Remote
2 Locations
Senior level
Senior level
Computer Vision • Healthtech • Information Technology • Logistics • Machine Learning • Software • Manufacturing
As the Data Engineering Manager at Dandy, you will lead the centralized data engineering team, shape its culture, and establish scalable data processes and infrastructure. You will collaborate with cross-functional teams to optimize workflows, develop a robust data platform, and advocate for a data-driven culture throughout the organization.
11 Hours Ago
Remote
Hybrid
7 Locations
Senior level
Senior level
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
As a Sr. Manager, Data Solutions Engineer at Pfizer, you will design and implement data solutions, oversee scalable data architectures, and lead projects focused on data integration and analytics. You will collaborate with teams to develop technology solutions and ensure compliance with regulations while driving business outcomes and enhancing data quality.
Top Skills: Analytical ReportingData LakesData MappingData MiningETLMetadataRelational Database ArchitectureWeb-Based Analytics Solutions

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account