GA Telesis is a global leader providing integrated solutions to the aviation and aerospace industries. We serve over 2,000 customers, including airlines, original equipment manufacturers, maintenance, repair, and overhaul (MRO) providers, and component suppliers worldwide, with 31 leasing, sales, distribution, and MRO operations in 19 countries. The GA Telesis Ecosystem™ concept is core to our providing integrated aviation solutions to our global customers.

Within the IT Department at GA Telesis, the Data Team focuses on creating a competitive advantage for our business units by helping them make quick decisions based on the analytics we provide them. We are a small but growing team that builds and leverages state-of-the-art analytics systems. Reporting to the Director of Data Services, the Data Engineer role will gather and evaluate business requirements and translate them into functional solutions. Solutions will range from:

Enforcing data security and accessibility
Setting up data collection and processing infrastructure
Design and process data models to support business intelligence reporting
Administer databases with a focus on ease of access and cost control
Occasionally create Business Intelligence reports and Data Visualizations

This position has an in-depth background in data modeling and data analysis and requires strong business acumen.

**Important Notice:
Eligibility Requirement: Only U.S. Citizens or Permanent Residents will be considered for this position.

Responsibilities:

Collect & Document requirements from business and operational process owners.
Work together with Data Warehouse administrators to create & document data pipelines. Using our world class data technology stack, based on Fivetran, DBT Cloud, and Snowflake.
Participate in the creation and maintenance of our ETL processes.
Build and maintain BI reports and dashboards using Power BI and other data visualization tools, notably Excel, Hex.tech, Jupyter Notebooks.
Maintain GA Telesis’s KPI documentation.
Analyst business requirements, processes, and recommend improvements to management and executives.
Conduct ad-hoc analysis in domains covering Global Aviation Market Demand, Supply Chain, Customer Retention, Quotes to Sales Conversion, Marketing Campaign effectiveness, Product Management, Asset Management, Inventory Management, etc.
Create and maintain documentation for our self-service data warehouse and assist other business analysts throughout the corporation to empower all users with data skills.
Develop forecasting models.
Write or optimize automation steps with the use of PL/SQL, Python, or JavaScript.
Conduct market watch and benchmark and be a key decision maker in the selection of future data products to drive innovation at GA Telesis.

Qualifications:

Mandatory Knowledge of dimensional modeling and ETL processes and tools
Knowledge of DBT, Jinja, SQL and Python data modeling
Python Pandas, Numpy, Sklearn, Snowpark
Deep understanding of Snowflake structures & functionalities
PowerBI DAX, Excel
Knowledge of Oracle, PL/SQL is a plus
Knowledge of AWS SageMaker is a plus
Knowledge of Apache Airflow is a plus
Knowledge of WebFOCUS is a plus
Excellent written and verbal communication skills
Analytical ability to gather data, perform transformation, perform complex analysis, solve both business and technical problems

Come check out how #gatelesis is "Intelligently Defining the FUTURE of Aviation and Aerospace"

See what #GATelesis life is like: LinkedIn, Instagram, Facebook.

AJYjb9PNz5

GA Telesis, LLC

Latest Jobs

Data Engineer

Software Developer