About the Role Design, build, and maintain dbt/SQL transformations and dimensional models that power self-serve analytics and AI—documented, tested, and built to last. You’ll own data quality, lineage, and CI/CD from the ground up, so when someone looks at a number, they trust it. Around 20% of your time you’ll work directly with stakeholders, turning business questions into metrics and feeding real-world insights back into the models. Day-to-day you’ll Build and maintain dbt models, tests, and documentation for dimensional warehouse schemas (star/snowflake). Develop and evolve a semantic layer/metrics definitions to enable consistent self-serve in BI and AI tools. Implement data quality checks, lineage, and documentation; monitor data freshness and model performance. Contribute to orchestration and CI/CD workflows (e.g., dbt Cloud/CI, scheduler) with git-based workflows. Partner with stakeholders for light analysis and dashboarding (~20%), translating questions into metrics and iterating on insights. Contribute to standards, conventions, and documentation to scale data development across teams. About You Strong SQL (CTEs, window functions) and hands‑on dbt experience across models, tests, and docs. Solid data modelling fundamentals — dimensional schemas, SCDs, and metrics/semantic layer literacy. Git-based workflows, code review habits, and CI/CD basics for data changes. A quality-first mindset: testing, lineage, ownership, and documentation that consumers can rely on. Comfort with at least one BI tool (Tableau, Power BI, Looker) and an eye for good dashboards. The ability to translate business questions into metrics and explain trade-offs without the jargon. Bonus: Python for data tasks, orchestration exposure, or monitoring/observability experience. What's in it for you A front-row seat to Australia’s energy transition. Brighte finances and electrifies homes at scale — solar, batteries, hot water, heating — and our enterprise partners are central to this. Hybrid working. 3 days in office, 2 from home. We love our Socials — lunches, drinks, snacks, table tennis, a properly stocked pantry, and the company of people you actually like. Employee Share Option Plan (ESOP). Share in Brighte's success. End-of-trip facilities for cyclists, including showers and towel service. Anniversary leave. An extra day off each year to mark your time with us. #J-18808-Ljbffr
Analytics Engineer
BRIGHTE CAPITAL PTY LTD
council of the city of sydney, council of the city of sydney
Published 4 days ago
Report job
Similar jobs
Part Time Work From Home Focus Group Panelist. Call Centre Agent Experience Not Required
APEX FOCUS GROUP LLC
Permanent