Data Systems Engineer

2 weeks ago

Edmonton, Alberta, 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

  • 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...

  • 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...

  • Data Analyst

    2 weeks ago

    Edmonton, Alberta, Canada Vantix Systems Inc Full time

    DescriptionHybrid is possible (2 days per week) on site in Edmonton, Alberta.SkillsAzure Data Factory, Databricks, Python, PySparkType ContractExperience Required/Mandatory Skills Completion of a 4year Computer Science or Engineering degree, or a 2year Computer Engineering / System Technology diploma. Minimum 5 years of professional experience in software...

  • Engineer - Data Engineering

    2 weeks ago

    Edmonton, Alberta, Canada Enbridge Full time

    Temporary (Fixed Term) - Full time Are you passionate about safety? We have a phenomenal opportunity for you to join our Pipeline Integrity (PI) Planning team As the Engineer Pipeline Integrity (PI) Planning, you will execute the core process on all threat management programs on assigned segments of the Enbridge Liquid Pipeline system. We offer...

  • Analytics, Azure Data Factory, Databricks, Spark, SQL, Python, Power BI

    2 weeks ago

    Edmonton, Alberta, Canada Vantix Systems Inc Full time

    Our Client is seeking a Web/Data Analytics Systems Analyst to work on a variety of assignments. This is a Hybrid position and the resource MUST be located in Edmonton, Alberta. Skills Analytics, Azure Data Factory, Databricks, Spark, SQL, Python, Power BI Type Contract Experience Required/Mandatory Skills The proposed resource must have a minimum of the...

  • Systems Analyst

    2 weeks ago

    Edmonton, Alberta, Canada Vantix Systems Inc Full time

    DescriptionThis role is full time on site or hybrid in Edmonton, Alberta (2 days minimum per week).Skills Oracle, SQL, Oracle FormsType ContractExperience Required/Mandatory Skills Completion of a 4year Computer Science or Engineering degree, or a 2year Computer Engineering/System Technology diploma. Broad knowledge of computer systems technology and design...

  • Systems Analyst

    2 weeks ago

    Edmonton, Alberta, Canada Vantix Systems Inc Full time

    DescriptionSkills SQL, C#, deployment, NetworkType ContractExperience Required/Mandatory Skills Completion of a 4year Computer Science or Engineering degree, or a 2year Computer Engineering/System Technology diploma. Broad knowledge of computer systems technology and design techniques.Nice To Have Skills Minimum 3 years of experience working with databases...

  • System Engineer

    4 weeks ago

    Edmonton, Alberta, Canada Dycor Technologies Inc. Full time

    Dycor Technologies is currently seeking a full-time permanent Systems Engineer to work in Edmonton, AB.What Dycor offersYOU:Competitive compensation package , including a RRSP match program, profit sharing program, dental care, vision care, and extended health care The chance to work for a global leader while enjoying the benefits of a privately-owned...

  • System Engineer

    2 months ago

    Edmonton, Alberta, Canada Dycor Technologies Inc. Full time

    Dycor Technologies is currently seeking a full-time permanent Systems Engineer to work in Edmonton, AB.What Dycor offersYOU:Competitive compensation package , including a RRSP match program, profit sharing program, dental care, vision care, and extended health care The chance to work for a global leader while enjoying the benefits of a privately-owned...

  • Data Specialist

    2 weeks ago

    Edmonton, Alberta, Canada Vantix Systems Inc Full time

    DescriptionOur Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.The resource will be able to work remotely, within Canada.Skills Power BI, SQL Server, T-SQL, SSIS, SSRSType ContractExperience Required/Mandatory Skills The proposed...

  • Data Analyst

    2 weeks ago

    Edmonton, Alberta, Canada Vantix Systems Inc Full time

    DescriptionOur Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.Skills Microsoft BI Stack, Power BI, PeopleSoft or SAP, Public SectorType ContractExperience Required/Mandatory Skills The proposed resource must be proficient in Microsoft...

  • Systems Interface Engineer

    2 weeks ago

    Edmonton, Alberta, Canada McIntosh Perry Company Full time

    Are you ambitious and looking to make the right move in your career? Now is the perfect time to join Egis. Egis is experiencing substantial growth in North America, highlighted by our recent acquisition of McIntosh Perry—now made up of over 1,000 engineers, architects and planners across Canada and the USA. This strategic move underscores our commitment...

  • Civil Technologist/Engineer-in-Training

    2 weeks ago

    Edmonton, Alberta, Canada Urban Systems Full time

    Our growing Edmonton office is looking to add a highly capable Civil Engineering Technologist to our team to deliver excellent service to our Municipal and Indigenous clients across Central and Northern Alberta. As a Civil Engineering Technologist, you will be responsible for working alongside our team of engineering, planning, and drafting specialists to...

  • Marketing Systems manager

    2 weeks ago

    Edmonton, Alberta, Canada MMCI Safety Systems Inc. Full time

    About Us: MMCI Safety Systems has been a trusted name in the life safety and security industry for 25 years, specializing in the design, engineering, installation, and servicing of advanced safety systems. We are proud to provide excellent quality equipment and service to our clients. Currently, we are developing an innovative fire alarm interface technology...

  • Engineer - Industrial Engineer

    2 weeks ago

    Edmonton, Alberta, Canada Ryder System Full time

    Job information Warehouse Industrial Engineer from the Company Ryder System , this latest Warehouse Industrial Engineer job vacancy is located in the city Edmonton, AB located in the country Canada . This latest job opening is open to job seekers who have the latest education / graduate Bachelor Degree . Job Vacancies in this Customer Service field have been...

  • Analyst, Data

    2 weeks ago

    Edmonton, Alberta, Canada EPCOR Full time

    Highlights of the job We are hiring up to two (2) fulltime permanent Analyst, Data to join the Water Services, Customer Operations team working primarily from the EPCOR Tower located in downtown Edmonton, AB. In the Analyst, Data role you are responsible for supporting optimal adoption of systems and use of data for decision making across EPCOR Water...

  • Engineer - Industrial Engineer

    2 weeks ago

    Edmonton, Alberta, Canada Ryder System, Inc. Full time

    Job Seekers can review the Job Applicant Privacy Policy by clicking HERE. This position supports the Ryder Continuous Improvement culture across the operation by actively applying continuous improvement methods to support operations. The Engineer will identify and implement change within the operation through data driven CI, Engineering, and Automation...

  • Data Architect

    4 weeks ago

    Edmonton, Alberta, Canada Zortech Solutions Full time

    Description Resource should have strong knowledge in Cloud and Informatica ETL (Hands-on). Responsible for evaluating migration needs, design and implement effective database solutions and models to store and retrieve data High-performing, being accountable on given tasks in timely manner, adapting to changes, going above and beyond to achieve project goals....

  • Data Analyst

    2 weeks ago

    Edmonton, Alberta, Canada Vantix Systems Inc Full time

    DescriptionRemote from within Alberta (preferably in the Edmonton area).MUST reside in Alberta.Skills SSIS, SQL, Power BI, Incorta, Agile, TFS, ITIL, Python, hadoopType ContractExperience Required/Mandatory Skills Very strong proficiency with SSIS and SQL. Experience in creating automated data cleansing scripts. Experience performing data profiling and...

  • SR Solution/ Data architect with security clearance to join the Nuclear Development team

    2 weeks ago

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

    Our client is seeking a SR Solution/ Data architect with security clearance to join the Nuclear Development teamJob Description:We are seeking an experienced Enterprise / Cloud Architect with a strong background in the Canadian nuclear industry to join our SMR/Nuclear Development team. The successful candidate will play a critical role in designing,...