Data Designer

• Role: Data Designer
• Location: Montreal, QC
• Fulltime and Contract

• Job Summary
• The role of Specialist Data Design works with manager, expert data design and data governance to drive best practices and a practice-based approach towards data design and management is responsible for working on collecting, storing, processing, and analyzing sets of data. The primary focus is on choosing optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them. They are also responsible for integrating them with the architecture used across the company.
• Main Responsibilities
• Data Design - 55%
• Create and maintain optimal data modeling and pipeline architecture
• Assemble large, complex data sets that meet functional / non-functional business requirements
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Extract, transform, and load data from a wide variety of data sources
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
• Work with stakeholders including the architecture, product management, infrastructure, data and design teams to assist with data-related technical issues and support their data infrastructure needs
• Keep our data separated and secure across the data lake/warehouse to adhere to industry and regulatory requirements
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader
• Work with data and analytics experts to strive for greater functionality in our data systems
• Follow standard and best practices to ensure the data design is maintainable, sustainable and properly documented with all the associated IP constructs
• Follow standards and best practices to ensure reliability, safety and cybersecurity standards are imbedded in the data design and sub systems
• Understand rail architecture in order to develop data models and understanding of all integrations
• Delivery & Quality - 45%
• Work with the development team to ensure data design is fully understood and developed with high quality
• Work closely with functional and technical leads to define relationships between business objects (entities) and how these objects will interact with the solution processes
• Perform data source discovery through reverse engineering, data readiness assessments and analysis
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Work with quality leads, management, and quality assurance to constantly monitor quality KPI’s and implement data design improvements
• Perform root cause analysis to support development process
• Decision Making & Impacts
• Collaborate with expert data designer and governance specialists to design and document various data management patterns and flows
• Has a direct impact on the quality of the data design and standards used to deliver
• Level of Interaction/Influence
• Collaborate with expert data designer and governance specialists to drive the data design
• Collaborate with architecture, product management, infrastructure and end users to fully design best in class solutions
• Employees supervised/Org Structure
• Individual Contributor
• Education/Certification/Designation:
• Bachelor's degree in Computer Science, Statistics, Informatics, Information Systems or equivalent degree & experience
• Skills/Knowledge:
• Good knowledge of data engineering and design principles
• Ability to analyze, design and document detailed data designs
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Strong analytic skills related to working with unstructured datasets
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Working knowledge of message queuing, stream processing and highly scalable ‘big data’ data store
• Strong organizational skills and can work autonomously to provide data solutions
• Good oral and written skills
• Data Hub
• Experience with big data tools: Spark, Kafka, etc.
• Experience building and optimizing data pipelines, architectures, and data sets
• Experience with relational SQL databases, including Postgres
• Experience with stream-processing systems: Storm, Spark-Streaming, etc.
• Experience with relational data warehouse databases like Netezza, DB2
• Experience with relational SQL databases
• Experience with modeling tools, specially ERWin
• Experience:
• Minimum 5-10 year overall work experience
• Minimum 5 years of analysis, data design and data modeling experience
• Minimum 4 years of data quality related experience (with or without tool-based solutions)
• Strong experience in process analysis and workflow modeling
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• A successful history of manipulating, processing and extracting value from large, disconnected datasets
• Assets
• Experience in working with Agile and DevOps development organizations
• Knowledge of transportation, PTC, and Rail is a definite asset

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf