Responsibilities

• Building Data Models: Create complex dbt models, custom macros, and reusable packages. Optimize transformations and implement robust testing strategies to ensure data integrity and model performance.
• Ownership: Monitor and maintain dbt workflow jobs, ensuring smooth data refreshes and up-to-date pipelines. Responsible for data models for BI analytics and company-level reporting.
• Ensuring Data Accuracy: Write tests and assertions to validate data integrity and consistency across models.
• Documenting and Standardizing: Create and maintain thorough documentation of dbt processes to ensure best practices within the BI team.
• Translating Complex Data Concepts: Act as a key communicator, translating technical data issues into understandable business terms for stakeholders.
• Mentoring Team Members: Support junior analysts and data engineers, especially in setting up experimentation platforms and data best practices.
• Collaborating Across Teams: Work closely with the product, engineering, and BI teams to ensure data infrastructure supports evolving business needs.

Qualifications

• Expertise in dbt & SQL: Deep experience with dbt and SQL to design, build, and maintain scalable data models.
• Cloud Technology Knowledge: Strong familiarity with cloud platforms like AWS, GCP, etc.
• Data Accuracy Focus: Passion for ensuring high data quality through tests/assertions and robust documentation.
• Commercial Acumen: Ability to understand business needs and communicate effectively with non-technical stakeholders.
• Mentorship Ability: Advocate for best practices in logging and data modeling that supports robust and effective analysis, reporting, and experimentation.
• Collaboration: Skilled at working cross-functionally and translating complex technical concepts into actionable insights for the business.
• Process-Driven: Proficiency in designing repeatable and scalable workflows for data transformation.

Benefits

• Competitive salary
• Benefits
• Remote working opportunities
• Impactful, mission-driven culture

Working for Prolific will place you at the forefront of AI innovation, providing access to our unique human data platform and opportunities for groundbreaking research. Join us to enjoy a competitive salary, benefits, and remote working within our impactful, mission-driven culture.