Data Integration Engineer

Join to apply for the Data Integration Engineer role at Dallas Fort Worth International Airport (DFW).

Get AI-powered advice on this job and more exclusive features.

Under supervision of the Senior System Integration Manager, the Data Integration Engineer is responsible for ensuring that the Airport’s strategic goals are optimized through the use of Enterprise Business Intelligence. The role assists internal team members and BI users in the use of and presentation of data, including predictive data. The engineer uses tools, protocols, and programming languages to develop and maintain ETL (extract, transfer and load) applications and environments.

• Develop and maintain the database scripts and ETL processes required to move data from source systems to the EDW.
• Maintain the ETL processes on a timely basis, ensuring all are running and providing data in the best format for the EDW.
• Develop and migrate mapping and workflows between repositories.
• Work with the BI Team to assess business needs as they pertain to the current EDW and ETL processes so the best solution is presented to customers.
• Maintain incremental load processes for all data loads.
• Maintain settings for ETL including users, file system and services.
• Collaborate with System Administrators, Database Administrators, and the Quality Assurance Center of Excellence to test and tune development efforts.
• Ensure that current and future systems that are planned, developed or procured meet Board standards and are compatible.
• Plan, monitor and review various data and metrics.
• Use operational research methods to develop forecasts and predictive analytic sets.
• Set standards criteria and verify that the standards are being met.
• Use statistical analysis to generate predictive analytic sets and mitigation plans for requested datasets.
• Document observations and establish trend reports to develop daily operational plans for allocation of resources.
• Research and compile data to recommend sustainable and executable plans.
• Maintain daily documentation of special and unusual occurrences and other data pertinent to the daily operation.
• Provide input on graphical representation of data to assist business in answering questions or making decisions.
• Work with Micro Strategy Developers, Architects, and ETL Developers to ensure data is prepared as needed for predictive models to work properly.
• Work with stakeholders 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.

• 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 reusable mapping components.
• Experience using Power Center in multi‑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 third‑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, demonstrated technical innovation, strong understanding of databases, and detailed knowledge of technical modeling.
• Knowledge of project management principles and practices, planning and scheduling related 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,…