< Back to the job list

ETL Developer (cloud-based)

Basic Information

Ref number

Req_00031122

Primary Location

Cork-Campus One

Description and Requirements

Applications Development Developer I | Information Services (BI Full Stack Developer) (TI Ireland) Determines and implements the best technique for extracting data from a particular source system and moving it to the Data Warehouse & BI platform, ensuring that the data comes into the system clean, accurate and in compliance with all standards and that the project deliverables are consistent with long-term infrastructure plans. Coordinate the construction of data models and ensure they conform to best practices while assisting with the running and creation of content in BI solution such as Google Data Studio, Domo & Sisense. A great opportunity for anyone looking to build a career in data and analytics, would suit an applicant with a passion for field, initial experience with data handling but now looking to grow their career and gain more practical experience. Responsibilities: Assist in growing a data driven culture within the business, increase adoption of analytical solutions while promoting best practices. Design and document Dimensional Data Models and ETL architecture for highly complex business operations, using star or snowflake schema to provide support for dashboards, analytics and reports, to analyze the what, why and/or what if analysis in compliance with all security rules/standards, Develop, test, deploy and document Dimensional Data Models and ETL pipeline for highly complex business operations (code/logic/programs) to provide the data to support the visualizations needs, to analyze the what, why and/or what if. Fix defects and implement enhancements in existing solutions (Log technical action reports), by identifying, code, test and deploy any changes on the existing products to improve the user needs, Identify platform dependencies and work with platform teams to develop and test new features to support any 3rd party tool integration needs. Knowledge of server/infrastructure set up and management, performance optimization. Manage user accounts and access privileges by mapping corresponding security permissions per application or enabling access using the Data Warehouse and BI platform in place (based on the privacy rules specified by each application) to comply with information security data access. Implement vendor software patches/upgrades by identifying the upcoming needs or new features to support existing services continuity. The successful candidate will be a part of multiple stages of dashboard development, from data modeling to business intelligence administration to dashboard implementation. Requirements: Meeting or exceeding all metrics in your current role for the last 3 months. Minimum of 95% Attendance. Minimum of 6 months as Voxpro employee. Minimum of 6 months in current position and account. No active disciplinary processes. Schedule flexibility Skills: Customer service oriented. Planning and organization. Continuous learning. Adaptability to change. Attention to details. Analysis, troubleshooting and critical thinking skills. Ability to have a business-oriented vision. Ability to formulate concepts. Strong team player who can adapt to changing priorities and manage multiple responsibilities. Knowledge: Strong working knowledge of SQL. Practical experience of other coding languages an advantage. Knowledge of ETL tools (desired) such as Talend, SSIS, NIFI. Demonstrate an understanding of dimensional data modeling and data standardization. Comprehensive knowledge of the principles, practices, and techniques used in Data Warehouse design and development (including: data extracts, data transfers, and load). Working knowledge of the Google Cloud Platform is an advantage. Experience of business intelligence tools such as Sisense/Tableau/QlikView/PowerBI (advantage) Demonstrate an understanding of how reporting and business intelligence is used by the business and how best to maximize its return on investment Practical experience administering a SAAS platform an advantage (user provisioning, security, infrastructure maintenance and content access) is desirable Knowledge and experience with web programming languages, structured and object-oriented and advantage Ability to work productively with cross-functional working groups and across organizational layers. Studies & Experience: At least 2 year in operational analytics/reporting or BI development - Required. At least 2 year in data warehouse data modeling and ETL development - Desirable. Working knowledge of BI tools including administration experience - Desirable. 4th year of Bachelor Degree Information Systems or a related area - Desirable. If you have questions or comments about this open position write to: internalpromotions.sv@telusinternational.com


Determines and implements the best technique for extracting data from a particular source system and moving it to the Data Warehouse & BI platform, ensuring that the data comes into the system clean, accurate and in compliance with all standards and that the project deliverables are consistent with long-term infrastructure plans. Coordinate the construction of data models and ensure they conform to best practices while assisting with the running and creation of content in BI solutions such as Google Data Studio, Domo & Sisense.


A great opportunity for anyone looking to build a career in data and analytics, would suit an applicant with a passion for field, initial experience with data handling but now looking to grow their career and gain more practical experience.


Responsibilities:


  • Assist in growing a data driven culture within the business, increase adoption of analytical solutions while promoting best practices.

  • Design and document Dimensional Data Models and ETL architecture for highly complex business operations, using star or snowflake schema to provide support for dashboards, analytics and reports, to analyze the what, why and/or what if analysis in compliance with all security rules/standards, Develop, test, deploy and document Dimensional Data Models and ETL pipeline for highly complex business operations (code/logic/programs) to provide the data to support the visualizations needs, to analyze the what, why and/or what if.

  • Fix defects and implement enhancements in existing solutions (Log technical action reports), by identifying, code, test and deploy any changes on the existing products to improve the user needs, Identify platform dependencies and work with platform teams to develop and test new features to support any 3rd party tool integration needs.

  • Knowledge of server/infrastructure set up and management, performance optimization.

  • Manage user accounts and access privileges by mapping corresponding security permissions per application or enabling access using the Data Warehouse and BI platform in place (based on the privacy rules specified by each application) to comply with information security data access.

  • Implement vendor software patches/upgrades by identifying the upcoming needs or new features to support existing services continuity.

  • The successful candidate will be a part of multiple stages of dashboard development, from data modeling to business intelligence administration to dashboard implementation.



