Data Platform Engineer

As a Data Platform Engineer at OneTrust, your primary responsibilities will include collaborating with data engineers and architects to create scalable data solutions, administering and maintaining production systems like Snowflake and Power BI, and implementing automation frameworks on AWS. You'll also engage with stakeholders to understand platform requirements and improve data quality while reducing technical debt.

To apply for the Data Platform Engineer position at OneTrust, you should have a bachelor's or master's degree in computer science or engineering. Along with that, you need at least 7 years of overall experience, with a minimum of 5 years in large-scale data warehouse projects. Proficiency in SQL, Python programming, and experience with data warehouse and big data technologies are also essential for this role.

OneTrust is deeply committed to employee growth and offers various career development opportunities for Data Platform Engineers, including access to training programs, mentorship from experienced professionals, and company-paid privacy certification exam fees. The collaborative culture at OneTrust encourages continuous learning to help staff reach their career goals.

As a Data Platform Engineer at OneTrust, you will work with a modern technology stack that includes Snowflake, Fivetran, DBT, AWS Airflow, and various CI/CD tools. You will also utilize AWS native technologies for deploying applications and maintaining infrastructure, as well as other big data tools such as Apache Spark and Kafka.

You can expect a flexible and inclusive work culture at OneTrust as a Data Platform Engineer. The company fosters collaborative efforts through team gatherings and in-person events, emphasizing the importance of building connections and celebrating achievements. The environment encourages open communication and innovation while valuing the well-being of every employee.

When answering this question, highlight your hands-on experience with Snowflake, detailing specific projects where you utilized its features for ETL processes or data management. Discuss how you optimized queries or improved performance, showcasing your understanding of the technology's capabilities.

Describe your methodology in developing scalable data solutions, focusing on best practices like targeted dimensional modeling, performance tuning, and effective data security strategies. Mention any relevant tools and frameworks you've employed, particularly mentioning AWS technologies if applicable.

Explain your strategies for managing technical debt, such as identifying root causes and prioritizing resolution activities. Give examples of any previous experiences where you successfully reduced technical debt and how it contributed to better system performance and maintainability.

Discuss your role in implementing Continuous Integration and Continuous Deployment (CI/CD) solutions, mentioning tools you’ve used and the processes you've developed to ensure seamless integration and delivery of data products. Highlight specific achievements that showcase how CI/CD improved project timelines.

Share your experiences working with cross-functional teams and how you ensure effective communication and understanding of project requirements. Provide examples of successful collaborations where you drove technical discussions and contributed to a cohesive environment.

Explain the automation techniques you've employed in data management, detailing specific tasks that you automated and the tools used, particularly in cloud environments like AWS. Elaborate on the impact that automation had on efficiency and accuracy in your previous roles.

Begin by listing the programming languages you're proficient in, particularly highlighting Python. Provide examples of projects where you applied your programming skills to develop data pipelines or automate processes, discussing the results of your implementations.

Talk about the design principles you prioritize when creating data solutions, such as simplicity, scalability, and modularity. Mention how these principles guide your decision-making process and contribute to the overall success of the projects.

This is an opportunity to express your alignment with OneTrust's mission to handle data responsibly and your excitement about contributing to its innovative solutions. Share specific reasons related to the company's culture, values, and the potential for growth within the organization.

Provide a detailed account of a specific challenge in a data project, explaining the context, how you assessed the situation, the steps you took to resolve the issue, and the final outcome. This demonstrates your problem-solving skills and ability to work under pressure.