Data Architect, Lead

Job Number: R0246248

About the role

For an organization to transform in today’s digital world, it needs to properly collect, store, and organize its data. Effective data management can enable more efficient operations, yielding more growth. As a data architect, you know how to apply your creative-thinking and analytical mindset to help organizations manage their data assets. We’re looking for a data architecture lead like you to solve complex challenges and deliver leading-edge solutions for the Army. As a data architect on our Army Data Engineering team, you’ll use your extensive technical expertise to lead the design of data architecture solutions for integrating data pipelines from numerous Army intelligence sources. You’ll resolve complex data architecture-related issues in collaboration with business analysts and technology teams by analyzing data models and tools to provide a comprehensive view of available intelligence. In this role, you’ll share your technical expertise, introduce best practices, recommend, and use advanced tools for data warehousing, ETL processes, SQL, SSIS, and OLAP (Online Analytical Processing). You’ll lead your team as it designs, defines, develops, and tests cloud solution components, and you’ll serve as a liaison between clients and developers to ensure that requirements are met and solutions are delivered. With your motivation to establish processes and facilitate technological innovation, you’ll make a lasting impact on how the Army takes advantage of its intelligence sources. Join us. The world can’t wait.

Responsibilities

• Lead the design of data architecture solutions for integrating data pipelines from numerous Army intelligence sources.
• Resolve complex data architecture-related issues in collaboration with business analysts and technology teams by analyzing data models and tools to provide a comprehensive view of available intelligence.
• Share technical expertise, introduce best practices, recommend, and use advanced tools for data warehousing, ETL processes, SQL, SSIS, and OLAP (Online Analytical Processing).
• Lead your team as it designs, defines, develops, and tests cloud solution components.
• Serve as a liaison between clients and developers to ensure that requirements are met and solutions are delivered.
• Establish processes and facilitate technological innovation to impact how the Army leverages its intelligence sources.

Requirements

• 8+ years of experience in data architecture, data engineering, or analytics engineering, including ownership of enterprise or program-level data models for secure DoD information management systems.
• 8+ years of experience with SQL and database, including data modeling (dimensional modeling, normalization, schema design), query optimization, and working with relational databases and cloud data platforms.
• Experience with Python data frameworks for data processing, transformation, and automation.
• Experience designing and governing data architectures in AWS-based environments.
• Experience assisting with establishing and enforcing data governance practices, data quality frameworks, metadata management, data cataloging, lineage, and access policies.
• Experience with ETL and ELT processes and modern data