Skills:

  • Customer service oriented.

  • Planning and organization.

  • Continuous learning.

  • Adaptability to change.

  • Attention to details.

  • Analysis, troubleshooting and critical thinking skills.

  • Ability to have a business-oriented vision.

  • Ability to formulate concepts.

  • Strong team player who can adapt to changing priorities and manage multiple responsibilities.

Knowledge:

  • Strong working knowledge of SQL.

  • Practical experience of other coding languages is an advantage.

  • Knowledge of ETL tools (desired) such as Talend, SSIS, NIFI.

  • Highly advantageous to have a strong knowledge and experience in Python.

  • Demonstrate an understanding of dimensional data modeling and data standardization.

  • Comprehensive knowledge of the principles, practices, and techniques used in Data Warehouse design and development (including: data extracts, data transfers, and load).

  • Understanding and experience in cloud based solutions such as AWS or Google Cloud Platform is an advantage.

  • Passionate about working with and analyzing data - especially Big Data.

  • Demonstrate an understanding of how reporting and business intelligence is used by the business and how best to maximize its return on investment

  • Practical experience administering a SAAS platform an advantage (user provisioning, security, infrastructure maintenance and content access) is desirable

  • Knowledge and experience with web programming languages, structured and object-oriented and advantage

  • Ability to work productively with cross-functional working groups and across organizational layers.

Advantageous:

  • Google Cloud or AWS Cloud Platform

  • BigQuery, ElasticSearch, Google Cloud Storage or AWS S3

  • Experience of business intelligence tools such as Sisense/Tableau/QlikView/PowerBI (advantage)


Studies & Experience:

  • At least 2 year in operational analytics/reporting or BI development - Required.

  • At least 2 year in data warehouse data modeling and ETL development - Desirable.

  • At least 1 year in Cloud based platforms such as GCP / AWS - Desirable.

  • 4th year of Bachelor Degree Information Systems or a related area - Desirable.




Additional Job Description

Applications Development Developer I | Information Services (BI Full Stack Developer) (TI Ireland) Determines and implements the best technique for extracting data from a particular source system and moving it to the Data Warehouse & BI platform, ensuring that the data comes into the system clean, accurate and in compliance with all standards and that the project deliverables are consistent with long-term infrastructure plans. Coordinate the construction of data models and ensure they conform to best practices while assisting with the running and creation of content in BI solution such as Google Data Studio, Domo & Sisense. A great opportunity for anyone looking to build a career in data and analytics, would suit an applicant with a passion for field, initial experience with data handling but now looking to grow their career and gain more practical experience. Responsibilities: Assist in growing a data driven culture within the business, increase adoption of analytical solutions while promoting best practices. Design and document Dimensional Data Models and ETL architecture for highly complex business operations, using star or snowflake schema to provide support for dashboards, analytics and reports, to analyze the what, why and/or what if analysis in compliance with all security rules/standards, Develop, test, deploy and document Dimensional Data Models and ETL pipeline for highly complex business operations (code/logic/programs) to provide the data to support the visualizations needs, to analyze the what, why and/or what if. Fix defects and implement enhancements in existing solutions (Log technical action reports), by identifying, code, test and deploy any changes on the existing products to improve the user needs, Identify platform dependencies and work with platform teams to develop and test new features to support any 3rd party tool integration needs. Knowledge of server/infrastructure set up and management, performance optimization. Manage user accounts and access privileges by mapping corresponding security permissions per application or enabling access using the Data Warehouse and BI platform in place (based on the privacy rules specified by each application) to comply with information security data access. Implement vendor software patches/upgrades by identifying the upcoming needs or new features to support existing services continuity. The successful candidate will be a part of multiple stages of dashboard development, from data modeling to business intelligence administration to dashboard implementation. Requirements: Meeting or exceeding all metrics in your current role for the last 3 months. Minimum of 95% Attendance. Minimum of 6 months as Voxpro employee. Minimum of 6 months in current position and account. No active disciplinary processes. Schedule flexibility Skills: Customer service oriented. Planning and organization. Continuous learning. Adaptability to change. Attention to details. Analysis, troubleshooting and critical thinking skills. Ability to have a business-oriented vision. Ability to formulate concepts. Strong team player who can adapt to changing priorities and manage multiple responsibilities. Knowledge: Strong working knowledge of SQL. Practical experience of other coding languages an advantage. Knowledge of ETL tools (desired) such as Talend, SSIS, NIFI. Demonstrate an understanding of dimensional data modeling and data standardization. Comprehensive knowledge of the principles, practices, and techniques used in Data Warehouse design and development (including: data extracts, data transfers, and load). Working knowledge of the Google Cloud Platform is an advantage. Experience of business intelligence tools such as Sisense/Tableau/QlikView/PowerBI (advantage) Demonstrate an understanding of how reporting and business intelligence is used by the business and how best to maximize its return on investment Practical experience administering a SAAS platform an advantage (user provisioning, security, infrastructure maintenance and content access) is desirable Knowledge and experience with web programming languages, structured and object-oriented and advantage Ability to work productively with cross-functional working groups and across organizational layers. Studies & Experience: At least 2 year in operational analytics/reporting or BI development - Required. At least 2 year in data warehouse data modeling and ETL development - Desirable. Working knowledge of BI tools including administration experience - Desirable. 4th year of Bachelor Degree Information Systems or a related area - Desirable. If you have questions or comments about this open position write to: internalpromotions.sv@telusinternational.com