Senior Data Engineer

Summary

Join 3Pillar Global as a Data Engineer and contribute to cutting-edge data analytics projects that provide clients with a competitive advantage. You will work with a scrum team, interact with stakeholders, and provide knowledge transfer. This role requires experience with AWS, Python, Typescript, data modeling, and database technologies. 3Pillar offers a flexible work environment, global team collaboration, and various benefits including medical, life insurance, paid time off, parental leave, and professional development opportunities.

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

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)

Preferred Qualifications

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

Benefits

• Medical Insurance benefits as per company policy
• Life Insurance as per company policy
• 12 days of paid vacation, sick leave and paid holidays as per local law
• Paternity and maternity leave as per as per local law
• Marriage, bereavement and graduation leaves as per company policy
• Sick leave and paid holidays as per local law
• Christmas bonus as per local law
• Saving Fund “Asociacion Solidarista”
• Beach house (Managed by the Asociacion Solidarista)
• Discounts in local shops
• Direct deposit of payroll
• Paid professional certifications
• 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
• 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