Job Details

Data Warehouse Architect
About the Role
CrossTech is seeking an experienced ETL Developer / Data Warehouse Architect to support the design, implementation, and expansion of its secure enterprise data analytics environment. This is a hands-onconsulting role that combines deep technical execution with architectural leadership. The selected consultant will help modernize ETL processes, design scalable data warehouse solutions, support structured and unstructured data ingestion, enable business intelligence and Tableau reporting, and facilitate secure inter-agency data exchanges. This role is fully remote.
This position requires advanced expertise in SQL, ETL design, and data modeling within a government analytics environment.
Job Description
The ETL Developer / Data Warehouse Architect will be responsible for supporting enterprise data architecture, ETL modernization, analytics enablement, and secure data integration across internal and external systems.
Data Architecture & Warehouse Development

• Review and analyze existing ETL processes and data ingestion pipelines
• Architect a scalable data warehouse framework aligned to audit analytics needs
• Design systems to accept structured and unstructured datasets
• Implement and migrate ETL environments, including fact and dimensional models
• Support dimensional modeling aligned to user story business requirements
• Develop enterprise data models supporting fraud detection and analytics workflows
• Optimize warehouse structures for audit, analytics, and reporting use cases

• Develop and maintain ETL processes integrating:
  • Flat files
  • Direct database connections
  • XML transactions
  • External agency data feeds
• Implement ETL pipelines using tools such as Qlik and Informatica
• Perform SQL and PL/SQL development to support transformations
• Support ingestion of newly identified/acquired datasets
• Maintain data interchange systems connecting varied internal and external systems
• Ensure secure transfer and validation of inter-agency data exchanges

• Support Tableau and Oracle Business Intelligence Enterprise Edition (OBIEE) dashboard development
• Design ETL processes optimized for Tableau visualization environments
• Assist with Tableau Server administration (preferred)
• Collaborate with business stakeholders to translate user stories into analytics datasets
• Ensure BI layer performance and data accuracy

• Partner with auditors and analytics staff to validate datasets
• Troubleshoot data discrepancies and transformation issues
• Support data quality initiatives and validation processes
• Apply statistical techniques to support fraud detection and performance analytics
• Assist in developing analytics-ready datasets

• Assist in building out OSC's secure data analytics infrastructure
• Support migration of ETL environments
• Align ETL pipelines to security and governance standards
• Ensure data architecture aligns with audit compliance and enterprise fraud prevention protocols

• Bachelor's degree in Computer Science or related IT field or
  Master's/Doctorate in Computer Science or related field
• 4+ years developing and maintaining data interchange systems integrating:
  • Flat files
  • Direct DB connections
  • XML transactions
• 4+ years working with ETL tools (Qlik, Informatica, or equivalent)
• 4+ years of data modeling experience (dimensional modeling, fact tables, star schemas)
• 4+ years building ETL environments supporting data analytics
• 4+ years coding in SQL

• Python scripting experience
• Tableau Server administration
• Experience gathering business requirements and validating data with customers
• Formal statistics coursework or professional experience applying statistics
• PL/SQL development experience
• Experience building ETL environments supporting Tableau
• Government data analytics experience
• Experience supporting audit or fraud analytics initiatives
• Experience with secure data environments and compliance-driven data governance