PROFESSIONAL RESPONSIBILITIES
Data modeling & Transformation
• Build and maintain dbt models across staging, intermediate, and mart layers following Kimball dimensional modeling best practices, and a governed semantic / metrics layer so core KPIs are defined once and are AI- and agent-ready
• Write and review SQL transformations to convert raw source data into clean, analytics-ready datasets that serve as a trusted source of truth
• Implement dbt tests, model documentation, and source freshness checks to ensure data quality and build confidence across the organization
• Collaborate with the data engineer on pipeline design, source data contracts, and overall data architecture decisions
Reporting & Analytics
• Design and publish Power BI reports and dashboards that empower stakeholders across the business to access and interpret data with confidence
• Define and govern metric definitions to ensure consistent, reliable reporting across departments
• Partner closely with our business analyst to understand reporting needs and translate them into scalable, reusable solutions
• Identify opportunities to consolidate legacy reports and improve self-service analytics capabilities
• Excited to work alongside AI tools - not just using them, but improving their outputs by rigorously reviewing, refining, and iterating on AI-generated code and analyses
Governance & Collaboration
• Contribute to data governance practices including access review, data lineage, and documentation standards
• Serve as a bridge between the data infrastructure and the business, communicating technical concepts clearly to non-technical stakeholders
• Maintain and improve CI/CD workflows for dbt model deployments