Software Engineer III

Max BR - 95

Sr. Data Engineer
Portland OR Reston VA Atlanta GA or Remote

Are you the data engineer Cirium is looking for? Cirium has grown its portfolio significantly through the acquisition of leading data intelligence companies including Ascend Innovata Diio and FlightStats.

Cirium is looking for a data engineer to work in a cross-functional agile team to process and increase the data quality of a new product. You will work alongside other skilled data engineers program managers architects and subject matter experts with the goal of accelerating the quality of our products data. Your core efforts will be focused on collaborating to understand existing and develop complex analysis pipelines using aviation data. Over the longer term you will be able to share your knowledge and expertise to help build the future of the companys data products.

The ideal candidate has a strong understanding of data engineering technologies and the AWS data stack. You understand the differences and complexities of working with different datasets versus more traditional RDBMSes. You will also need to have experience running data pipelines or notebooks and have worked with a data lake before.

This is an exciting time at Cirium as we are embarking on a journey to reshape the way the entire company works with data gathers analytical insights and builds new products. The data engineer role is at the heart of building out these capabilities with lots of room for growth along the way.

QUALIFICATIONS:

5 years in data management and analysi using Python / Pyspark

Bachelors Degree Engineering/Computer Science preferred but not required or equivalent experience.

SKILLS:

Solid knowledge of software development methodologies e.g. Agile Waterfall.

Strong proficiency with data manipulation in python

Strong understanding of normalized/dimensional data modeling principles.

Strong knowledge of AWS data tools and data storage options.

Strong knowledge in Industry data engineering best practices.

Knowledge in using and developing in SAS.

Ability to collaborate with various team members and functions to finalize requirements.

Knowledge of test-driven development.

Ability to troubleshoot and resolve process inefficiencies i.e. bugs in the repository.

Strong oral and written communications skills.

Knowledge of commercial aviation industry data ticketing booking itinerary data schedules US DOT aviation data DB1B and T-100 QSI

ACCOUNTABILITIES:

Perform data loads ensuring recurring updates are automated

Interface with other technical personnel or team members to document interpret and finalize requirements.

Produce code that is efficient repeatable without defects and adherent to best practices such as naming conventions encapsulation etc.

Write and review portions of detailed specifications for the development of data components.

Complete complex data engineering bug fixes and issues researching and identifying root causes as appropriate.

Identify opportunities to apply automation or other tools to improve effectiveness or efficiency.

Work closely with other development team members to understand complex product requirements and translate them into data engineering and/or data management designs.

Innovate process improvements that enable efficient delivery and maintenance.

Successfully implement development processes coding best practices and code reviews.

Operate in various development environments Agile Waterfall etc. while collaborating with key stakeholders.

Identify areas where it is an advantage to work with other teams to improve overall quality and with peers or others implement initiatives improving capabilities and efficiency.

Train entry-level data engineers as directed by department management ensuring they are knowledgeable in critical aspects of their roles.

Willingness to learn new languages and technologies.

Work with the team to build new estimation and forecasting models using fit for purpose data processing technologies such as SAS PySpark.

Mentor less senior data engineers on methodologies and optimization techniques.

All other duties as assigned

1. To get started can you give me a quick overview of your team and what you do?
a. The team is primarily an analytics team. Looking at data and verifying we have quality inputs and outputs. It is not a data science team but familiarity does help. The analysis the team does is in python so this IS a coding position. Just coding repeatable test against data along with some transformations and loading ETL.

2. The person who will be successful in this role will be somebody who?
a. Is able to work with others and bring skills and a desire to learn.

3. What would you say are the TOP 3 must-have skills youre looking for? Measurable skills technologies etc.
a. Data Analysis
b. Python
c. AWS

4. How many years of experience are you looking for? As you start to go through resumes what would stand out to you as the BEST candidate versus an AVERAGE candidate?

a. Best candidate would have 7 years of experience. And average candidate would have 5 years of experience.

5. Does your team work standard core hours or does that vary?
a. Standard core hours

6. Do you need someone with a particular degree or certification?
a. no

7. What are some of the performance indicators youll be looking for once this person ramps up? Meeting deadlines quality of work etc.
a. Ability to complete stories
b. Ability to work collaboratively

8. With some of the other huge tech companies out there competition for talent at all levels can get pretty tough at times. When suppliers start sourcing what would you say are some of the main selling points that would get candidates interested in your role over another?
a. Our team has good work life balance is a good place to learn and has many paths someone could choose to grow into.

9. What will your interview process look like? Phone and or face to face 30 or 1 hour
a. 30 min Phone screen
b. 1.5 hour technical questions review / case study
c. 2.5 hour interview

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.