SQL Data Architect
W3Global
Date: 7 hours 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
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
- 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.
- 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