Data Engineer
Job Description
Design and deliver governed analytics capabilities for regulated financial institutions, with a focus on a semantic layer and production Power BI reporting.
Responsibilities
- Design and deliver a semantic layer and Power BI reporting capability for governed data platform engagements.
- Own the semantic model for the analytical tier, including configuring Power BI connectivity and workspaces.
- Deliver the agreed set of reports business users depend on.
- Contribute engineering capacity to client-owned data engineering and ETL work alongside client teams.
- Author and execute test cases that validate your work.
- Design and implement the semantic layer over client Athena analytical tiers, structured to support required reporting patterns.
- Configure Power BI connectivity to the semantic layer, validate end-to-end query patterns, and set up user workspaces in the client Power BI environment.
- Deliver use case reports as production-quality Power BI deliverables, validated with the client business partner during delivery.
- Refine visualization requirements with client business stakeholders within the agreed report scope, avoiding scope drift into custom UI work.
- Co-develop client-owned data engineering and ETL contributions alongside the client technical lead (data ingestion, transformation, gap handling) without taking outcome ownership the client retains.
- Author test specifications for the semantic layer, Power BI reports, and ETL contributions; maintain automated tests that run in the client deployment pipeline.
- Investigate and remediate defects on your components.
- Participate as an embedded team member in daily standups, sprint planning, and joint reviews with client technical leads, data analysts, and business partners.
Requirements
- Have designed and shipped semantic layers over analytical tiers (Athena, BigQuery, Snowflake, or comparable) for production downstream consumer use.
- Hands-on Power BI experience at report-build depth: DAX, connectivity to cloud analytical stores, workspace configuration, and Row Level Security patterns.
- Have shipped Power BI reports that business users actually use.
- Know dimensional modeling and apply it pragmatically (including when to normalize or denormalize) to keep the semantic layer usable in practice.
- Comfortable in the AWS data stack: S3, Athena, Iceberg (or comparable formats), Aurora PostgreSQL, and able to trace query execution across the stack when performance issues arise.
- Treat testing as part of engineering craft, including test cases for data pipelines and semantic models; distinguish unit tests, integration tests, and data quality checks.
- Have contributed to ETL and data engineering as a co-developer, returning clean handoffs without treating ownership as a status question.
- Can walk a business partner through a report and iterate in the same session without requiring a dedicated UX designer for basic layout and interaction decisions.
- Comfortable working inside a client team and delivering ownership outcomes within the team cadence.
Technologies
- Power BI
- DAX
- Athena
- BigQuery
- Snowflake
- AWS
- S3
- Iceberg
- Aurora PostgreSQL
- Row Level Security
Benefits
- Competitive Salary
- Purposeful Work with autonomy, resources, and time to focus on what matters
- Positive Environment with recognition and a flexible culture that supports diversity and inclusivity
- Growth & Development through mentorship, training, and development programs
- Transparency & Trust with clear direction, purpose, mission, and expectations
- Exclusive Perks including discounts on shopping, the gym, insurance, and mobile phone plans; office smoothie bar and ample coffee
- Meaningful Benefits covering health, dental, vision, disability, and travel insurance
- Unforgettable Events such as team bonding, BBQs, office lunches (pizza), gala dinners, and other team activities
Location: Ontario, OR (onsite)
Similar Jobs
G