Job Description

Trade Street Consulting has been asked to assist a local Charlotte, NC client in locating a full time Informatica ETL Developer.  This position needs to be based in Charlotte, NC and will need to be onsite.  If interested, please send an updated word-version resume along with salary expectations.

 

ETL Specialist- Job Description

Purpose:

The ETL Specialist will be responsible for data modelling, extraction, processing and validation for the operational and development activities of the Business Intelligence Competence Center within Global IT, driving standardization and consolidation of BI solutions.

 

PRINCIPAL ACCOUNTABILITIES:

  • Design, develop, implement and maintain data models and data processing logic based on customer requirements;
  • Translate business requirements to user stories, technical requirements and data mart design;
  • Work with technical teams and end-users from the business to ensure that the BI function delivers the required outcome with proper master data governance and tooling;
  • Design business rules and data quality rules and provide insight to the business of these internal business rules;
  • Perform source system data profiling and data quality assessments;
  • Perform quality assurance functions as they relate to reporting and data validation;
  • Analyze and interpret data for business and operational initiatives;
  • Research data anomalies and engage business and operational stakeholders to develop solutions;
  • Give advice and training around data governance and data quality.

 

By safeguarding the availability and continuously improving the data processing capabilities within company, the Senior Engineer BI will help the organisation in making data driven decisions.

Although it is hard to quantify the direct contribution to company results, the Senior Engineer BI enables members of various functions to focus on improving their department’s activities.

It is expected of the ETL Specialist to continuously strive to significantly improve the data collection and processing processes, enforcing standardisation and consolidation of these capabilities throughout the organisation. He will also support users with activities regarding data quality and master data management.

The nature of these improvements is mainly on the operational and technical level, focusing on processes and tooling. As it concerns the application of data from a multitude of sources, tailored to specific business functions, it is not easily understood and will require both a creative and an analytical mind.

 

 

REPORTING AND SCOPE:

There will be no direct reports to this position.

The ETL Specialist will report to the Head of BI Competence Center.

There are no indirect or matrix reporting lines.

The ETL Specialist will focus on deployment and execution of BI solutions (across the globe, but based in Charlotte, USA). He/she also needs to engage with technical teams in the Netherlands and India. This engagement will require travel.

 

 

WORK/BUSINESS CONTACTS AND AUTHORITY:

The ETL Specialist will align with key users in various global functions to understand business processes and the corresponding data requirements. He will support business analysts and reporting specialists in detailing the information model for user requirements.

 

The ETL Specialist will coordinate with technical teams at global level to establish and maintain data exchanges and processing logic for business intelligence and analytics.

 

The ETL Specialist will communicate with the (external or group-level) parties that provide operational platform support, to address operational issues and plan maintenance activities.

 

The ETL Specialist will align with information security regarding issues of data ownership and data protection.

 

Most of the communication will be with parties that work directly or specifically for company, as well as specific software vendors.

 

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online