Hybrid Data Warehouse Admin - Secure Analytics (PR)

Prattwhitney; Santa Isabel (PR); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Vacation (3 weeks)

401(k) with employer matching

Employee Scholar Program (ESP)

Life insurance

Disability coverage

Employee Assistance Plan (EAP)

Job summary

RTX in Puerto Rico is seeking a hybrid Data Systems Administrator to support, optimize, and secure the enterprise analytics stack, including BI tools. The role requires U.S. citizenship for restricted access and residence in Puerto Rico.

You will maintain ETL/ELT pipelines, manage user provisioning, and ensure data security and compliance across Snowflake, Redshift, and related platforms. The ideal candidate has 5+ years of data warehouse experience, strong SQL, and experience with Matillion,

Qualifications

• University degree with minimum 5 years of relevant experience, or an Advanced Degree with minimum 3 years of experience.
• U.S. Citizenship is required for access to 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).
• 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.
• Willingness to learn and adapt to aerospace and defense–specific expectations for system hardening, data security, compliance, and audit readiness.
• Ability to collaborate across data engineering, cybersecurity, compliance, DT, infrastructure, and business stakeholders.

Responsibilities

• Support administration, configuration, and monitoring of the enterprise data warehouse and analytics platforms.
• 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.
• 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.

Skills

Data warehouse administration

SQL

Linux/Windows

Cloud platforms

CI/CD

Automation

Security governance

Collaboration

Education

Bachelor's degree

Advanced degree

Tools

Informatica

dbt

Matillion

SSIS

Talend

Job description

RTX in Puerto Rico is seeking a hybrid Data Systems Administrator to support, optimize, and secure the enterprise analytics stack, including BI tools. The role requires U.S. citizenship for restricted access and residence in Puerto Rico.

You will maintain ETL/ELT pipelines, manage user provisioning, and ensure data security and compliance across Snowflake, Redshift, and related platforms. The ideal candidate has 5+ years of data warehouse experience, strong SQL, and experience with Matillion,