Accessibility Links
  • Job reference: RMS0204442

CBU|MSP|IT-App Developer/Developer II

  • Sector: Engineering
  • Location: Calgary, Alberta
  • Job type: Contract
  • Date posted: 08/01/2019
  • Duration: 12 month renewable
This vacancy has now been filled but please feel free to use the links below to send us your CV or view similar jobs.

Alternatively you can contact the recruitment consultant in this area by using the links on the right hand side of this page.
Send jobs like this to my email    What's this?

The Role:
Our client has an outstanding reputation in the industry for process driven methodology and for being on the cutting edge of Technology and Security.
Our client is seeking an experienced BI Developer to support a new group within CBU IT, Data & Analytics, in Calgary. The data engineer is responsible for gathering requirements, design, creation and support of the data ecosystem. Works directly with business community to understand opportunities where data can provide significant business value and execute on those opportunities.
The IT Data Engineer Analyst will be responsible for the design, modelling, construction, testing, documentation, and implementation of data integrations. The IT Data Engineer Analyst will prepare and transform data to support analytics, data science use cases and data driven decision making.
* A minimum of 2-4 years of data engineering experience required, developing, testing, and deploying integrations with SSIS is required.
* 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 required
* Experience in complete ownership of building SSIS solutions from start to rollouts. 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.
* Documents all technical and system specifications documents for all SSIS ETL processes and perform unit test on all processes and prepare required programs and scripts
* Perform data quality assurance based on design specification, experience in data load strategies and Dimensional Data Modelling Star and Snow Flake Schema.
* Expert SQL skills; dimensional data modelling skills; .NET development, 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
* Strong verbal and written communications skills
* Excellent documentation and communication skills
* Highly collaborative working style
* Strong problem solving, analytical and diagnostic skills
* Candidate should be results oriented, able to deal with ambiguity, and possess strong communication and documentation skills.
* Results oriented, priority-based work ethic.

Preferred Qualifications:
* Oil and Gas experience would be a plus
* Experience creating data loader would be big plus
* Having strong understanding and experience of data ecosystem required - data lakes, data cubes, data ponds, data pipelines, data bricks, data warehouse strongly preferred
Bachelor's degree in MIS, Computer Science required
* Member Gather and document requirements for data warehouse use cases
* Design data models to support front-end BI tools including ad-hoc reporting
* Create and support all ETL jobs pulling data from various source systems and loading into the data warehouse
* Design and create a semantic layer to support end-user self-service
* Quickly and accurately respond to Ad-Hoc data requests
* Forecast, analyse data and trends and create reports that highlight areas in need of performance improvement
* Develop SSIS ETL packages, documentation and validate data load processes, ETL job scheduling, maintenance, debugging and support
* Works with the Data & Analytics team and other IT resources to effectively source required data domains; provide input and best practice approaches to building out effective data integration solutions which could include both internal and external (3rd party) data sets
* Provide input into the on-going improvement of the data sourcing and integration layer based on best practice data warehouse, data integration, data modelling, and data management methodologies and approaches
* Astute on new and emerging technologies and technical approaches (Big Data, Data Discovery, Data Visualization, Data Science, etc.)
Interview Process:
In-person interviews will be scheduled tentatively 1/16/2019 - 1/18/2019
Notes from manager:
Ideal candidate will should be results oriented, able to deal with ambiguity, and possess strong communication and documentation skills. Candidate will have the following:
1. SSIS experience is required
2. Azure SQL and Analysis Services
3. .NET/C# experience
4. Oracle
On boarding requirements:
Background Check:
* Eligible to work in Canada
* Criminal Background check within past 12 months
* Education Verification - highest degree
Drug Screen
Preventing Harassment in the Workplace Agreement

The Company:
Our client, a major owner/operating company, requires expertise for their LNG mega-project in Western Canada.This position is open to Canadian Citizens and Permanent Residents only.

About Fircroft:
Fircroft has been placing people in specialist technical industries for approaching half a century, focusing on mid to senior level engineers for contract and permanent roles worldwide. By applying for this job you give consent for Fircroft to contact you, via email & telephone, to discuss your application along with future positions and Fircroft's services.

Fircroft is registered as a Data Controller with the Information Commissioner as required under the General Data Protection Regulation 2016/679. Fircroft will only process your personal data for the specific purposes of managing your application.

Similar jobs
Alex Bannister
Field Service Engineer Location Home Based Duration permanent Field Service Engineer Water Measurement &...
Lab Technician Location Fort McMurray, Alberta Duration 12 months The Role: Key Accountabilities * Supports and complies with...
Kate Walker
Structural Systems Design Engineer Location Bristol Duration 12 months The Role: Our client is the second largest global provider...

Back to Top

By clicking "Save" you consent to
receiving matching jobs based on the
job/page you are viewing by email from
Fircroft, as detailed in our privacy policy
Fircroft would like to keep you up to date with our current vacancies and latest company updates via email. Occasionally Fircrofts marketing may contain 3rd party or affiliate information, however we will not share your personal data with any 3rd parties without your consent. From time to time, we might contact you to get your views on the service you have received. To help you get the best out of Fircroft, we may personalise them based on your location and how you use
Fircroft would like to keep you up to date with the latest company updates and vacancies via SMS / Text messages
Your consent options above means that Fircroft cannot contact you about any new or alternative career vacancies. If you want Fircroft to only contact you about the role(s) you have applied for please continue, however if you would like to be considered for other positions please allow us to contact you by changing one or more of the above consent.