Dallas Fort Worth International Airport (DFW) ยท 16 hours ago
Data Integration Engineer
DFW Metroplex
Full-time
Onsite
Senior Level
5+ years expDallas Fort Worth International Airport (DFW) is recognized for its innovation and excellence, and they are seeking a Data Integration Engineer to optimize the Airport's strategic goals through Enterprise Business Intelligence. The role involves developing and maintaining ETL applications, collaborating with internal teams, and ensuring data is effectively utilized for predictive analytics and business solutions.
Airlines/Aviation
No H1B
U.S. Citizen Only
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
Qualification
Required
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
Must obtain a Security Identification Display Area (SIDA) Airport Identification/Access Badge (badge) in accordance with Department of Homeland Security Transportation Security Administration (TSA) requirements in Chapter 49 of the Code of Federal Regulations Part 1500 et. Al. and DFW Airport's Airport Security Program within thirty (30) days from date of employment and maintain qualification for a SIDA badge upon each badge renewal
Ability to obtain Department of Homeland Security Customs and Border Protection (CBP) security access clearance within thirty (30) days from date of employment and maintain qualification for CBP security access clearance upon each CBP security access renewal
This is a designated essential employee position as defined in the Categories and Classifications of Employees Policy of the Airport Administrative Policy and Procedure. This is defined as an employee whose attendance is required to maintain airport operations during an emergency or inclement weather situation
Preferred
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
Company
Dallas Fort Worth International Airport (DFW)
DFW Airport, the 2022 Airport Service Quality (ASQ) winner for Best Airport that serves over 40 million passengers in North America by Airports Council International (ACI), warmly welcomes more than 72.2 million customers along their journey every year, making DFW one of the most frequently visited superhub airports in the world.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Sean Donohue
CEO
HR at Dallas Love Field
Aviation Partner
Company data provided by crunchbase