Data Engineer III/IV

OUR STORY

Let's be honest: there are lots of people out there doing what we do. We're just not convinced they're doing it right. Businesses are hungry for innovation and opportunity, but not at the cost of their independence. At Ollion, we've connected companies and capabilities around the world to help ambitious organizations make the most of their transformation and leave the status quo in the dust.

WORKING AT OLLION

Innovation is risky. It demands bold steps and big questions, but that's the price of making change. We've got our head in the cloud and two feet on the ground, channeling tech's endless potential towards a single goal: making a world of difference. And we're building a global team to do just that— a team capable of making game-changing breakthroughs without ever losing sight of the people it will impact. This is more than consulting. This is the change you can be.

THE OLLION DIFFERENCE

At Ollion, we're all in on your independence. Our teams are seasoned. Our solutions are straightforward—sometimes even groundbreaking. And our engagements? Exactly as long as you want them to be. We deliver fresh thinking and hard-earned insight in a way that works for you and your customers, arming your organization with everything you need to make your transformation truly mean something.

WORKING WITH OLLION (our clients' experiences)

Progress matters more than process. Our global team of cloud-native pros is all about creating new and better ways to work—not just by solving your tech challenges, but by using technology to solve your business challenges. We keep the formulas, frameworks, and ten-point plans to a minimum, tackling your most pressing problems with a proprietary mix of good-old-fashioned ingenuity and refreshing humanity.

DIVERSITY AT OLLION 

One of our cultural keystones, 'Find the angle' recognizes that every individual has different aspirations, needs and brings a unique perspective. 

We value diversity, inclusion, and equity (DE&I) as core to our success. We believe that a diverse workforce brings together unique perspectives, experiences, and ideas, leading to innovation, creativity, and better outcomes for our clients and our organization. We are on a journey and are committed to building a workplace that celebrates and respects individuals from all backgrounds, including but not limited to race, ethnicity, gender, sexual orientation, age, disability, and cultural heritage.  

As our commitment to diversity and inclusion is reflected in our: 

• Awareness and sensitisation programs: to create awareness and sensitisation. We encourage open dialogue, active listening, and mutual respect, creating a safe and supportive environment for everyone to contribute their unique perspectives and ideas. 
• Dedicated efforts to building diverse teams: that leverage the strength of our differences to tackle complex challenges and drive innovation. By embracing diversity, we broaden our collective knowledge, enhance problem-solving capabilities, and unlock limitless potential for our employees.

The Data Engineer will be responsible for requirements understanding, solution designing, and building modern  data platforms to support data-driven decision-making. The Data Engineer will execute technical implementation of data engineering and visualization projects, and will be a hands-on role. The Data Engineer will help in creating technical collateral and staying on top of technology trends with ongoing training and certifications.

​AWS Data Engineering:

• Develop and maintain scalable ETL/ELT pipelines using AWS Glue, Lambda, Step Functions, and Athena.
• Work with Amazon S3, Redshift, and Lake Formation to implement data lakes and warehouses.
• Monitor and optimize pipeline performance and cost efficiency.

Data Warehousing & Modeling:

• Build and support star/snowflake schemas, fact and dimension tables in Redshift or SQL Server.
• Ensure data integrity, lineage, and consistency across various source systems.

Data Quality & Validation:

• Implement automated data quality checks using custom logic or tools such as Deequ or Great Expectations.
• Perform root cause analysis and resolve data-related issues during development and testing phases.

Collaboration & Support:

•  Work with data analysts, business users, and architects to translate requirements into technical specs.
• Support UAT, deployment, and production issue resolution for ETL pipelines and reports.
• P erform root cause analysis and resolve data-related issues during development and testing phases.

• 4+ years of experience in dealing with data i.e. Data Engineer or related role.
• Proven track record of designing, building, and maintaining data pipelines and infrastructure.
• Expertise in programming languages i.e. Python, Scala or Java.
• Expertise in SQL.
• Expertise in data catalog and governance tools e.g.  Glue catalog, etc.
• Familiarity with data validation framework(s) 
• Strong understanding of Data warehouse, Data lake, Data mart, OLTP and OLAP concepts.
• Experience in data modeling, ETL/ELT processes, and data quality principles.

Nice to Have

• Architecting and implementing data platforms end-to-end.
• Experience with a data system like SSIS.
• Familiarity with the data visualization tool Qlik Sense

BENEFITS & PERKS FOR WORKING AT OLLION

Our employees multiply their potential because they have opportunities to: Create a lasting Impact, Learn and Grow professionally & personally, Experience great Culture, and Be your Whole Self

Beyond an amazing, collaborative work environment, great people, and inspiring, innovative work, we have some great benefits and perks:

• Benchmarked, competitive, in-market total rewards package including (but not limited to): base salary & short-term incentive for all employees
• We are a virtual-by-default, small but Global organization; 'learn wherever, whenever' frees our people from a rigid view of learning and growth
• Retirement planning (i.e. CPF, EPF, company-matched 401(k))
• Globally, we build benefit plans that offer choices for whatever stage in life our employees are in and allow for flexibility as life happens.  Employees have access to a fully comprehensive benefits package to choose the medical, dental, and vision insurance plan that best fits their lives. In addition to great healthcare coverage, we also offer all employees mental health resources and additional wellness programs.
• Generous time off and leave allowances
• And more

Ollion is an equal opportunity employer. We celebrate diversity and we are committed to creating an inclusive environment for all employees. Ollion does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, parental status, military service, or other non-merit factor.