Sr Data Architect - Apex Systems

Job#: 2035801

Job Description:

Sr Data Architect
Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years' experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet Management company.
Client: Enterprise Fleet Management Company
Terms: Permanent
Location: 3 days hybrid, Mississauga, ON
Application Process: It is best to apply via the medium on which you are seeing this posting
If you encounter technical difficulties submitting your resume, please send a Word version of your resume to Cole Edwards at
Please reference Data Architect
Responsibilities:

• Perform Data Architecture support for projects and enhancements.
• Craft and execute data management, architecture, integration, and governance strategies
• Provide technical leadership for architecture, design, documentation, and maintenance of databases and related systems; creates database storage structures, resolves database issues, and maintains 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
• Review and approval of daily operational changes where required
• Monitor daily operations of data loads and identify data discrepancies, data quality issues, and work to ensure data consistency and integrity
• Participate in project and enhancement estimation exercises and project team meetings
• Provide required input, status on tasks, identification of risks and corresponding mitigations as well as issue management
• Collaborate with business partners to transform business requirements into environment specific ETL, reporting, and data validation designs; work closely with management to prioritize business and information needs
• Design relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security
• Collaborate with internal and external personnel, including system architects, software developers, database administrators, design analysts and information modeling experts to determine project requirements and capabilities, and strategize development and implementation timelines
• Review changes to databases to ensure no performance or functionality impacts
• Develop architectural strategies for data modeling, design, and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
• Collaborate with the Application Development team to analyze, identify, design, and implement processes for sourcing new data
• Generate DDL scripts from data modelling tool and to ensure the script's proper function
• Create and test physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
• Support database administrators, network designers and IT personnel to create effective and secure methods for data safeguarding
• Review existing data architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing underperforming areas and present these plans to managers and executives
• Research new technologies, data modeling methods and information management systems to determine which ones should be incorporated into company data architectures, and develop implementation timelines and milestones

Key Qualifications:

• 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
• Proficient in the use of data modeling tools, and producing/maintaining logical and physical designs
• Strong ETL development knowledge (SSIS, ADF (Azure Data Factory), Boomi or equivalent) and data warehouse architecture techniques
• Team experience, including working closely with business professionals as well as technical resources and acting as a bridge between the two groups including liaison with vendors
• Experience in optimizing, loading, and processing large datasets from different data sources and formats
• Demonstrates careful attention to quality and accuracy of data and ETL processes
• Creative problem-solver with strong communication skills
• Collect business requirements and develop as well as document data models to satisfy those requirements
• Adept at query development, report writing, and presenting findings

Nice to Have:

• Familiar with fundamental Data Governance and security concepts and processes
• Experience in the Fleet Management business is preferred
• PostgreSQL/Snowpro (for Snowflake) certifications preferred

Interview Process: We are working directly with the hiring manager on this position
Interviews will take place the week of 04/29.
This a great opportunity to join a large enterprise insurance firm, who has been recognized as a top employer and join a value led organization where you can bring your passion and ambition to the forefront.

EEO Employer
Apex is an Equal Employment Opportunity/Affirmative Action Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law
Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

EEO Employer

Apex Systems is an equal opportunity employer
We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law
Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe
When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning
We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package
Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.