Data Integration Engineer

Dallas Fort Worth International Airport • DFW Airport, TX

8d

About The Position

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.

Requirements

• Bachelor's degree in business,puter 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 mappingponents.
• 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 equivalentbination 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 throughpletion
• 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 toplex and diverse data management and end-user support issues.
• Knowledge of currentputer technology.
• Ability tomunicate clearly and effectively, both orally and in writing, at all levels within and outside theanization.
• Ability to establish and maintain effective working relationships inside and outside theanization.
• Advanced skill in use of Microsoft Office, including Outlook, Excel, Word, PowerPoint, and otherputer 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 withmon 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 arepatible.
• 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 andpiles data to rmend 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 leveragingpany data to drive business solutions
• Develop custom data models and algorithms to to data sets.
• Use predictive modeling to increase and optimize customer experience, revenue generation and other business oues.
• Coordinate with departments to implement models and monitor oues.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level