Data Architect III

PROPERTY CONSULTING SERVICES GROUP, LLC
Kansas City, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Kansas City, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Automation of Tests
Bash
Continuous Integration
Command-Query Responsibility Segregation (Software Development)
Data Architecture
Data Governance
Data Hub
Data Infrastructure
Data Integration
Data Retrieval
Data Stores
Document-Oriented Databases
DNS
Identity and Access Management
Virtual Private Networks (VPN)
Python
Logical Data Models
Metadata
Peering
Prometheus
Data Streaming
TCP/IP
Scripting (Bash/Python/Go/Ruby)
Network Access Control
Cloud Platform System
Amazon Web Services (AWS)
Event Driven Architecture
Information Technology
Amazon Web Services (AWS)
Data Management
Route53
Cloudwatch
Terraform
Data Pipelines
Jenkins
Databricks
Microservices

Job description

This consulting position will report to a Data Architect Lead and will be responsible for implementing architecture patterns and designs across systems. They will engage in conceptual and logical data modeling, document database architecture, data integration, metadata and enablement of microservices and miniservice in an event driven architecture. At the direction of the Data Architect Lead champions organizational policies, procedures, and accepted data standards including data acquisition, access patterns, retention, movement, and security. Other duties could include supporting the Data Architect Lead in the buildout of reporting, analytics, and data science practices in the AWS cloud. Key responsibilities include:? Responsible for alignment and understanding of project requirements for data management.? Responsible for maintenance and extension of the conceptual and logical data models, including the party data model and the corresponding domain models supporting customer activities.? Responsible for establishing patterns for the integration of data from multiple source systems for consolidated views such as the customer 360.? Responsible for establishing data flow patterns in alignment with Command Query Responsibility Segregation (CQRS) supporting events, persistence and distribution.? Responsible for establishing persistence data stores for reliable system interfaces supporting microservices and miniservice capable of high performant data transfers.? Responsible for refining datasets based on data rationalization framework to iteratively refine and integrate them based on use cases to facilitate the migration of business processes to the event hub.? Responsible for refining reproducible integration, performance and growth patterns to support continued development of the data hub.? Responsible for organizing, structuring and storing data in sustainable method that improves usability, data accuracy and definition.? Responsible for establishing efficient data retrieval mechanisms and facilitation of self-service with reporting, analytics and data science, * Infrastructure & Networking

  • Design secure, scalable AWS environments using Multi-Account architectures.

  • Configure advanced AWS networking including VPCs, Transit Gateways, and Route53.

  • Establish secure connectivity via AWS Direct Connect and VPNs.

  • Implement strict Network Access Control Lists (NACLs) and Security Groups.

  • Migration of on-premises systems to AWS cloud services.

  • Perform regular updates and upgrades to AWS resources and services

  • Data Platform Engineering

  • Deploy and manage Databricks workspaces across multiple AWS environments.

  • Optimize Databricks clusters for performance, scalability, and cost.

  • Integrate Databricks with AWS data stores like S3, RDS.

  • Implement Unity Catalog for robust data governance and access control.

  • Automation & CI/CD

  • Write clean, reusable, and modular infrastructure code using Terraform.

  • Manage infrastructure state files securely in remote backends.

  • Design and maintain CI/CD pipelines using Jenkins for automated testing.

  • Automate the deployment of both AWS resources and Databricks assets.

  • Security & Operations

  • Implement IAM roles and policies following the principle of least privilege.

  • Monitor system health and performance using AWS CloudWatch and Prometheus.

  • Set up automated alerts for infrastructure anomalies and cost spikes.

  • Troubleshoot complex networking, deployment, and data pipeline failures.

Requirements

Bachelor''s Degree in Computer Science, Management Information Systems, Business Administration, Mathematics, or equivalent computer-related degree from an accredited college or university required. Other qualifications will be provided by the individual management team., * Cloud Platform: Advanced expertise in Amazon Web Services (AWS).

  • Data Tools: Hands-on administration of Databricks (Workspaces, Clusters, Unity Catalog).
  • Infrastructure as Code: Expert-level proficiency with Terraform.
  • CI/CD: Deep experience building and managing Jenkins pipelines.
  • Networking: Strong mastery of TCP/IP, DNS, VPC peering, and routing tables.
  • Scripting: Proficiency in Python, Bash

Apply for this position