Job Description
Ovii's Interpretation of the Role
Senior Data Architect leading end‑to‑end design, delivery, and optimization of enterprise data‑warehouse and business‑intelligence platforms in a remote, full‑time role.
Role Snapshot
- Enterprise Data Warehouse design
- Full‑lifecycle delivery ownership
- Scalable dimensional modeling
- Cloud analytics platform implementation
- Team mentorship and stakeholder partnership
Must-Have Requirements
- Data warehousing & dimensional modeling
- AWS Glue / Amazon Redshift
- Microsoft SQL Server & advanced SQL
- ETL/ELT pipeline design
- End‑to‑end delivery ownership
- Enterprise data warehouse design
- Business intelligence solution delivery
Nice-to-Have Signals
- SSIS / DataStage / Informatica
- Tableau / PowerBI
- FinTech domain experience
- Java / .Net / C# / Python
- FinTech vertical experience
- Cloud analytics deployment
Work Setup
- Location: Canada, Canada
- Work mode: REMOTE
- Remote scope: COUNTRY_RESTRICTED
- Remote countries: Canada
- Employment type: Full-Time
Eligibility Gates
- Visa sponsorship: unknown
Not Specified in JD
- Salary range
- Visa sponsorship
- Security clearance
- Travel requirement
- Shift requirement
- Notice period
- Coding test
- Portfolio
- GitHub
- Writing sample
- Cover letter
What You'll Likely Work On
- Architect and design end‑to‑end EDW and BI solutions
- Create scalable dimensional models (star schemas, conformed dimensions)
- Own the full delivery lifecycle: requirements, design, build, deploy, adoption, and optimization
- Ensure performance, scalability, and reliability of analytics platforms
- Drive cloud deployment and production readiness of data solutions
- Translate business needs into robust ETL/ELT pipelines
- Implement data quality, validation, and monitoring frameworks
- Integrate high‑volume, multi‑source data (APIs, relational systems, SaaS, flat files, JSON/XML)
- Facilitate architecture sessions and act as trusted advisor to senior stakeholders
- Mentor BI developers, data engineers, and analysts while establishing governance standards
Good Fit If You Have
- Experience with SSIS, DataStage, or Informatica
- Hands‑on work with Tableau or PowerBI
- Background in FinTech or related verticals
- Application development experience in Java, .Net/C#, or Python
Skills
- Data warehousing & dimensional modeling
- AWS Glue & Amazon Redshift
- Microsoft SQL Server & advanced SQL
- ETL/ELT pipeline design & optimization
- Business intelligence tools (Tableau, PowerBI)
- Data integration from multi‑source feeds
- Data governance, security & stewardship
- Performance & scalability engineering
Remote Eligibility
- Canada