• Work in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling and metadata repository creation • Work with Architects, Technical Leads and Business Teams and contributes to the development of technical designs • Secure data migrations & transformations to/from clients, customers, and vendors • Provides technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMS • Conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows • Migrate current ETL and SSIS packages to Synapse

• Your team will develop datasets that enable data visualization, machine learning and data driven decision making across client product line • Working with structured and unstructured datasets and automating data pipelines to ingest, analyze, validate, normalize and clean data in a hybrid multi-cloud environment • Building data ingestion pipelines from multiple data sources using Data Bricks and Apache Spark • Partnering with analysts, solution architects, modelers and developers to build data product and data pipelines. • Providing technical and thought leadership

• Lead hands-on development of data pipelines and data platform components, including writing and reviewing production-quality code • Own end-to-end delivery for assigned pipelines and services • Build, improve, and maintain ETL/ELT pipelines for large-scale data ingestion and transformation • Implement CI/CD and automated testing for data pipelines (integration tests, data validation, and release workflows) • Establish operational readiness for production data workflows • Optimize performance and cost of pipelines and storage through tuning, partitioning, and workload right-sizing in AWS GovCloud • Contribute to and implement modern data architecture patterns, including lakehouse approaches • Ensure architecture and implement support DoD strategic initiatives, including enterprise data modernization efforts • Drive creation and upkeep of data transformation roadmaps and technical documentation; support data maturity assessments and current-state analysis across agency-wide programs • Translate technical approaches into clear, business-understandable frameworks and recommendations. • Partner with cross-functional teams and program offices to understand data requirements, enable data-driven decision-making, and translate technical approaches into business-understandable frameworks and recommendations. • Support delivery of leadership priority initiatives (e.g., childcare forecasting, Military OneSource analytics, readiness dashboards) and design/implement data solutions that connect outreach efforts to program uptake and readiness outcomes, for users with varying technical proficiency levels

• Responsible for expanding and optimizing our data and data pipeline architecture • Support our software developers, database architects, data analysts and data scientists on data initiatives • Create and maintain optimal data pipeline architecture • Assemble large, complex data sets that meet functional / non-functional business requirements • Identify, design, and implement internal process improvements • Build the infrastructure required for optimal extraction, transformation, and loading of data • Build analytics tools that utilize the data pipeline • Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues • Create data tools for analytics and data scientist team members