SQL Data Architect- (Hybrid)-20% onsite work -Montreal. Quebec - #440462

W3Global


Date: 6 days ago
City: Montreal, QC
Contract type: Contractor
SQL Data Architect

urgently in Montreal. (Quebec, Canada)

20% onsite work.

Ongoing assignment

SQL Developer/Data Architect

Job Description

  • Strong experience working with retail Point-of-Sale (POS) Transaction Log (TLOG) files and mapping data to be used by other retail related business applications

Responsibilities

  • Define and document data ETL procedures, standards, and metrics to support customer analytics business rules.
  • Establish data quality processes and compliance with data standards for data domains.
  • Troubleshoot issues with data quality as identified by stakeholders.
  • Perform activities to address data extraction, data validation, data cleansings, data harmonization, business logic, exception handling, and required data indication.
  • Design and build a data inventory including field definitions, ontologies, list of values (LOVs), and mappings as requested by the stakeholder and defined by requirements.
  • Understand critical data relationships and customer data domains.
  • Collaborate with business process owners, data producers, and data consumers to get an understanding of current processes and systems that has a direct impact on the quality of the enterprise data.
  • Work with business application engineers to define and maintain a customer data model and Analytics solutions.

Qualifications

  • Bachelor of Science degree and/or relevant work experience
  • 7+ years of prior experience as a data analyst or architect
  • Strong experience working with retail point-of-sale (POS) transaction log (TLOG) files and mapping data to be used by other retail related business applications
  • Data Architect deep understanding of ETL Tools, Best Practice Processes (Enterprise ETL Tools, Self-Service, Data Preparation)
  • Data Movement Tools (SSIS, Informatica, Talend, etc.)
  • Proficient in SQL (SQL, Stored Procedures, Dynamic SQL, Joins, Aggregation, etc.)
  • Experience with Data Structure Solutions (Big Data, RDBMS, NoSQL)
  • Experience with a couple of Database Systems (Oracle, SQL Server, My SQL, Postgres, etc.)
  • Skilled in one scripting language, such as R, Python, VBScript, Shell Script
  • Understanding of Data Governance, Data Integrity, Master Data Management, Data Quality
  • Design, Develop, and Deployment Best Practices
  • Experience structuring and analyzing large quantities of data and information for statistical and analytical modeling
  • Understanding of Business Intelligence Best Practices, Architectures, Tools, Methodologies, and Software
  • Good Strong oral, written communication and leadership skills
  • Proven ability to partner with client stakeholders from various parts of an organization
  • Ability to handle multiple tasks and workstreams in a fast-paced environment
  • Experience with SDLC methodologies (Agile and Waterfall Development)
  • Experience with Data Modeling

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Social Media Coordinator

Bizzabo, Montreal, QC
1 week ago
Description About Us: Bizzabo powers immersive in-person, virtual, and hybrid experiences. The Bizzabo Event Experience OS is a data-rich open platform that allows Event Experience Leaders to manage events, engage audiences, activate communities, and deliver powerful business outcomes — while keeping attendee data private and secure. Bizzabo powers the events of world-leading brands — from Fortune 100 enterprise organizations and...

IT Support Specialist

Amilia, Montreal, QC
1 week ago
Amilia is transforming the recreation and activities market with its innovative, purpose-built SaaS platform. Designed for municipalities, community centers, nonprofits, businesses, and recreation organizations, Amilia SmartRec streamlines operations, optimizes facility management, and simplifies program and membership management. Since 2009, Amilia has been on a mission to revolutionize how communities connect and participate in activities. By combining cutting-edge technology with deep...

Technology Manager, Surety North America

Intact, Montreal, QC
1 week ago
Our employees are at the heart of everything we do. Together, we help people, businesses, and society prosper in good times and be resilient in bad times. Our employee promise represents Intact’s commitment to you in exchange for living our Values, striving to do your best work, being open to change and investing in your career. In return, we promise...