Senior Data Warehouse Architect | TS/SCI Clearance

Redhorse Corp.; Huntsville (AL); On-site; USD 140,000 - 160,000; Full time

Job summary

Redhorse Corporation is seeking a Database Developer to lead the evolution and maintenance of high-performance data warehouses for government data initiatives. You will architect infrastructure and ensure data is accessible, verified, and ready for mission-critical analysis.

Required: Active TS/SCI with Polygraph, a BS in CS/IT, 8+ years’ experience in database development and data warehousing, and strong SQL and data modeling skills.

Qualifications

• Bachelor’s Degree in Computer Science, Information Technology, or a related field.
• 8+ years of professional experience in database development and data warehousing.
• Strong SQL skills and advanced data modeling techniques.
• Experience designing, constructing, and deploying enterprise-scale data warehouses.
• Experience with data verification and validation methods.

Responsibilities

• End-to-end data warehouse design and construction for large-scale government initiatives.
• Maintain and optimize enterprise data warehouse performance.
• Develop ETL/ELT pipelines for seamless data flow.
• Collaborate with stakeholders to translate mission requirements into scalable architectures.
• Ensure data integrity through rigorous verification and testing.
• Integrate the data warehouse with analytics and visualization tools.

Skills

SQL

Data Modeling

ETL/ELT

Data Warehousing

Performance Tuning

Stakeholder Collaboration

Education

Bachelor's Degree in CS/IT

Tools

Databricks

Snowflake

Apache Spark

GitLab

Jira

Python

Scala

Job description

Redhorse Corporation is seeking a Database Developer to lead the evolution and maintenance of high-performance data warehouses for government data initiatives. You will architect infrastructure and ensure data is accessible, verified, and ready for mission-critical analysis.

Required: Active TS/SCI with Polygraph, a BS in CS/IT, 8+ years’ experience in database development and data warehousing, and strong SQL and data modeling skills.