5-8 years of data engineering experience on analytical data platforms.
Strong SQL skills including joins, window functions, and optimization.
Hands-on experience with dbt for models, tests, and documentation.
Proficient in Snowflake, focusing on performance tuning and data modeling.
Experience in refactoring and migrating complex analytical logic.
Ability to analyze and validate ad hoc SQL and spreadsheet calculations.
Strong understanding of data quality and testing controls.
Excellent communication skills for stakeholder collaboration.
Responsibilities
Collaborate with pricing analysts to clarify and document business logic.
Reverse-engineer SQL and spreadsheet logic to define business behavior.
Re-implement pricing definitions as reusable dbt models in the Silver layer.
Ensure compliance with data modeling and version control standards.
Validate migrated data against existing outputs and resolve discrepancies.
Document business rules and data lineage in dbt and Confluence.
Decommission outdated Gold-layer logic after successful migration.
Benefits
Flexible work environment with remote options.
Opportunities for professional development and training.
Collaborative team culture with a focus on innovation.
Access to cutting-edge tools and technologies.
Health and wellness programs.
Full Job Description
Data Engineer Job requirements
Key Responsibilities Logic Discovery and Requirements Analysis
Work with pricing analysts to identify custom definitions, calculations, transformations, dependencies, assumptions, edge cases, and ambiguities currently implemented in the Gold layer.
Reverse-engineer analyst-written SQL, spreadsheet logic, and ad hoc calculations to define intended business behaviour.
Translate legacy logic into clear technical requirements and migration plans.
Migration to the Silver Layer
Re-implement approved pricing definitions as governed, reusable, documented dbt models in the Silver layer.
Follow data modelling, naming, testing, version control, and code review standards.
Build maintainable, scalable, auditable models independent of undocumented analyst knowledge.
Apply dbt tests for uniqueness, not-null, accepted values, relationships, and business rules.
Parity Validation and Quality Assurance
Compare migrated Silver-layer results with existing Gold-layer outputs and resolve differences.
Validate results across representative periods, segments, boundary conditions, and known exceptions.
Confirm migrations only after parity review and pricing analyst approval.
Analyst Collaboration and Sign-Off
Partner with pricing analysts to clarify calculations, confirm intended behaviour, and align on expected results.
Lead walkthroughs and reviews; document analyst approval before retiring legacy definitions.
Communicate risks, open questions, dependencies, and decisions to technical and business stakeholders.
Documentation and Lineage
Document business meaning, calculation rules, assumptions, exceptions, source inputs, ownership, lineage, tests, and downstream consumers in dbt and Confluence.
Ensure documentation enables future engineers and analysts to maintain logic without relying on the original analyst.
Gold-Layer Cleanup and Cutover
Decommission ad hoc Gold-layer logic after the Silver replacement is validated, approved, adopted, and downstream dependencies are updated.
Verify retired logic is no longer used and operational documentation reflects the new source of truth.
Required Qualifications
5-8 years of data engineering experience on analytical data platforms.
Hands-on dbt experience across models, tests, documentation, and lineage.
Strong Snowflake experience, including modelling, performance tuning, and warehouse concepts.
Experience refactoring, migrating, or modernising complex analytical logic.
Ability to untangle ad hoc SQL and spreadsheet calculations and validate outputs.
Strong understanding of data quality, reconciliation, testing, and release controls.
Skilled at working with non-engineering stakeholders to clarify requirements and validate outcomes.
Excellent communication and documentation habits.
Core Skills and Tools
SQL; Python a plus
Snowflake
dbt, dbt Cloud
Airflow
Confluence, Jira, Slack
Data modelling, quality validation, reconciliation, migration planning, stakeholder collaboration, and technical documentation.
About Brillio
Brillio is a technology consulting and technology services company focused on the implementation of digital technologies.
Brillio Careers
There has never been a more opportune time to join Brillio—the forefront of innovation and digital transformation.
Opportunities Await
Brillio offers a plethora of job opportunities aimed at harnessing the potential of professionals eager to drive change. With a focus on technology and consulting, Brillio is not just a company; it's a vibrant ecosystem conducive to growth and professional development.
Transform Your Career
Embark on a journey of growth and leadership at Brillio. This is where industry expertise meets digital innovation to transform businesses and industries. Brillio stands out in the marketplace, providing a unique blend of technology solutions and strategic insights.
Join a Diverse and Inclusive Team
Brillio is committed to diversity and inclusion, ensuring a wide range of perspectives that fuel innovation and creative solutions. The team at Brillio, enriched with diverse skills and backgrounds, collaborates to deliver excellence and drive success.
Internship Programs and Employment
Kickstart your career with Brillio's internship programs, designed to offer hands-on experience and a gateway to full-time employment. Brillio is dedicated to nurturing young talent, providing them with the necessary tools and guidance to excel.
Innovate and Lead
At Brillio, every team member is an innovator and leader. The company fosters a culture of continuous learning and improvement, encouraging each individual to push boundaries and contribute to groundbreaking projects.
Networking and Professional Development
Networking at Brillio opens doors to influential connections, mentorship, and collaborative opportunities. Brillio supports career advancement through professional development, offering training in leadership, diversity, and specific job skills.
Benefits and Culture
Brillio is known for its dynamic culture and the comprehensive benefits it offers. Team members enjoy a supportive environment that values their well-being and professional growth.
Explore Job Positions
Brillio is hiring! Explore the various positions available that match your skills and interests. Brillio seeks passionate, curious, and solution-driven professionals ready to make an impact.
Prepare for Your Interview
Brillio helps candidates succeed by providing resources on how to effectively prepare your resume and ace the interview process. Stand out as a prospective employee by demonstrating your knowledge and enthusiasm for Brillio's mission.
Stay Connected with Brillio Careers
Keep up to date with career tips, industry insights, and the latest job openings at Brillio. Personalize your job search and stay informed about new and exciting opportunities within the company.
APPLY TO BRILLIO JOBS
Read Careers Blog
Stay ahead in your career with insights from Brillio's experts. Discover articles and advice tailored to advancing your career and enhancing your professional journey.
Job Alert Emails
Subscribe to receive customized job alerts and the latest news from Brillio. Discover the rewarding career opportunities that await and how Brillio can be the key to your professional future.
