Job Description

Summary


This role requires extensive and demonstrated experience leading successful large scale/enterprise data warehousing implementations in designing and developing the architecture for all data warehouse components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy).

Responsibilities

• Design, build and deploy integrated BI solutions (Dashboards, Standard Reports, ADHOC Self Service, Scorecards) using industry BI Tools.
• Analyze and migrate existing reporting tools into the new BI tools (SSRS, Excel, etc.)
• Provide support to end users
• Analyzing business needs and determining appropriate data, report design, and processes to deliver relevant BI solutions that leverage best practices
• Perform hardware / software planning, selection and procurement including upgrades and replacements.
• Assist in the setting, communicating and confirming compliance to enterprise-wide client technology standards (e.g. standard PC image)
• Work with Business SME and Business/Systems Analysts to define reporting requirements and goals and to identify the data needed for meeting business requirements
• Follows change and version control in moving code from development to test/QA and to production environments
• Maintain familiarity with IT industry trends and best practices.
• Researches, analyzes, recommends, and implements new methods, standard processes, best practices, and techniques for developing BI Solutions
• Ensure proper registration of devices and licensing compliance
• Adhere to all corporate IT policies, practices and procedures as required. This includes information security, change control and other related policies.
• Ensure all system problems and requests are logged and tracked in accordance with problem management procedures.
• Recommend improvements for BI Dashboard and ETL design processes, data quality and testing
• Define/help develop the semantic layer, metadata and report definitions
• Define and direct the implementation of security requirements for the data warehouse or source systems
• Define production release requirements and sustainment architecture
• Guide / manage Data Governance activities including establishing, publishing and implementing Data Governance standards, procedures and guidelines as it relates to BI/Analytics platform
• ETL design and process guidelines including data quality and testing
• Data Design, Data Modelling

Qualifications and Skills

• A post-secondary degree or diploma in computer science or equivalent.
• Hands-on experience in data architecting, data mining, large-scale data modeling, metadata management, and platform migration.
• Strong knowledge of applicable data privacy practices, regulatory compliance, governance and data security related issues.
• Knowledge of data modelling and data profiling / data quality techniques
• Demonstrated competencies and knowledge of relational database structures, theories, principles, and dimensional data modeling skills.
• Strong knowledge in Data Design, Data Modelling, and ETL best practices

Experience

• Minimum of 3 years of experience in data development creating data marts, data warehouses, and performing data engineering;
• Advanced knowledge of technical management processes (e.g. change control, backup, source control)
• Experience with Tableau, Microsoft Power BI
• Ability to connect and query data from Microsoft SQL, Progress OpenEdge, oData, webservices, Microsoft Office, Sharepoint, Microsoft Analysis Services, etc.


-------------------

Additional Information
--------------------------

About ATS
-------------

ATS is an industry-leading automation solutions provider to many of the world's most successful companies. ATS uses its extensive knowledge base and global capabilities in custom automation, repeat automation, automation products and value-added services, including pre-automation and after-sales services, to address the sophisticated manufacturing automation systems and service needs of multinational customers in markets such as life sciences, food & beverage, transportation, consumer products, and energy. Founded in 1978, ATS employs over 6,000 people at more than 50 manufacturing facilities and over 75 offices in North America, Europe, Southeast Asia, South Asia, and China. The Company's shares are traded on the Toronto Stock Exchange under the symbol ATS.