Technical Business Analyst (REMOTE)

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Date Posted:
2022-05-27-07:00
Country:
United States of America
Location:
UTCT1: Corp - CT - Remote Remote Location, Remote City, CT, 06101 USA
Raytheon Technologies Corporation is an Aerospace and Defense company that provides advanced systems and services for commercial, military and government customers worldwide. It comprises four industry-leading businesses - Collins Aerospace Systems, Pratt & Whitney, Raytheon Intelligence & Space and Raytheon Missiles & Defense. Its 195,000 employees enable the company to operate at the edge of known science as they imagine and deliver solutions that push the boundaries in quantum physics, electric propulsion, directed energy, hypersonics, avionics and cybersecurity. The company, formed in 2020 through the combination of Raytheon Company and the United Technologies Corporation aerospace businesses, is headquartered in Waltham, Massachusetts.

To realize our full potential, Raytheon Technologies is committed to creating a company where all employees are respected, valued and supported in the pursuit of their goals. We know companies that embrace diversity in all its forms not only deliver stronger business results, but also become a force for good, fueling stronger business performance and greater opportunity for employees, partners, investors and communities to succeed.

Summary of Role:

The Technical Business Analyst will support the needs of the data consolidation, technical documentation, data warehouse development, data analysis and reporting.

Responsibilities:

Understand the business objectives and the key stakeholders involved

Understand the business use cases

Document technical specs with the template provided

Review the technical specs with the business team and incorporate any feedback

Build the data dictionary as needed

Build the logical data model

Understand the data feed automation process and propose ways to automate through the MFT/API on the Matillion side

Understand/build the snowflake physical data model, if needed

Get the database model reviewed by the solution architect

Understand the E2E data flow from the source into Snowflake DWH

Understand the data dashboard reporting needs and the report layouts.

Build Qlik reports as needed by the business (if applicable)

Work with the solution architect to resolve any architectural issues

Work with the business teams/file owners to resolve any understanding on the incoming technical files and transfer mechanism

Participate in project meetings and follow up with appropriate stakeholders as needed

Perform functional/end user testing in development and staging as needed for both the database and the reports (Using Qlik, tableau)

Document the test cases and results

Work with the solution architect for the code migration (Dev -> QA -> Prod), if applicable

Work with the DWH Project PM, Program lead, solution architect to formulate the project release timelines

Give a walkthrough of the final product to business and secure signoff before moving to production

Familiarity with Snowflake and Matillion is a plus

Hands on experience working on IT development projects and a thorough understanding of the software methodology.

Education:

Typically requires a University Degree or equivalent experience and minimum 5 years prior relevant experience, or An Advanced Degree in a related field and minimum 3 years experience

Preferred Qualification:

Experience in technical documentation, creating data dictionary, entity relationship diagrams in a relational database development environment.

Experience in reports development using Qlik or Tableau

Location:

REMOTE USA

Required Immigration Status:

US Citizen or US Person required.

Raytheon Technologies is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

Privacy Policy and Terms:

Click on this link to read the Policy and Terms
More Information on Collins Aerospace
Collins Aerospace operates in the Aerospace industry. The company is located in Charlotte, NC. Collins Aerospace was founded in 2022. It has 40752 total employees. It offers perks and benefits such as Flexible Spending Account (FSA), Disability Insurance, Dental Benefits, Vision Benefits, Health Insurance Benefits and Life Insurance. To see all 101 open jobs at Collins Aerospace, click here.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Similar Jobs

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Collins Aerospace's full profileFind similar jobs