Job Description
Job Description
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 toolsKnowledge of DBT, Jinja, SQL and Python data modelingPython Pandas, Numpy, Sklearn, SnowparkDeep understanding of Snowflake structures & functionalitiesPowerBI DAX, ExcelKnowledge of Oracle, PL / SQL is a plusKnowledge of AWS SageMaker is a plusKnowledge of Apache Airflow is a plusKnowledge of WebFOCUS is a plusExcellent written and verbal communication skillsAnalytical ability to gather data, perform transformation, perform complex analysis, solve both business and technical problemsCome check out how #gatelesis is "Intelligently Defining the FUTURE of Aviation and Aerospace"
See what #GATelesis life is like : LinkedIn, Instagram, Facebook.
Powered by JazzHR
AJYjb9PNz5