Data Integration Engineer

DFW International Airport•Grapevine, TX

1d•Onsite

About The Position

GENERAL SUMMARY: Under supervision of the Senior System Integration Manager, is responsible for ensuring that the Airport’s strategic goals are optimized through the use of Enterprise Business Intelligence. Assists internal team members and BI users in the use of and the presentation of data including predictive data. Uses tools, protocols, and programming languages to develop and maintain ETL (extract, transfer and load) applications and environments. PRINCIPAL DUTIES AND RESPONSIBILITIES: Develops and maintains the database scripts and ETL processes required to move data from source systems to the EDW. Maintains the ETL processes on a timely basis making certain all are running and providing data in the best format for the EDW. Develops and migrates mapping and workflows between repositories. Works with BI Team to assess business needs as they pertain to current EDW and ETL processes so the best solution is presented to customers. Maintains incremental load processes for all data loads. Responsible for maintaining settings for ETL including, users, file system and services. Works with System Administrators, Database Administrators, and the Quality Assurance Center of Excellence to test and tune development efforts. Ensures that current and future systems that are planned developed or procured meet Board standards and are compatible. Plans, monitors and reviews various data and metrics. Uses operational research methods to develop forecasts and predictive analytic sets. Sets standards criteria and verifies that the standards are being met. Uses statistical analysis to generate predictive analytic sets and mitigation plans for requested datasets Documents observations and establishes predictability and trend reports to develop daily and operational plan for allocation of resources. Researches and compiles data to recommend sustainable and executable plans. Maintains daily documentation of special and unusual occurrences and other data pertinent to the daily operation. Provides input on graphical representation of data to assist business in answering questions or making decisions. Works with MicroStrategy Developers, Architects, and ETL Developers to ensure data is prepared as needed for predictive models to work properly. Work with stakeholder throughout the Airport to identify opportunities for leveraging company data to drive business solutions Develop custom data models and algorithms to apply to data sets. Use predictive modeling to increase and optimize customer experience, revenue generation and other business outcomes. Coordinate with departments to implement models and monitor outcomes.

Requirements

Bachelor's degree in business, computer science or a related field
Five (5) years of experience using Informatica as an architect, designer and developer
Expertise in designing, creating, and using re-useable mapping components.
Experience using PowerCenter in multiple-developer environments.
Strong knowledge of Informatica development best practices.
Experience working with Informatica in a Unix environment.
Experience tuning performance of ETL processes.
Experience configuring Informatica jobs and dependencies when using 3rd party enterprise scheduling tools.
Any equivalent combination of education and/or experience may be substituted for the above.
Possession of a valid class C driver's license.
In depth knowledge of ETL including planning the ETL process through completion
Skill in building and maintaining OLAP style Data Warehouses to support Enterprise Business Intelligence reporting tools.
Skill in writing and tuning SQL and PL/SQL language, demonstrated technical innovation, strong understanding of databases, and detailed knowledge of and experience with technical modeling.
Knowledge of the principles and practices of project management, planning and scheduling relating to complex and diverse data management and end-user support issues.
Knowledge of current computer technology.
Ability to communicate clearly and effectively, both orally and in writing, at all levels within and outside the organization.
Ability to establish and maintain effective working relationships inside and outside the organization.
Advanced skill in use of Microsoft Office, including Outlook, Excel, Word, PowerPoint, and other computer applications including but not limited to skill in using shortcuts, macros, visual basic editing and advanced formulas)
Ability to work with mathematical formulas and statistical data sets, to include charting and graphing.
Experience with common data science toolkits, such as R. SAS or Python
Good applied statistics skills, such as distributions, statistical testing, regression, etc.

Nice To Haves

Experience designing, developing and deploying ETL processes; experience with data loading and the creation of data warehouses and/or data marts; hands-on ETL development; and experience reviewing ETL load jobs coded by others for consistency and quality.
Experience coaching and training customers and peers in the use of ETL tools to assist with ETL processes.
Degree or certificate within Statistical Analysis, Business Analytics, Predictive Analytics, etc
Experience with data visualization tools, such as D3.js
Data-oriented personality
Ability to speak a second language in addition to English.

Responsibilities

Develops and maintains the database scripts and ETL processes required to move data from source systems to the EDW.
Maintains the ETL processes on a timely basis making certain all are running and providing data in the best format for the EDW.
Develops and migrates mapping and workflows between repositories.
Works with BI Team to assess business needs as they pertain to current EDW and ETL processes so the best solution is presented to customers.
Maintains incremental load processes for all data loads.
Responsible for maintaining settings for ETL including, users, file system and services.
Works with System Administrators, Database Administrators, and the Quality Assurance Center of Excellence to test and tune development efforts.
Ensures that current and future systems that are planned developed or procured meet Board standards and are compatible.
Plans, monitors and reviews various data and metrics.
Uses operational research methods to develop forecasts and predictive analytic sets.
Sets standards criteria and verifies that the standards are being met.
Uses statistical analysis to generate predictive analytic sets and mitigation plans for requested datasets
Documents observations and establishes predictability and trend reports to develop daily and operational plan for allocation of resources.
Researches and compiles data to recommend sustainable and executable plans.
Maintains daily documentation of special and unusual occurrences and other data pertinent to the daily operation.
Provides input on graphical representation of data to assist business in answering questions or making decisions.
Works with MicroStrategy Developers, Architects, and ETL Developers to ensure data is prepared as needed for predictive models to work properly.
Work with stakeholder throughout the Airport to identify opportunities for leveraging company data to drive business solutions
Develop custom data models and algorithms to apply to data sets.
Use predictive modeling to increase and optimize customer experience, revenue generation and other business outcomes.
Coordinate with departments to implement models and monitor outcomes.