Analyst/Sr. Analyst, Strategic Planning and Analysis (2312436)

Responsible for communicating directly with business units to understand their business problems; Develop creative proof-of-concept solutions that can be easily articulated to the IT organization for production; Utilize SQL and R to create tables, stored procedures, and process data to be utilized by Sales applications and reports; Develop in R to support versioning of data and to query terms from a database; Utilize R markdown to create PDF documents; Develop Python Scripts for data migration; Maintain the reliability of solutions by developing and implementing standards and/or processes for database maintenance, documentation, and configuration; Create and maintain documentation related to the company’s software solution and database environment; Utilize various programming languages to provide analyst tools to perform statistical research and analysis; Develop forecasting models and new predictive analytics to enable strategy teams to identify trends; Refresh and maintain legacy reports currently developed in Excel; Identify, implement, and evaluate revenue growth programs, and develop practical revenue management solutions; Analyze passenger revenue by evaluating passenger demand and forecasting passenger revenue; Perform validation of models to ensure adequacy, define data requirements, gather and validate information, and apply statistical tests; Monitor the effectiveness of revenue strategies and initiatives including pricing, yield, network planning, sales, finance, AAdvantage, and marketing actions; Present analyses, strategies, and results to assist management with decision-making; Develop performance measurements and analytical tools to improve profitability and planning or forecasting processes; Develop reports and proposals, such as market assessments, business plans, financial performance plans, network profitability plans, fleet plans, capital expenditure requests, etc.; Analyze data derived from various areas, such as booking activity, fleet analyses, market trends, ROI analyses, performance and budget analyses, profitability statistics, previous campaign results, site statistics, marketing efforts, revenue management, and pricing trends to devise strategies to increase revenue and profitability. Work Schedule: 40 hours per week/8 a.m.-5 p.m./M-F. Job Location: Fort Worth, TX 1 year of experience as an Analyst, Data Scientist, or any occupation in which the required experience was gained, and demonstrated experience in: Microsoft SQL for querying, manipulating, and analyzing structured data within relational databases; Creating interactive visualizations and reports using data visualizations tools (Microsoft Power BI, Tableau) to communicate insights with stakeholders; GitHub for version control, collaborative development, and code repository management; Advanced expertise in Microsoft Excel, including Power Query, Power Pivot, and Pivot Tables for data transformation, complex data modeling, and analysis; Preparing and delivering presentations using Microsoft PowerPoint and producing professional documents using Microsoft Word; Database Management Systems for storing, organizing, and retrieving large datasets efficiently; Evaluating business proposals to assess feasibility, return on investment, and alignment with organizational objectives; Producing accurate documentation of data processes and reporting workflows to ensure consistency, compliance, and knowledge sharing; Data warehousing concepts and tools, including Teradata to support scalable data storage and retrieval, and analytics; Data cleaning, transformation, and wrangling to prepare high-quality datasets and analytics; Preparing and transforming raw data for analysis; Ability to develop Key Performance Indicators (KPI) and build dashboards to track business performance and enable data-driven decision making. Master’s degree in Business Analytics, Data Science, or related field. Please copy and paste your resume in the email body (do not send attachments, we cannot open them) and email it to candidates at placementservicesusa.com with reference #2312436 in the subject line. Thank you.