Data Systems Engineer

2 weeks ago

Edmonton AB, Canada Indotronix Avani Group Full time

Actual Title: Data Systems and Planning Engineer

Duration: 1 year

Location: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume.

Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday)

This position will focus on:

• Creating, maintaining, modifying and implementing: Applications and data integration in MS SQL and Excel (e.g. cost estimating models). Implementing new PowerBI, low code apps, reports, and data collection.

• Analyzing department data, identifying gaps, recommending solutions, and creating and implementing new software systems, reports, with data integration and warehousing

• Improving the overall data management & information reporting systems within the department.

Specific Accountabilities:

• Data administration, integrity, management, and analysis for all aspects of the department’s data as required by management;

• Creation and / or implementation of new systems, reports, and data integration;

• Expectation to independently, manage a multitude of data sources in a controlled and efficient manner and directly resolve issues, with little oversight;

• Responsible for data collection, compilation and management processes development and implementation; and

• Required to work on multiple requests concurrently and be able to prioritize and meet target service levels.

• Lead in the development of application (SQL & VBA) and implementation of current estimating tools / programs;

• Lead / assist in data integration across the department and other department and Business Units – integrating data from company data sources, (eDig, Dig Tracker (and various other sharepoint sites), PACMAN, Oracle, EcoSys, etc.,

• Establish, create, and maintain reports on department data integrity from the various data sources used by the department in PowerBI;

• Work with the team on identifying gaps in data and recommend solutions to management;

• Ensure extraneous, wrong, or duplicate data is identified removed and / or corrected (and identify systemic issues to management);

• Work with other departments to help improve the interface of data sent between departments to reduce the overall amount of time the company expands on data management;

• Assist /lead in the development, analysis, and data warehousing of construction scope and cost metrics;

• Setting up a system or warehouse of program construction and cost metrics;

• Analyzing and vetting data that are used for metrics, removing erroneous data from the analysis;

• Create or update existing forms of data collection systems in the pertinent software platforms (MS SQL or other) to improve and streamline data collection and storage as requested by management;

• Provide technical guidance and business intelligence know-how in addressing business needs;

• Responsible for the code / scripts that extract, transform, clean, & move data from various data sources in the department into PowerBI and MS SQL (or other software platforms such as a “low code app” used by the department);

• Identify and develop new reports and / or analysis (self-identified improvements) for the department;

• Communicate effectively and frequently with department / client personnel as their requests are being fulfilled; be responsive and available to client concerns, issues, feedback, and questions;

• Identify and recommend on frequency of data updates for department information sources;

• Perform system tests and quality assurance activities on reports and data sources;

• Create and deliver end-user training & documentation as required;

• Develop / create an information data collection approach / system and process for non-standard or new work executed by the department to allow the scope to be included in current department reporting;

• Develop and write new (or update existing) department processes and procedures to improve information and data management for the department;

Working Conditions:

• Must be able to perform in a dynamic and high paced Project Execution environment

• Must be able to work to tight timelines and put in the hours required to get the work complete.

Knowledge, skills & abilities:

• 8+ years of experience in software development

• Expert knowledge of MS PowerBI, MS Excel, MS PowerPivot, and MS PowerView,;

• Comprehensive knowledge and experience in developing / programming in databases (Access, SQL), and (MS Visio) and ETL programs (Workato, SSIS)

• Advanced knowledge with MS Office 2010, 2013, and 365 (Word, Excel, and Power Point) and MS SharePoint;

• Adept at queries, reports and procedure writing and presenting findings;

• Technical expertise regarding data models development, data mining, data warehousing and segmentation techniques;

• Background in designing analytics portals / dashboards, metrics, and reports with various user interfaces;

• Undergraduate Degree in Computer Science,

• Undergraduate Degree in Industrial Engineering or Statistics with significant programming skills in MS SQL and VBA is preferred;

• Knowledge of statistics and experience using statistical packages (R Studio is preferred / company application) for analyzing large datasets would be an asset;

• Ability to multi-task, prioritize, and perform independently with minimal supervision;

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy;

• Strong data related analytical, critical thinking, and problem solving skills;

• Proven ability to problem solve and deliver high quality solutions on time in a fast paced environment;

• Exceptional collaborative skills – a team player;

• Excellent oral and written communication skills

Reporting Relationship:

Reports directly to the Manager, Planning and Analytics

Key relationships include: All team members in the department and PMs across / clients across the Pipeline Core Programs Division

  • Data Systems Engineer

    2 weeks ago

    Edmonton, AB, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning Engineer Duration: 1 year Location: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume. Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) This position will focus on: • Creating, maintaining, modifying and implementing: Applications and data integration...

  • Data Systems Engineer

    2 weeks ago

    edmonton, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning Engineer Duration: 1 year Location: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume. Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) This position will focus on: • Creating, maintaining, modifying and implementing: Applications and data...

  • Data Systems Engineer

    2 weeks ago

    edmonton, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning EngineerDuration: 1 yearLocation: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume.Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) This position will focus on:• Creating, maintaining, modifying and implementing: Applications and data integration in MS SQL...

  • Data Systems Engineer

    2 weeks ago

    Edmonton, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning EngineerDuration: 1 yearLocation: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume.Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) This position will focus on:• Creating, maintaining, modifying and implementing: Applications and data integration in MS SQL...

  • Data Systems Engineer

    2 weeks ago

    Edmonton, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning EngineerDuration: 1 yearLocation: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume.Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) This position will focus on:• Creating, maintaining, modifying and implementing: Applications and data integration in MS SQL...

  • Data Systems Engineer

    2 weeks ago

    edmonton, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning EngineerDuration: 1 yearLocation: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume.Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) This position will focus on:• Creating, maintaining, modifying and implementing: Applications and data integration in MS SQL...

  • Data Systems Engineer

    2 weeks ago

    Edmonton, Alberta, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning EngineerDuration: 1 yearLocation: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume.Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday)This position will focus on: Creating, maintaining, modifying and implementing: Applications and data integration in MS SQL and...

  • Data Systems Engineer

    2 weeks ago

    edmonton, Canada Indotronix Avani Group Full time

    Actual Title: Data Systems and Planning Engineer Duration: 1 year Location: Preferred Edmonton / Calgary is a 2nd option. Please advise location on resume. Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) This position will focus on: • Creating, maintaining, mo

  • Master Data Management Engineer

    2 weeks ago

    Edmonton, Alberta, Canada S.i. Systems Full time

    Our valued client is looking for a SnrData Architect to provide tactical advice on Data and analytics, Data Management, Master Data, Enterprise Data Warehouse, Power Bi, Information Governance.% remote, initial 8 month contract and develop strategic recommendations for senior management. # Define input/output sources, plan for technical design phase, and...

  • Control Systems Engineer/Tech

    2 months ago

    Redwater, AB, Canada NGL Control Systems Ltd Full time

    Recent Programming and Configuration Experience or experience with turnover packages and document as-building is a key asset.Local Applicants Only (Edmonton and surrounding areas)Looking for multiple Control Systems/Automation Engineers/Tech's to provide hands on support by being directly involved in the design, programming, testing, commissioning,...

  • Control Systems Engineer/Tech

    2 months ago

    Redwater, AB, Canada NGL Control Systems Ltd Full time

    Recent Programming and Configuration Experience or experience with turnover packages and document as-building is a key asset.Local Applicants Only (Edmonton and surrounding areas)Looking for multiple Control Systems/Automation Engineers/Tech's to provide hands on support by being directly involved in the design, programming, testing, commissioning,...

  • Data Systems and Planning Engineer

    2 weeks ago

    Edmonton, Canada Manpower Alberta Full time

    Data Systems and Planning Engineer Location: Preferred Edmonton / Calgary is a 2nd option. Hybrid Model: In-office (Monday, Tuesday & Thursday) Remote (Wednesday & Friday) Driving: Yes Travel: some travel maybe required This position will focus on: • Creating, maintaining, modifying and implementi

  • Senior Data Engineer to design and develop Azure data pipelines in an enterprise environment

    2 weeks ago

    Edmonton, Alberta, Canada S I Systems Full time

    Senior Data Engineer to design and develop Azure data pipelines in an enterprise environmentOur client is seeking a Senior Data Engineer to design and develop Azure data pipelines in an enterprise environment.This is a hybrid position requiring onsite work up to 3 days a week in CalgaryMust Have:6+ years as a Data Engineer with experience creating ETL...

  • Senior Data Engineer to design and develop Azure data pipelines in an enterprise environment

    3 weeks ago

    Edmonton, Canada S I Systems Full time

    Senior Data Engineer to design and develop Azure data pipelines in an enterprise environmentOur client is seeking a Senior Data Engineer to design and develop Azure data pipelines in an enterprise environment.This is a hybrid position requiring onsite work up to 3 days a week in CalgaryMust Have:6+ years as a Data Engineer with experience creating ETL...

  • Senior Data Engineer to design and develop Azure data pipelines in an enterprise environment

    3 weeks ago

    Edmonton, Canada S I Systems Full time

    Senior Data Engineer to design and develop Azure data pipelines in an enterprise environmentOur client is seeking a Senior Data Engineer to design and develop Azure data pipelines in an enterprise environment.This is a hybrid position requiring onsite work up to 3 days a week in CalgaryMust Have:6+ years as a Data Engineer with experience creating ETL...

  • Data Engineer

    1 week ago

    Calgary, AB, Canada Wipro Full time

    Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading global information technology, consulting and business process services company. We harness the power of cognitive computing, hyper-automation, robotics, cloud, analytics and emerging technologies to help our clients adapt to the digital world and make them successful. A company recognized...

  • Data Engineer

    2 weeks ago

    Calgary, AB, Canada Wipro Full time

    Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading global information technology, consulting and business process services company. We harness the power of cognitive computing, hyper-automation, robotics, cloud, analytics and emerging technologies to help our clients adapt to the digital world and make them successful. A company recognized...

  • Data Engineer

    2 weeks ago

    Calgary, AB, Canada Wipro Full time

    Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading global information technology, consulting and business process services company. We harness the power of cognitive computing, hyper-automation, robotics, cloud, analytics and emerging technologies to help our clients adapt to the digital world and make them successful. A company recognized...

  • System Engineer

    4 weeks ago

    Edmonton, AB, Canada PulseMedica Full time

    Are you a seasoned Systems Engineer with exceptional analytical, troubleshooting, and design capabilities? Are you passionate about making a profound, positive impact on people's lives through the development of a groundbreaking medical device that will revolutionize the treatment of eye disease? If this sounds like you, we want to hear from you!PulseMedica,...

  • System Engineer

    4 weeks ago

    Edmonton, AB, Canada PulseMedica Full time

    Are you a seasoned Systems Engineer with exceptional analytical, troubleshooting, and design capabilities? Are you passionate about making a profound, positive impact on people's lives through the development of a groundbreaking medical device that will revolutionize the treatment of eye disease? If this sounds like you, we want to hear from you!PulseMedica,...