Senior Data Architect

Company Description

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.

Job Description

•  
• Take the initiative and ownership of projects and clients
• Understand and document the business requirements of our clients
• Propose technology stacks and solutions that meet client needs
• Design and architect to appropriately safeguard data security, data integrity and data privacy
• Build schemas and data transformations that are optimized for the client’s use cases and query patterns
• Write queries and tests to establish performance metrics and profile outputs for the client’s use cases and query patterns
• Guide and mentor other team members with matters related to both business and technical requirements, as well as create and publish best practices, methodologies and guidelines
• Understand and account for tradeoffs in performance, usability, accuracy, integrity of data
• Deliver clear, well-communicated and complete design documents
• Defend and convince clients of the validity and merits of our solutions
•  

Qualifications

•  
• Excellent communication skills (written and spoken)
• Multidisciplinary skills with an engineering background, ideally in data management systems
• Defining system-level architecture and conducting dimensional modeling
• Designing performant data warehouse schemas, e.g., star and snowflake schemas, with a deep understanding of the tradeoffs related to normalization/denormalization 
• Defining data security protocols and enabling access controls, ensuring data integrity across multiple data marts 
• Defining ETL jobs using distributed/parallel architectures for low latency and highly scalable systems
• Solid experience with any major RDBMS: Postgres, MySQL, SQL Server, Oracle etc.
• Experience architecting analytics platforms using any major “Big Data” ecosystem (Snowflake, Hadoop, Google, etc.)
• Experience with any of the major public clouds (Google/Amazon/Microsoft) 
• Experience with at least one major data visualization/BI platform such as Tableau, Power BI, AWS Quicksight, etc.
•  

Additional Information

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
• Fully remote-first, 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! #LI-Remote

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.