Data Warehouse Systems Administrator (Puerto Rico)
RTX•Aguadilla, PR
•Hybrid
About The Position
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
Requirements
- 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.
Nice To Haves
- 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.
Responsibilities
- 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.
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
