> Markdown version of [/jobs/ext/1290356-data-warehouse-systems-administrator-puerto-rico](https://www.wearedevelopers.com/jobs/ext/1290356-data-warehouse-systems-administrator-puerto-rico). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Systems Administrator (Puerto Rico) - **Company:** RTX - **Location:** ISABEL, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Amazon Web Services, Business Analytics Applications, Microsoft Azure, BigQuery, Software Documentation, Cyber Security, Continuous Integration, Data Cleansing, Data Control, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Security, Data Systems, Data Warehousing, Relational Databases, Database Queries, Linux, DevOps, Disaster Recovery, Github, Meta-Data Management, Networking Basics, Operational Data Store, Performance Tuning, Power BI, SQL Server Integration Services, Tableau (Software), Talend, Teradata SQL, User Provisioning Software, Data Processing, Scripting, Data Ingestion, System Availability, Snowflake, Sap Business Objects, Git, Cloudformation, Infrastructure Automation Frameworks, Data Management, Terraform, Azure Synapse Analytics, Software Version Control, Data Pipelines, Jenkins, Alteryx, Amazon Redshift - **Published:** July 16, 2026 - **Apply:** https://globalhr.wd5.myworkdayjobs.com/REC_RTX_Ext_Gateway/job/US-PR-SANTA-ISABEL-B1--Felicia-Industrial-Park---St-B1--BLDG-1/Data-Warehouse-Systems-Administrator--Puerto-Rico-_01859527 ## About the Role * 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. ## Description 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., * 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. ## Related Videos - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Docker exec without Docker](https://www.wearedevelopers.com/videos/1094-docker-exec-without-docker) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)