Senior Integration and Data Analyst to plan, coordinate, and supervise the integration of data across various sources

Our retail client in Winnipeg is looking for a Senior Integration and Data Analyst to plan, coordinate, and supervise the integration of data across various sources

Winnipeg, permanent,

Must Have

• 8+ years experience in Data Analytics with a strong background in data modeling and database design
• 3 years experience in Data Integration at an enterprise level, overseeing the linking of cross-functional databases between disparate business units and systems
• Experience with the Design and development of ETL processes.
• Direct, hands-on experience with automated DI tools (SSIS, Apache, or SnapLogic)
• Experience with Cloud platforms (prefered Azure), for data storage and management. Experience in structuring and storing data in the cloud.

Nice to Have

• Agile experience
• Retail experience

Responsibilities

• The Integration and Data Analyst role is to plan, coordinate, and supervise all activities related to the integration of data across various sources into an organized and unified view.
• Monitoring of data flow between databases, servers, and Cloud services
• Orchestrate data integration projects and corresponding strategies between business areas and the Applications team
• Plan, execute, and manage the strategic integration of new data and data stores into existing or new systems and infrastructure throughout the enterprise, including introduction of Cloud services as applicable.
• Produce ETL design guidelines to ensure a manageable ETL infrastructure
• Design and develop ETL processes
• Design data stores to ensure interoperability with reporting and BI platforms
• Be a source of innovative ideas for dashboard and report design and development
• Ensure that integration projects meet business requirements and goals, fulfil end-user requirements, and identify and resolve systems issues.
• Ensure that integration planning and practices are aligned with strategic business goals and the company’s overall strategic vision.
• Develop standards and processes to support and facilitate integration projects and initiatives.
• Revise DI architectures when required to be compatible with changing business needs and client standards so that all legal, compliance, and operational requirements, such as data sovereignty, regulatory security and privacy policies, and service level agreements (SLA), are accounted for.
• Maintain high standards of data quality through the introduction and enforcement of information handling processes and organization of the DI processes.
• Conduct research on emerging DI products, languages, and standards in support of procurement, development, security, and integration efforts in relation to the Cloud, BI, and big data management.
• Manage the selection, deployment, and maintenance of any DI tools (as-a-service (DIaaS) or DI On-premise) as deemed appropriate for the organization.
• Ensure the collection and coherent interpretation of the various business processes affected by integration efforts.
• Work diligently to enhance or improve business processes via integration, or, as necessary, minimize the impact of integration on those processes.
• Evaluate results of integration projects, then report and make recommendations based on findings.
• Fequently compare DI solutions with those available in the market to assess and monitor levels of service provided by current vendors.