Requirements Contract Details Expected Start Date June 2024 Expected End Date December 2024 On-Site Requirement Remote Security Clearance Level Requirements : This work will require Reliability statusDescription of ServiceThe marketing department has a need for a data analyst to support the migration of 3rd party data (company and individual level data) and other internal data sources into the Enterprise data platform (data lake) to be leveraged for various marketing analysis.
Primary ResponsibilitiesWorking closely with the customer analytics team in marketing, the data analyst would be responsible for analysis of external and internal data sources and mapping to data in the Enterprise Data Platform (EDP).
The individual will work closely with marketing analysts, as well as other data roles, such as data architects and data engineers to deep dive into the business rules and data transformation rules requirements, as well as analyze and document new requirements and to be able to help the design of the new data integration stream or update the existing data pipeline.
Specific Project Requirements
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Demonstrated experience in SQL programming is required.
- Strong knowledge and demonstrated experience in current and future state data mapping.
- Identify qualified / approved records for system upload.
- Identify and resolve discrepancies (format, content, values).
- Work with business team members on resolving quality issues.
SkillsTop Skills Required :
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains : dimensional and relational data modeling, data quality, SQL programming (minimum 5 years), ETL development, metadata management and master data management, business intelligence and database administration.
- Experience with reverse engineering the source to target mapping to gain data insights
- Experience refactoring existing SQL code to new / alternate data sources.
Other Skills Required :
- Experience with Azure Data Platform technologies or other public cloud offerings
- Experience with Databricks
- Programming experience : SQL, R, Python
- Understanding of Denodo platform
- Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.
- Ability to understand and interpret requirements and design documents
- Ability to write and maintain documentation
Assets :
- Experience working in an Agile environment / team
- Bilingualism in both official languages (English and French)
- Greater than 5 years of SQL development and refactoring existing SQL
Job 70307
Data Analyst
This work will require Reliability statusDescription of ServiceThe marketing department has a need for a data analyst to support the migration of 3rd party data (company and individual level data) and other internal data sources into the Enterprise data platform (data lake) to be leveraged for vario...
Catalog Analyst Data Solutions · Multiple locations
Implements data standards by using our in-house tools and Excel to extract, synthesize, and validate data from different sources and transform data into usable metrics. The Catalog Analyst position reports to the Group Manager of the Data Management Services Department of JNPSoft. The Catalog Analys...
Staff Data Analyst, Growth
GTM Analytics is situated within the broader Data Science organization at Stripe, which is home to a diverse team of data analysts and scientists, product managers, and engineers that span their focus across sales, marketing, and product-led growth. You will partner closely with cross-functional Gro...
Data Analyst In Canada
Providing technical expertise in data storage structures, data mining, and data cleansing. Provide quality assurance of imported data, working with quality assurance analysts if necessary. Managing and designing the reporting environment, including data sources, security, and metadata. Managing mast...
Senior Campaign Data Analyst
We are looking for a talented individual to join our team in the position of Senior Campaign Data Analyst, Campaign Analytics & Execution. Demonstrated proficiency in working with large varied datasets, both structured and unstructured data, using SAS. A strong passion for data, charts, analysis, tr...
Air optimization data analyst
Liaise with data development and business teams such as Revenue Management teams to enhance the understanding and use of data and analytics capabilities. Experienced in Insight/Data/MI Analyst. The position of Marketplace Optimization Analyst sits within the Air and Ground Transportation Team and is...
Online Data Analyst - Canada
A Day in the Life of an Online Data Analyst:. Completing research and evaluation tasks in a web-based environment such as verifying and comparing data, and determining the relevance and accuracy of information. ...
Data Analyst
Business Intelligence Engineering, Data Engineering, Data Analysis or Data Science roles, building data pipelines and analyzing large datasets to solve problems. Data Science at Stripe is a vibrant community where data analysts, data scientists and engineers learn and grow together. You will work wi...
Data & Analytics - Senior Data Analyst, Digital
As a Senior Data Analyst, Digital at Aritzia, you will combine your deep understanding of digital customer experiences with your passion for data and masterful analytics skills to drive decisions that will create long lasting relationships with our customers and enhance outcomes for our eCommerce bu...
Senior Game Data Analyst
As a Senior Game Data Analyst, you will be working in our cross-disciplinary team to help game studios use data efficiently to improve games. We provide end-to-end analytics services for PlayStation Studios and use data to help them make their amazing games even better. Analysing data to deliver hig...