Raytheon Technologies

Data Warehouse Systems Administrator (Puerto Rico)

Raytheon Technologies$75K — $95K *
Enterprise Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • University Degree with 5+ years experience or Advanced Degree with 3+ years experience.
  • Must be a U.S. citizen due to access restrictions.
  • Experience managing data warehouse and analytics platforms.
  • Proficiency in modern data warehouse platforms like Snowflake or Azure Synapse.
  • Experience with ETL/ELT tools such as Matillion or Informatica.
  • Strong SQL skills with a focus on performance tuning and optimization.
  • Familiarity with automation tools and scripting languages.

Responsibilities

  • Support administration and monitoring of data warehouse and analytics platforms.
  • Maintain ETL/ELT pipelines and job schedules across systems.
  • Contribute to BI support, user provisioning, and report performance.
  • Ensure system stability and availability through cross-platform monitoring.
  • Enforce security standards and sensitive data controls.
  • Assist with backup, recovery, and disaster recovery procedures.
  • Collaborate with cross-functional teams to optimize workflows and schemas.

Benefits

  • Medical, dental, and vision insurance
  • Three weeks of vacation for newly hired employees
  • Generous 401(k) plan with employer matching
  • Participation in the Employee Scholar Program (ESP)
  • Life insurance and disability coverage
  • Employee Assistance Plan offering up to 8 counseling sessions
  • And more!
Full Job Description
Date Posted:
2026-07-15
Country:
United States of America
Location:
US-PR-SANTA ISABEL-B1 ~ Felicia Industrial Park - St B1 ~ BLDG 1
Position Role Type:
Hybrid
U.S. Citizen, U.S. Person, or Immigration Status Requirements:
U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.
Security Clearance:
None/Not Required

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.

About Raytheon Technologies

Raytheon Solipsys, a wholly-owned subsidiary of the Raytheon Company, is an industry leader in the development of integrated Command and Control (C2) Network-Centric solutions for the Domestic and International DoD and Homeland Security. Through proven systems and software engineering practices, built on the invention and application of innovative technologies, they deliver the C2 infrastructure necessary to effectively control security/military forces in any environment. Their reliable solutions assure information superiority, increased shared awareness, deep sensor reach, aircraft control, air defense, disaster management, and time-critical decision making.

Raytheon Technologies Careers

Join the innovative world of Raytheon Technologies, a leader in aerospace and defense, where we offer unparalleled job opportunities in an environment that champions diversity, leadership, and professional growth.

Work You’ll Do

At Raytheon Technologies, you’ll be part of a company that values innovation and leadership. Our team is dedicated to solving some of the most complex challenges in aerospace and defense, making significant impacts worldwide. With a culture that fosters diversity and inclusion, you will collaborate with some of the brightest minds in the industry.

Transform Your Career

Step into a role that harnesses your skills and propels your career to new heights. Raytheon Technologies is not just about thinking big but making those big ideas happen. We provide robust career development opportunities that include comprehensive training and development programs, leadership workshops, and continuous learning through our internal platforms.

Innovate and Lead

Join our team of over 60,000 professionals globally, who are not only experts in their fields but are also driven by a passion for innovation and excellence. At Raytheon Technologies, you are positioned at the forefront of the industry, where your work directly contributes to groundbreaking advancements in technology and defense.

Internship and Employment Opportunities

Whether you’re starting your career or looking to advance, Raytheon Technologies offers a range of employment and internship opportunities that can help you achieve your professional goals. Our internships provide a solid foundation of skills and experiences, while our full-time positions offer a path to personal and professional growth within the company.

Benefits and Culture

Our employees enjoy a competitive package of benefits and rewards that reflect their invaluable role in our company. From health and wellness programs to performance bonuses and flexible working conditions, we ensure our team members are well taken care of.

Networking and Professional Development

At Raytheon Technologies, networking and professional development are part of our DNA. We encourage our employees to engage in internal and external networking events, leadership training, and diversity initiatives that enhance their career journey.

Join Our Team

Explore the numerous positions available that match your skills and interests. We are looking for passionate, curious, and solution-driven team players who are ready to take their career to the next level.

Stay Connected

Keep up to date with career tips, industry insights, and the latest innovations—all from the people who work here. Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences.

Prepare for Your Future

Ready to apply? Enhance your resume and prepare for your interview with our comprehensive support tools and resources. Discover the exciting and rewarding career opportunities that await at Raytheon Technologies.

SEARCH RAYTHEON TECHNOLOGIES JOBS

Join us in our mission to create a safer future and be a part of a team that values integrity, excellence, and teamwork. At Raytheon Technologies, your career is just the beginning of a lifelong journey of professional and personal growth.
Learn more about Raytheon Technologies
Size
14,771 employees
Market Cap
$32,494
Industry
Founded
1922
NASDAQ

Similar Jobs

More Jobs at Raytheon Technologies

More Enterprise Technology Jobs

Find similar Data Warehouse Systems Administrator (Puerto Rico) jobs: