Senior Data Architect
Element Fleet View all jobs
- Mississauga, ON
- $99,200-136,400 per year
- Permanent
- Full-time
- Perform Data Architecture support for projects and enhancements, including crafting and executing data management, architecture, integration, and governance strategies.
- Provide technical leadership for architecture, design, documentation, and maintenance of databases and related systems, including creating database storage structures, resolving database issues, and maintaining system security.
- Support development and implementation of business applications that optimize statistical efficiency and data quality.
- Identify, analyze, and interpret trends or patterns in complex data sets.
- Monitor daily operations of data loads, identify data discrepancies and data quality issues, and ensure data consistency and integrity.
- Participate in project and enhancement estimation exercises and project team meetings, providing input, task status, risk identification, mitigation strategies, and issue management.
- Collaborate with business partners to transform business requirements into environment-specific ETL, reporting, and data validation designs, and prioritize business and information needs.
- Design relational databases and physical data models to support enterprise applications, data acquisition, and security requirements.
- Review database changes to ensure no performance or functionality impacts and ensure production stability.
- Bachelor’s degree in data architecture, information management or similar field.
- At least five years of DBA/data development and data architecture experience (combined).
- Proficient with PostgreSQL, Talend ETL, and Snowflake.
- Strong ETL development knowledge including SSIS, ADF (Azure Data Factory), Boomi or equivalent, and data warehouse architecture techniques.
- Proficient in the use of data modeling tools and producing and maintaining logical and physical designs.
- Demonstrated ability to optimize, load, and process large datasets from different data sources and formats while ensuring data quality and accuracy.
- PostgreSQL/Snowpro (for Snowflake) certifications preferred.
- Experience working closely with business professionals and technical resources, acting as a bridge between the two groups and liaising with vendors.
- Familiarity with fundamental Data Governance and security concepts and processes.
- Experience in the Fleet Management business is preferred.
- Strong communication skills with the ability to collect business requirements, develop and document data models, and present findings.
- A culture of innovation, empowerment, decision-making, and accountability
- Comprehensive health and welfare benefits that serve the needs of you and your family and foster a culture of wellness (for qualified roles)
- Additional benefits and amenities, including paid time-off programs (vacation, sick leave, and holidays) (for qualified roles)