Data Architect Senior

IT Advantage; United States; À distance; USD 130 000 - 190 000; Plein temps

Résumé du poste

IT Advantage seeks a Data Architect Senior to design and lead data integration across regulatory systems and a Databricks-based data platform, ensuring timely, trusted data for regulators and the public. You will define target-state architectures, model data across regulatory and geospatial domains, and guide API contracts, governance, and security in a fast-paced, agile team.

The role requires 7+ years in data architecture/engineering, hands-on Databricks experience, and strong collaboration

Qualifications

• Requires 7+ years in data architecture, data engineering, or data integration, with 3+ years in a data architect role.
• Extensive experience designing solutions on Databricks (Delta Lake, Spark, Unity Catalog).
• Strong data modelling across relational, dimensional, and lakehouse approaches.
• Experience with enterprise integration patterns including REST APIs, ETL/ELT, and change data capture.

Responsabilités

• Design enterprise data architectures and lead complex system integrations for regulatory programs.
• Architect lakehouse structures on Databricks and define data contracts and API specifications.
• Govern metadata, data quality, and security; ensure compliance with government standards.
• Mentor teammates and translate architecture into actionable user stories within Agile teams.

Connaissances

Data Architecture

Data Engineering

Data Integration

Databricks

Delta Lake

Spark PySpark/SQL

Unity Catalog

REST APIs

ETL/ELT

Event Streaming

Change Data Capture

Azure Data Platform

Data Governance

Metadata Management

Data Quality

RBAC / Security

Agile

Public Sector

Formation

University degree in Computer Science, Information Systems, Engineering, Geomatics, or related field

Outils

Databricks

Delta Lake

Spark

Unity Catalog

PowerDesigner

ER Studio

Er-win

Rational Rose

Description du poste

Data Architect Senior

We are seeking a Data Architect Senior to support a public sector environmental regulatory modernization initiative. This role will design and lead data integration between a regulatory system, a Databricks-based data management platform, and a geospatial platform. The focus is establishing trusted, timely, and reusable data for regulators, decision-makers, and the public. The ideal candidate will set the direction for how regulatory, environmental, and spatial data moves, connects, and is governed across these systems, working within a high-performing, multidisciplinary team in a fast-paced, agile environment.

This position requires someone who can design enterprise data architectures and lead complex system integrations to support a regulatory program. The role encompasses defining target-state data architecture across multiple platforms, designing conceptual, logical, and physical data models for regulatory and geospatial domains, and establishing integration patterns suited to each use case. Responsibilities include architecting lakehouse structures on Databricks with medallion layers and Delta Lake tables, designing spatial data flows that preserve geometry and coordinate reference systems, leading data pipeline design with data engineers and developers, defining data contracts and API specifications, resolving complex integration issues, embedding data governance practices including metadata management and lineage, ensuring compliance with government information security and privacy standards, defining data quality rules and monitoring approaches, applying role-based access controls, serving as a trusted advisor to program leadership and technical teams, coordinating with enterprise architecture and cybersecurity teams, producing architecture documentation and decision records, and mentoring team members on data architecture best practices. This role will participate in agile ceremonies and turn architecture into actionable user stories.

Qualifications

• University degree in Computer Science, Information Systems, Engineering, Geomatics, or a related field
• 7+ years - progressive experience in data architecture, data engineering, or data integration, with at least 3 years in a data architect role
• 3+ years - hands-on experience designing solutions on Databricks, including Delta Lake, Spark (PySpark/SQL), and Unity Catalog
• 5+ years - data modelling experience with relational, dimensional, and lakehouse approaches
• 5+ years - designing enterprise integration patterns, including REST APIs, ETL/ELT, event streaming, and change data capture
• 5+ years - cloud data platforms, preferably Microsoft Azure (Data Lake Storage, Data Factory, Event Hubs, Key Vault)
• Experience with ServiceNow Integration
• 3+ years - public sector experience, ideally with government regulatory systems or programs
• 3+ years - integrating with geospatial platforms and working knowledge of geospatial data concepts, formats, and standards
• Solid understanding of data governance, metadata management, data quality, and data security principles
• 3+ years - working in agile delivery teams in a public sector capacity
• Excellent communication skills with the ability to explain technical concepts to non-technical audiences
• Demonstrated systems thinking, creative problem solving, agility, drive for results, ability to build collaborative environments, develop networks, and develop self and others

Nice to Have

• Certification in The Open Group Architecture Framework (TOGAF)
• 5+ years - designing and implementing enterprise architecture database plans and models that align an organization's data, information or technology with required business capabilities in a large enterprise IT environment
• 4+ years - using architecture modelling tools such as PowerDesigner, ER Studio, Er-win, BPwin, or Rational Rose
• 4+ years - project managing application development projects using Agile sprint development
• 5+ years - cloud computing or big data platforms and infrastructure
• 4+ years - enterprise business intelligence and performance management products, specifically Cognos BI Suite, Microsoft SQL Server Services, MS Power BI (Query, View), or MicroStrategy
• 4+ years - working as a Data Architect designing and implementing enterprise database solutions within an organization of equivalent size and complexity
• 5+ years - developing SQL databases
• 5+ years - implementing a SQL data warehouse
• 5+ years - querying data with Transact-SQL
• 5+ years - prior experience with a large public sector organization