Data Engineer
January 3 2025
Industries
IT: Services
Categories Data Business Analyst,
Remote
Toronto, ON • Full time
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 offers
Searching...