0 suggestions are available, use up and down arrow to navigate them
Business Intelligence ...

Create Job Alert.

Get similar jobs sent to your email

Apply to this job.
Think you're the perfect candidate?
Maintenance Business Intelligence Analyst at Republic Airways

Maintenance Business Intelligence Analyst

Republic Airways Indianapolis, IN (Onsite) Full-Time
Job Category:


At Republic Airways, our vision is to be America's regional airline of choice, and our 6,000 associates work together each day to achieve that by providing a safe, clean and reliable flying experience. Whether the role is on the aircraft or in the office, every person at Republic contributes to our success and our family-oriented work environment.

Since our founding in 1974, we've grown to become the world's largest operator of the Embraer 170/175 jet, flying more than 1000 flights daily for our partners, American Airline, Delta Air Lines and United Airlines. Beyond our operations, we're focused on sharing our time, talents and treasures with our community-both locally and globally.

Join Republic Airways where you will find opportunities, reach new heights and be part of something bigger than yourself. Republic Airways, opportunity elevated.



Develop reports & dashboards, transform data, and assist with the Extract Load Transform process within our Maintenance/Enterprise Data Management team.


To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodation may be made to enable individuals with disabilities to perform he essential functions.

* Work on stored procedures using T-SQL, which will help transform them from Ramco (Our Source Application) into our Synapse Data warehouse in Azure.
* Identify and be proficient in building User Defined Functions on the current data warehouse.
* Build dashboards using Data flows and understand the concept between data sets vs Data Flows in Power-BI.
* Manage Independently owned Azure Data factory jobs that can help load data from various sources in to the Datawarehouse/Synapse Environment.
* Work on making the SQL Stored procedure jobs efficient | Be able to Performance Tune and be familiar with optimizing Execution plan in SQL.
* Willing to Learn about Azure Synapse (Azure Data warehouse) which will be the true source of the truth in the company for all data needs.
* Willing to learn Py-Spark and Scala in Databricks to help the business find innovative ways to stream data and help with data transformations.
* Knows SCD Type 1 and 2 Concepts about transactional history of a single record in the Datawarehouse.


The requirements listed below are representative of the knowledge, skill, and/or ability necessary to perform this job.


* Bachelor's degree in Computer Science, Math, Business, or equivalent
* At least three years of related work experience developing solutions using BI software
* Proficient using Windows based products including Excel, Word, & Outlook
* Strong organizational, communication, and presentation skills


* Knowledgeable in the design of GUI (graphical user interface) for interactive BI dashboards
* Basic to intermediate level skill in integrating data using BI software
* Basic to intermediate level skill in scripting
* Candidate should possess strong background in Data Analysis and have some data modeling experience
* Basic to Intermediate level skill in using T-SQL
* Experience in a Data Warehouse environment reporting on dimensions/hierarchies
* Strong knowledge of the SDLC (Software Development Life Cycle) process
* Strong knowledge and understanding of databases and applications development concepts
* Capable of multitasking & prioritizing in a fast paced and agile work environment
* Attention to detail, consistency, and a passion to produce a quality product


Ability to read and interpret documents such as safety rules, operating and maintenance instructions, technical and procedure manuals. Ability to write reports, business correspondence, and procedure manuals. Ability to speak effectively before groups of customers or associates of the organization.


Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables. Able to read and interpret technical, regulatory, and contractual documentation. Able to maintain confidentiality.


Makes day to day decisions used to support strategic direction. Decisions often require some thought without established precedents or procedures. Decisions tend to be short term and usually of moderate cost. Able to work independently or as part of a team to drive results.


The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job.

* Able to move about the work environment.
* Frequently required to stand, walk, sit, talk, and hear.


The work environment characteristics described here are representative of those associate encounters while performing the essential functions of this job.

* Typical conditions of an indoor office environment. Occasionally work in an open-air hangar.


Able to travel up to 10% of the time, including overnight travel.

Equal Opportunity Employment and Disability Accommodations

Republic Airways is committed to achieving a diverse workforce by providing equal employment opportunities to all Associates and applicants, and prohibits discrimination and harassment of any type with regard to any characteristic protected by federal, state or local laws. We are committed to providing applicants and Associates reasonable accommodation to enable the individual to perform the essential duties of the job. If you require accommodation, please contact Human Resources.

Recommended Skills

  • Agile Methodology
  • Apache Spark
  • Attention To Detail
  • Business Correspondence
  • Business Intelligence
  • Communication
Apply to this job.
Think you're the perfect candidate?

Help us improve CareerBuilder by providing feedback about this job:

Job ID: 2381613201

CareerBuilder TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.