Data Warehouse Systems Administrator (Puerto Rico)

Date Posted:

Country:

Location:

Position Role Type:

U.S. Citizen, U.S. Person, or Immigration Status Requirements:

Security Clearance:

Collins Aerospace is a leader in technologically advanced, intelligent solutions that help redefine the aerospace and defense industry. With a comprehensive portfolio and deep technical expertise, we help customers meet the demands of the global market. Join us and help shape the future of aerospace and defense.

As a member of the data systems administration team, the Data Systems Administrator helps support, optimize, and secure the enterprise data warehouse and a suite of analytics platforms—including Business Objects, Matillion, Alteryx, and Immuta. This role works closely with fellow administrators, engineers, analysts, and business partners to maintain reliable, well‑governed data systems that power analytics and operational insights across Collins.

**This is a hybrid position in Puerto Rico, candidate must reside in Puerto Rico**

What YOU will do:

• Support the administration, configuration, and monitoring of the enterprise data warehouse and related analytics platforms as part of a collaborative systems team.
• Help maintain ETL/ELT pipelines, job schedules, data ingestion processes, and key integration points across systems.
• Contribute to BI environment support, including content promotion, user provisioning, security, and report performance.
• Support cross-platform monitoring to ensure stability, availability, and reliable system performance.
• Help enforce security standards, sensitive-data controls, and governance practices.
• Assist with backup, recovery, and disaster recovery procedures.
• Collaborate with data engineers, administrators, and business teams to optimize workflows, schemas, queries, and access policies.
• Diagnose and resolve system issues, performance bottlenecks, and integration challenges.
• Apply patches, updates, and platform upgrades.
• Contribute to system documentation, operational procedures, and automation or modernization initiatives.
• Support service-level objectives through proactive maintenance and business-aligned system support.
• Promote integrity, availability, and security of data and systems across the analytics ecosystem.

What You Will Learn:

• How Collins’ enterprise data warehouse platforms operate and integrate with engineering, operations, supply chain, quality, and enterprise systems.
• Aerospace & Defense–specific expectations for system hardening, data security, compliance, controlled information handling, and audit readiness.
   
• How sensitive, regulated, and operational data enters and moves through warehouse systems—and how to safeguard it through segmentation, access control, and monitoring.
• How to apply business rules, cybersecurity policies, and legal/compliance requirements to create secure, well-governed data environments.
• Best practices for maintaining resilient, high availability warehouse systems, including patching, monitoring, performance tuning, and disaster recovery.
• Effective cross-functional coordination with data engineering, cybersecurity, compliance, DT, infrastructure, and business stakeholders.
• How to diagnose and resolve loading failures, resource contention, query degradation, and system level interruptions.
• How business rhythms translate into system needs related to scheduling, capacity planning, automation, and service-level commitments.

Qualifications YOU Must Have:

• Typically requires a University Degree and minimum 5 years prior relevant experience, or an Advanced Degree in a related field and minimum 3 years of experience.
• U.S. Citizen - U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.
• Experience with data warehouse and analytics platform administration
• Proficiency with modern data warehouse platforms (Snowflake, Redshift, BigQuery, Azure Synapse, Teradata, etc.).
• Experience with ETL/ELT tools (Informatica, dbt, Matillion, SSIS, Talend).
• Strong SQL skills, including performance tuning and optimization.
  Experience with Linux/Windows administration and cloud platforms (AWS, Azure, or GCP).
• Understanding data modeling, schema design, and relational database principles.
• Familiarity with automation tools, scripting languages, and CI/CD concepts.
• Strong analytical and problem-solving skills.
   

Qualifications We Prefer:

• Experience with BI tools (Power BI, Alteryx, Tableau, Business Objects).
• Background in data governance, cataloging tools, or metadata management.
• Experience with version control systems (Git) and infrastructure-as-code frameworks.
• Understanding of networking fundamentals and security best practices.
• Experience with data auditability, automated policy enforcement, or sensitive data handling.
• Knowledge of AI/ML data preparation or feature pipeline support.
• Experience with DevOps and IaC tools (i.e., Terraform, CloudFormation, GitHub Actions, Jenkins).
• Prior experience in aerospace, defense, manufacturing, or other regulated industries.

What We Offer:

• Some of our competitive benefits packages include: 
• Medical, dental, and vision insurance
• Three weeks of vacation for newly hired employees
• Generous 401(k) plan that includes employer matching funds
• Participation in the Employee Scholar Program (ESP)
• Life insurance and disability coverage
• Employee Assistance Plan, including up to 8 free counseling sessions
• And more!

Learn More & Apply Now!

Do you want to be part of a new, exciting initiative to combine foundational IT with new digital technologies?  Our Digital Technology team is driving business efficiencies and a better customer experience by connecting technologies, people, information and processes. From making aircraft more electric, intelligent and integrated to building new software platforms such as Internet of Things, big data, artificial intelligence, and blockchain, there’s no better place to be right now than in digital. If you’re an agile thinker who enjoys utilizing modern technology to make big improvements, then you’re a perfect fit for this team. Join Collins Aerospace to help us revolutionize the aerospace industry today!

* Please consider the following role type definitions as you apply for this role.

Hybrid: Employees who are working in Hybrid roles will work regularly both onsite and offsite.  Ratio of time working onsite will be determined in partnership with your leader.

Regardless of your role type, collaboration and innovation are critical to our business and all employees will have access to digital tools so they can work with colleagues around the world – and access to Collins sites when their work requires in-person meetings.

At Collins, the paths we pave together lead to limitless possibility. And the bonds we form – with our customers and with each other -- propel us all higher, again and again.   

Apply now and be part of the team that’s redefining aerospace, every day.

RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act.

Privacy Policy and Terms:

Click on this link to read the Policy and Terms