Lead Data Architect / DTAM / (Hybrid) [Contingent]

iWorks Corporation • ,

22d • $130,000 - $165,000 • Hybrid

About The Position

The Lead Data Architect serves as the senior technical authority responsible for defining the enterprise data architecture, database platforms, data engineering standards, and data integration strategy for the Decennial Transformation and Application Modernization (DTAM) program. This role provides technical leadership for modernizing enterprise data platforms and ensuring secure, scalable, and high-performing data ecosystems that support mission-critical Census operations. This role owns the architecture and technical direction for enterprise databases, data warehouses, data lakes, ETL/ELT pipelines, metadata management, and data governance. This position is contingent upon contract award.

Requirements

• 10-14 years of experience in enterprise data architecture, database architecture, data engineering, or related technical disciplines.
• Demonstrated experience leading enterprise-scale data modernization or database architecture initiatives.
• Deep expertise designing enterprise data architectures supporting relational databases, data warehouses, enterprise data lakes, and modern data platforms.
• Experience designing and implementing enterprise ETL/ELT pipelines and large-scale data integration architectures.
• Strong experience with Oracle, PostgreSQL, Amazon Aurora, Amazon Redshift, or comparable enterprise database technologies.
• Strong SQL and PL/SQL development and database optimization experience.
• Experience with enterprise data governance including metadata management, data lineage, data quality, master data management (MDM), and lifecycle governance.
• Experience integrating enterprise applications through APIs, data services, and data integration platforms.
• Experience supporting cloud, hybrid, and on-premise enterprise data environments.
• Ability to produce enterprise architecture documentation, data models, technical standards, and implementation guidance.
• Strong communication and leadership skills with experience collaborating across architecture, engineering, analytics, and security teams.

Nice To Haves

• AWS Data Analytics or Machine Learning Certifications
• Microsoft Azure Data Engineer or AI certifications
• Google Cloud Data Analytics or Professional Data Engineer certification
• Experience supporting federal government or large-scale mission-driven programs
• Exposure to AI/ML technologies including generative AI and large language models
• Experience with data privacy and security approaches (e.g., federated learning, differential privacy)

Responsibilities

• Serve as the technical lead responsible for enterprise data architecture, database standards, and data engineering strategy across the DTAM program.
• Define the architecture, standards, and governance for enterprise data platforms including relational databases, data warehouses, and enterprise data lakes.
• Lead the design and modernization of enterprise data architectures supporting cloud, hybrid, and on-premise environments.
• Architect and oversee scalable ETL/ELT pipelines, enterprise data integration solutions, and high-volume data processing workflows.
• Lead database architecture and optimization across Oracle, PostgreSQL, Amazon Aurora, Amazon Redshift, and enterprise data lake environments.
• Define enterprise standards for SQL, PL/SQL, database performance, data modeling, metadata management, and data lifecycle management.
• Establish enterprise data governance practices including data quality, lineage, metadata, master data management, retention, and compliance.
• Collaborate with the Lead Application Architect and Lead Application Developers to integrate enterprise applications with data platforms and APIs.
• Partner with the Lead Data Scientists to deliver trusted, high-quality data supporting analytics, reporting, AI/ML, and decision-support capabilities.
• Work with the Lead Systems Architect to ensure data platforms align with enterprise cloud architecture and infrastructure standards.
• Partner with the Lead Security Engineer to implement secure data architectures that satisfy federal security, privacy, and compliance requirements.
• Evaluate emerging database technologies, integration approaches, and modernization strategies to improve scalability, reliability, and operational efficiency.
• Produce architecture documentation, logical and physical data models, technical standards, and implementation guidance.
• Provide technical leadership, mentoring, and architectural oversight across multiple concurrent projects and engineering teams.

Benefits

• Medical
• Dental
• Vision
• Life and Disability
• 401(k)
• Health and Wellness Benefits
• Paid Sick Time
• Vacation Time
• Holiday Time
• Bonuses throughout the year as part of our incentive program for innovation and business development.
• Annual raise, commensurate with performance and company commitment.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed