Data Engineer Analyst

Sorry, this job is no longer available. Please Search for Jobs to conduct a new search

Eagle is currently seeking a Data Engineer Analyst for a one (1) year contract opportunity, scheduled to begin in February.

Key Responsibilities

The successful candidate will be responsible for:

  • Gathering and documenting requirements for data warehouse use cases;
  • Designing data models to support front-end BI tools including ad-hoc reporting;
  • Creating and supporting all ETL jobs pulling data from various source systems and loading into the data warehouse;
  • Designing and creating a semantic layer to support end-user self-service;
  • Quickly and accurately responding to ad-hoc data requests;
  • Forecasting, analyzing data and trends and creating reports that highlight areas in need of performance improvement;
  • Working with all levels of end users;
  • Developing SSIS ETL packages, documentation and validate data load processes, ETL job scheduling, maintenance, debugging and support;
  • Providing analytical as well as technical leadership, bringing new thinking and innovative approaches to solving problems;
  • Working with the Data and Analytics team and other IT resources to effectively source required data domains;
  • Providing input and best practice approaches to building out effective data integration solutions which could include both internal and external (third party) data sets;
  • Providing input into the ongoing improvement of the data sourcing and integration layer based on best practice data warehouse, data integration, data modeling, and data management methodologies and approaches;
  • Astute on new and emerging technologies and technical approaches (Big Data, Data Discovery, Data Visualization, Data Science, etc.); and,
  • Interacting with customers as a technical resource to troubleshoot data problems with the delivered BI solutions.

Skills and Qualifications

The qualified candidate must have:

  • A Bachelor’s Degree in MIS, Computer Science (or equivalent experience);
  • A minimum of two (2) to four (4) years of data engineering experience required, developing, testing, and deploying integrations with SSIS;
  • Experience with relevant technologies and skillsets include SSIS (SQL Server Integration Services), Azure SQL and Analysis Services, Oracle, logic Apps, ASP .NET, C#, Hadoop, SharePoint Online, Microsoft Power Suite, API Management;
  • Proficiency in MS Suite – SQL, Azure, Word, Excel;
  • Experience in complete ownership of building SSIS solutions from start to rollouts;
  • The ability to translate the business requirements to Functional/technical spec.;
  • Demonstrated ability to develop analytical solutions that meet or exceed the business needs;
  • Experience in developing Power BI reports and dashboards is a plus;
  • Experience documenting all technical and system specifications documents for all SSIS ETL processes and perform unit test on all processes and prepare required programs and scripts;
  • Experience developing and performing tests on all SSIS ETL codes for source data systems and analyze all data and design all data mapping techniques (source-to-target) for all data models in Data Warehouse;
  • Experience performing data quality assurance based on design specification, experience in data load strategies and Dimensional Data Modeling Star and Snow Flake Schema;
  • Expert SQL skills, dimensional data modeling skills, .NET development, and Stored Procedures in SQL Server;
  • Hands-on approach to working with data and working through technical data sourcing challenges;
  • Hands-on experience in writing T-SQL, stored procedures, views, joins as well as M and DAX in the MS BI tools;
  • Experience working with Python and with big data technologies like Spark, Hive, and Impala are a plus;
  • Eagerness to learn and build both technical and analytical skills;
  • The ability to be a self-starter and work independently and handle multiple projects simultaneously;
  • Strong verbal and written communications skills;
  • A highly collaborative working style;
  • Strong problem solving, analytical, and diagnostic skills;
  • Oil and Gas experience would be a plus;
  • Experience creating data loader would be big plus; and,
  • Strong understanding and experience of data ecosystem required – data lakes, data cubes, data ponds, data pipelines, data bricks, data warehouse strongly preferred.

Don’t miss out on this opportunity, apply online today!

We would like to thank all applicants for their interest; however, only candidates under consideration will be contacted.  Please note that your application does not signify the beginning of employment with Eagle and that employment with Eagle will only commence when placed on an assignment as a temporary employee of Eagle.

  • Posted On: January 07, 2019
  • Job Type: Contract
  • Job ID: 58915
  • Location: Calgary AB