Senior Data Architect

Position: Senior Data Architect

Pay: $140k-160k

Work Location: Remote

Benefits: 401(k) with matching, dental insurance, disability insurance, health insurance, vision insurance, life insurance, paid time off, 13 paid holidays.

Description: The Data Solutions Architect will support data modeling, integration, and business intelligence efforts within a government technology environment. This role will focus on analyzing data from multiple legacy systems and authoritative systems of record to help develop a common data model that supports consistent use of data across the environment. The selected candidate will work closely with developers, analysts, and project stakeholders to understand existing schemas, data relationships, business rules, and dependencies; develop and refine conceptual, logical, and physical data models; and establish mappings and transformation requirements between source data and the common model. The position will support data migration and integration activities within SQL and Azure-based data environments, including validating data quality, transformation results, relationships, and model accuracy as designs are implemented. This is a hands-on technical role that also supports adjacent data and business intelligence efforts, including solutions using Power BI and Microsoft Power Platform. The ideal candidate will be able to understand how data is structured within existing systems, translate functional and reporting needs into effective data models, and work with technical teams to carry those designs through validation and physical implementation.

Core Responsibilities:

• Analyze legacy systems and authoritative data sources to understand existing data structures, relationships, business rules, data flows, interfaces, and dependencies.
• Develop and document conceptual, logical, and physical data models, including relational structures, data dictionaries, source-to-target mappings, and data lineage.
• Support the development of a common data model across multiple source systems, identifying opportunities to standardize data structures, definitions, relationships, and business rules.
• Work with development teams to translate approved data models into physical database structures and support data integration, ETL/ELT, migration, validation, reconciliation, and data quality activities within SQL and Azure environments.
• Develop and support database views, standardized datasets, and other data structures used by applications, Power BI, Power Platform, interfaces, and analytical solutions.
• Collaborate with technical and functional stakeholders to validate model designs and implemented solutions, document decisions and dependencies, and communicate data-related risks, tradeoffs, and recommendations.