Senior Cloud Data Solutions Architect to design and implement complex large scale Data Warehouse, Data Lake, and Lakehouse and supporting Data Migration and Conversion initiatives

S.i. Systems
Toronto
$60K a year (estimated)
Full-time

Start Date (Estimate) : June 1,

Term : 7 months (December 31st End Date)

Extension option(s) : 24 months

MUST HAVE :

  • University degree in applied sciences such as Computer Sciences, Systems Design, Engineering, Business or a combination of education, training, and experience deemed equivalent
  • 6+ years of solution architecture / solution design experience, ideally with experience in large enterprise environments, including hands on experience with data platforms and cloud infrastructure including Azure Kubernetes , Azure Redhat Open Shift , Azure, SAS Enterprise Guide, IBM InfoSphere, Cloud Pak, SAS Enterprise Guide, SAS Viya, and Oracle, AWS S3 OCI Exadata
  • 4+ years of solution architecture / solution design experience in a modern data lake / warehouse environment with knowledge of data / business vault, star schema, snowflake, and lakehouse methodologies, operating in the Azure ADLS Gen 2, Azure Data Factory, Databricks, Synapse, Snowflake , etc.

or similar environments, and with familiarity with SCD Types and usage

Excellent knowledge of RDMBS and SQL Oracle and SQL Server relational databases, and experienced in the use of XML, Web Services, and Enterprise Service Bus (ESB) technologies for application and systems interoperability including sftp / mft, and event driven architectures

NICE TO HAVE :

  • Experience in the Insurance industry including the Accord reference model is a plus background accord models
  • Experience in ERP implementations including PeopleSoft and Oracle Fusion, and / or Guidewire
  • Experience with hyper scaler infrastructure design and integration including Azure, Oracle OCI, and AWS
  • Experience with modern identity management and integrations services, persona / rbac design
  • Resource Responsibilities
  • Work closely and collaboratively with Business, Data, and IT specific groups as well as external partners to understand business requirements, develop, document, and review the conceptual, logical, and physical solution architectures required for the ERP Modernization project
  • Undertake the design of technology solutions based on WSIBS’s specifications, standards, policies, and best practices and cost models as in where and when available, in order to meet business requirements and project deliverables, and provide input / influence the adoption of standards where appropriate
  • Identify architecture risks and analyses of potential impact on the enterprise and on the achievement of scheduled objectives.
  • Design, build, and test cloud architecture to ensure large amounts of data can be transferred and stored efficiently.
  • Provide technical oversight through design, development, and implementation cycle including hands on support through all phases including with troubleshooting and project delivery
  • 14 days ago
Related jobs
Scotiabank
Toronto, Ontario

Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capit...

S.i. Systems
Toronto, Ontario

Holds Scaled Agile Framework (SAFe) training and certification like SAFe Practitioner, or commitment to take the course and obtain certification within 2 months from commencement of work. This position fully participates in activities that support the team’s delivery and continuous improvement throu...

Diabetes Canada
Toronto, Ontario

Leads the monthly review and analysis of results, including but not limited to: supporting business units in the understanding of the booked transactions, assisting with the development of accurate accruals and adjustments, developing clear explanations for variances from budgets/forecasts and worki...

Ryan
Mississauga, Ontario

The Senior Manager, Sales Tax Recovery (“Senior Manager”) works either independently or with other Managers/ Directors to identify sales and fuels tax savings opportunities for clients. Professional accounting designation (CPA, CA, CMA, CGA) and four to six years accounting or tax-related experience...

TELUS
Toronto, Ontario

In this role, you will lead the onboarding and managing of new Intelligent Mobility IoT solutions and partners to further expand and strengthen our market capabilities and competitive positioning. You will be part of a team of product and market managers working closely with sales, sales support, va...

Big Viking Games
CA
Remote

Design and implement data models and database schemas to support data storage and retrieval. As a Senior Data Engineer, you will be responsible for designing, implementing, and maintaining data pipelines that process and analyze large volumes of data. Design, implement, and maintain data pipelines t...

Bell
Mississauga, Ontario

As a representative of Bell Business Markets (BBM) in the role of Senior Business Analyst, the successful candidate will participate in various types of projects (transformation, new product/tool Introduction, tool and/or process enhancements, governance, non-standard complex solutions etc. Our Bell...

Amazon
Toronto, Ontario

AWS has the most services and more features within those services, than any other cloud provider-from infrastructure technologies like compute, storage, and databases-to emerging technologies, such as machine learning and artificial intelligence, data lakes and analytics, and Internet of Things. If ...

Mackenzie Investments
Toronto, Ontario

As an intermediate between leadership and our broader Project Management team, you will be a subject matter expert by implementing best practices with respect to program or portfolio financials and will work directly with our extended team members (Finance and EPMO) to ensure timely project updates ...

EY
Toronto, Ontario

Our Total Rewards package includes a comprehensive medical, prescription drug and dental coverage, a defined contribution pension plan, a great vacation policy plus firm paid days that allow you to enjoy longer long weekends throughout the year, statutory holidays and paid personal days (based on pr...