Senior Data Engineer

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

• Work with a scrum team(s) to deliver product stories according to priorities set by the customer and the Product Owners.
• Interact with stakeholders.
• Provide knowledge transfer to other team members.
• Working with big data pipeline into Microsoft BI technologies (BI Developer)

REQUIREMENTS

• Experience working with Amazon Web Services (AWS) infrastructure and technologies; DMS, Glue, Step Functions
• Knowledge in RDBMS
• Strong experience working with Python and Typescript
• Knowledgeable in the areas of data workload/job orchestration and batch automation technologies, including Linux shell scripting and process orchestration tools
• Experience designing and building data environments to support reporting and analytics, including data integrations and flow between disparate data systems.
• Experience with data modelling, data engineering, and/or data warehouse building.
• Self-starter, ability to work with little direction.
• Critical thinker with natural intellectual curiosity and strong analytical skills.
• Strong communication (verbal/written) and presentation skills.
• proficient in AWS data pipelines in a financial organization.
• Experience writing, troubleshooting, and optimizing T-SQL queries
• Experience with Azure SQL
• Experience designing and implementing Microsoft Power BI datasets
• Experience designing and implementing Microsoft Power BI reports and dashboards
• Experience using SQL Server Management Studio and/or Azure Data Studio

Nice TO Have

• Informatica and Teradata knowledge
• Use of process orchestration tool of ActiveBatch
• Data Visualization experience

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!