The role is responsible for providing architectural, technical and analytic support to the company. The role would provide guidance towards establishing best practices in ETL standards, methodology and architecture. The role also conducts assessment of the business informational requirements and data sources and converts them into design specifications for reports and dashboards and then, builds them. The role requires the individual to work independently and to effectively work in teams, with a high level of initiative and motivation to ensure that deliverables are met.
The deliverables include: system architecture design and documentation, business analysis from an information usage perspective; data usage guidelines; procuring new sources of data; analyzing the data and supplying value added information to optimize processes and tracking trends for statistical purposes.
The incumbent will support usage of databases utilized by various reporting and analytical tools. Specific responsibilities include:
Development, tuning and optimization of the ETL packages, with emphasis on Microsoft SSIS;
Database tuning and optimization, specifically Microsoft SQL Server 2012;
Develop change management methodology leveraging TFS;
Gather and document information from business users regarding their reporting and analytical requirements;
Working with UI team to translate the business requirements into technical data requirements;
Develop source to target mapping documentation;
Data analysis of source systems to validate rules/assumptions;
Ensure accuracy and integrity of data and applications; and
Provide in-depth insights, where required, for root-cause analysis and historical trending.
Specific qualifications include:
Minimum 5 years experience in developing Data Warehouses;
Strong experience with T-SQL and the development/optimization of queries, specifically with SQL Server;
Strong experience with ETL tools, specifically with SSIS;
Proven experience with the administration and tuning of SQL Server databases;
Knowledge/experience of data modeling;
Knowledge/experience with a BI or Reporting applications such as Cognos, Business Objects, Microstrategy, etc.;
Knowledge/experience working with Team Foundation Services (TFS);
Experience with JD Edwards or some other ERP system is an asset; and
Strong communication and documentation skills.