Senior Data Engineer

WE ARE 3PILLAR GLOBAL  At 3Pillar, culture is more than a buzzword. The power of culture, teamwork, and open collaboration drives our commitment to building breakthrough software solutions that power digital businesses. Our passion for software development has gained us recognition in some of the industry’s most innovative spaces, including a spot on the Inc. 5000 list ten years in a row, a three time winner of the Washington Post Top Workplaces Award, and notable features in Forbes, Fortune, and the Washington Business Journal. We are an innovative software development partner whose solutions drive rapid revenue, market share, customer growth and employee efficiency for industry leaders in Media and Publishing, Information Services, Banking and Financial Services, Insurance and Healthcare. Our key differentiator is our Product Mindset. 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 business-minded approach to agile development ensures that we align to client goals from the earliest conceptual stages through 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 software 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, together we create incredible.™ We are hiring new team members to assist us in continuing our growth trajectory as a fast growing global team of thousands of professionals. New members will live our shared values to deliver exceptional products and services to clients. 
• We support the comprehensive wellbeing of our team members, through:
• Career growth and development
• Physical and mental wellbeing: 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 unlimited PTO to take some needed time off, we want all of our team members operating at their best.
• Living our values as an equal opportunity employer, and, 
• Providing a comprehensive US benefits package that includes:
• Benefits: Medical, Dental, Vision, Life Insurance, Short Term/Long Term Disability 
• 401K retirement savings plan 
• Unlimited PTO


• Check out our Linkedin site and Careers page to learn more about what it’s like to be part of our #beoneteam!