Data Architect

1 day ago

Maryland, United States Barrow Wise Consulting, LLC Full time

About the Role:

We are seeking a highly skilled Data Architect to support our CPS project and lead the development of our data architecture and data query performance optimization. The ideal candidate will have a strong background in database system architecture and design, with experience in performance tuning techniques, API and web service implementation, and cloud data warehouse technologies.

Key Responsibilities:

  • Enable the management and sharing of infectious disease data between Chicago Public Schools and the Health Department
  • Improve data quality through business processes, governance, systems/applications, and data modeling
  • Optimize public health response to disease outbreaks for Chicago Public School students
  • Define and implement the long-term technology strategy and innovations roadmaps across analytics, data engineering, and data platforms
  • Create standards, design patterns, and best practices for ETL development in an enterprise data warehouse environment
  • Oversee the expansion of existing data architecture and data query performance optimization
  • Assist with identifying future state architecture, including data fabric, active metadata, Data Lake, and Data Lakehouse
  • Perform current state data model assessments, target data models, and gap analysis
  • Propose new database architecture and support data migration from an existing Legacy system to a new structure
  • Create source-to-target mapping documents to transform source data into the target warehouse and test final transformations
  • Maintain and create extensions to ODS
  • Assist in designing the data warehouse and ensure data is stored and maintained in consistent formats
  • Counsel Analysts and Subject Matter Experts on specific topics to accurately capture existing business rules/principles
  • Establish data modeling naming standards, abbreviations, guidelines, and best practices
  • Develop and maintain conceptual, physical, and logical data models
  • Drive best practice solutions for data in a collaborative environment
  • Provide insight and strategies for data architecture solutions
  • Coordinate with a Solutions Architect to find the best data solution and workflows to support projects
  • Lead architectural design and strategy discussions
  • Utilize various ETL tools, including MS SSIS and Ab Initio
  • Perform ETL transformations between data stored in MS SQL Server Management Studio, Azure SQL Database, Oracle databases, and ServiceNow
  • Utilize scripting languages, Bash, PowerShell, Google Script, C#, and Python
  • Perform AppWorx workload automation
  • Perform data profiling and data modeling of both dimensional and non-dimensional data in 3NF

Requirements:

  • U.S. Citizenship
  • A Master's degree from an accredited college or university in computer science, data science, engineering, or related field
  • 8 years of technology delivery experience with at least 7 years focus on database system architecture and design
  • Experience producing high-quality Solution architecture and design documents
  • Experience leading projects involving data warehousing, data modeling, and data analysis
  • Hands-on experience in performance tuning techniques
  • Experience with API and web service implementation (REST, API, SOAP API)
  • Experience with Cloud data warehouse technologies (Azure Data Warehouse, Amazon Redshift, Snowflake)
  • Experience with business intelligence tools and technologies such as ETL, Power BI, and Tableau

About Us:

Barrow Wise Consulting, LLC is a leading provider of innovative solutions to our clients. We are committed to delivering high-quality services and fostering a diverse and inclusive work environment. We offer competitive compensation packages, excellent benefits, and opportunities for growth and advancement.

  • Data Architect

    1 month ago

    Maryland, United States SW Complete Full time

    Job DescriptionAt Synergy ECP, we are seeking a skilled Data Architect to join our team. As a key member of our data architecture team, you will be responsible for developing logical and conceptual data models that meet the needs of our mission organizations.Key Responsibilities:Develop logical and conceptual data models using a local model methodologyCreate...

  • Data Architect

    1 week ago

    Maryland, United States Barrow Wise Consulting, LLC Full time

    Job Summary:Barrow Wise Consulting, LLC is seeking a highly skilled Data Architect to lead our team in delivering innovative solutions to our clients. As a Data Architect, you will be responsible for designing and implementing data architectures that meet the needs of our clients.Key Responsibilities:Design and implement data architectures that meet the...

  • ServiceNow Architect

    3 weeks ago

    Maryland City, United States Epis Data Inc Full time

    Title: ServiceNow Architect, (Senior)Location: Maryland - On-Site Duration: Long TermExperience: 9 Yeas Description: Architect, configure, and customize the ServiceNow platform to meet the organization's specific needs and requirements from multiple teams within the organization. Define and manage data structures, such as tables, fields, and relationships....

  • Senior Data Architect

    3 weeks ago

    Maryland Heights, Missouri, United States TechnoGen Full time

    Job Title: Lead Solutions ArchitectAt TechnoGen, we are seeking a highly skilled Lead Solutions Architect to join our team. As a key member of our organization, you will be responsible for assessing and advocating data management technologies and practices to eliminate gaps between the current state and a well-targeted future state.Key...

  • GCP Cloud Architect

    24 hours ago

    Maryland, United States Photon Full time

    Job Title: GCP Cloud ArchitectAbout the Role:Photon is seeking a highly skilled GCP Cloud Architect to join our team. As a GCP Cloud Architect, you will be responsible for designing, implementing, and managing infrastructure as code using Terraform for GCP environments. You will ensure infrastructure configurations are scalable, reliable, and follow best...

  • Cloud Architect

    2 days ago

    Maryland, United States LCG Full time

    Job Title: Cloud ArchitectJob Overview:The Cloud Architect is responsible for designing, managing, and optimizing the organization's cloud systems and applications. This role involves evaluating cloud solutions, developing scalable architectures, and ensuring security and compliance across cloud environments.The Cloud Architect will collaborate with...

  • AWS Cloud Infrastructure Architect

    3 weeks ago

    Maryland, United States Omni Inclusive Full time

    Job Title: AWS Cloud Infrastructure ArchitectWe are seeking a highly skilled AWS Cloud Infrastructure Architect to join our team at Omni Inclusive. As a key member of our cloud team, you will be responsible for designing, implementing, and managing cloud-based data center infrastructure on AWS.Key Responsibilities:Design and implement cloud-based data center...

  • Senior Database Architect

    7 days ago

    Maryland, United States LCG Full time

    Job Title: Senior Database ArchitectThis is a unique opportunity to join LCG, a minority-owned technology consulting firm, as a Senior Database Architect. The successful candidate will be responsible for designing, building, and maintaining databases that support data storage and processing across the organization.Key Responsibilities:Design, build, and...

  • AWS Cloud Infrastructure Architect

    7 days ago

    Maryland, United States Omni Inclusive Full time

    Job Title: AWS Cloud Infrastructure ArchitectAbout the Role:At Omni Inclusive, we're seeking a highly skilled AWS Cloud Infrastructure Architect to join our team. As a key member of our cloud infrastructure team, you will be responsible for designing, implementing, and maintaining scalable and secure cloud-based data center infrastructure on AWS.Key...

  • AWS Cloud Solutions Architect

    6 days ago

    Maryland, United States Spatial Front Full time

    Job Title: AWS Cloud Solutions ArchitectSpatial Front Inc. is seeking a highly skilled AWS Cloud Solutions Architect to design and deploy cloud-based solutions leveraging front-end frameworks and conversational AI services.The ideal candidate will have extensive experience with AWS services, including AWS Lambda, SageMaker, and AWS Bedrock, as well as...

  • Network Systems Architect

    1 month ago

    Maryland, United States SAIC Full time

    About the RoleSAIC is seeking a highly skilled Solution Architect to support the Department of Air Force's Advanced Battle Management System's Digital Infrastructure, Deployable Digital Infrastructure Product Team.Key ResponsibilitiesDesign and implement innovative solutions to deliver results to warfighters, leveraging the latest DevSecOps resources and...

  • Network Systems Architect

    1 week ago

    Maryland, United States SAIC Full time

    Job SummarySAIC is seeking a highly skilled Solution Architect to support the Department of Air Force's Advanced Battle Management System's Digital Infrastructure. The successful candidate will drive innovative solutions to deliver results to warfighters, leveraging the latest in DevSecOps resources and scalable cloud and bare metal microservices.Key...

  • Network Systems Architect

    4 weeks ago

    Maryland, United States SAIC Full time

    About the RoleSAIC is seeking a highly skilled Solution Architect to support the Department of Air Force's Advanced Battle Management System's Digital Infrastructure, Deployable Digital Infrastructure Product Team.Key ResponsibilitiesDesign and implement innovative solutions to deliver results to warfighters, leveraging the latest DevSecOps resources,...

  • Network Systems Architect

    4 weeks ago

    Maryland, United States SAIC Full time

    About the RoleSAIC is seeking a highly skilled Solution Architect to support the Department of Air Force's Advanced Battle Management System's Digital Infrastructure Product Team. As a key member of our team, you will play a critical role in designing and implementing innovative solutions to deliver results to warfighters.Key ResponsibilitiesDrive the...

  • SAP S/4HANA CVI Solution Architect

    4 weeks ago

    Maryland, United States Centraprise Full time

    Job Title: CVI Solution Architect with SAP S4 BackgroundJob Summary:We are seeking a highly skilled CVI Solution Architect with a strong background in SAP S4 to join our team at Centraprise. As a key member of our implementation team, you will be responsible for managing the integration of customer and vendor data into the SAP S/4HANA system, ensuring...

  • Cloud Architect

    3 weeks ago

    Maryland Heights, Missouri, United States TEKsystems Full time

    Job Title: Cloud ArchitectWe are seeking a highly skilled Cloud Architect to join our team at TEKsystems. As a Cloud Architect, you will be responsible for designing, deploying, and implementing cloud-based solutions for our clients.Responsibilities:Work with sales engineers and cloud consultants to review and validate customer requirements and translate...

  • AWS Cloud Solutions Architect

    2 days ago

    Maryland, United States Spatial Front Full time

    Job Title: AWS Cloud Solutions ArchitectSpatial Front Inc. is seeking a highly skilled AWS Cloud Solutions Architect to join our team. As a key member of our cloud architecture team, you will be responsible for designing, deploying, and managing cloud-native solutions on AWS.The ideal candidate will have extensive experience with AWS services, including AWS...

  • Senior Application Architect

    5 days ago

    Maryland, United States CAI Full time

    Job SummaryAs a seasoned Applications Architect, you will play a pivotal role in the implementation of the Mobile Application by providing expert application integration and deployment services. Your responsibilities will include development, configuration, and testing, as well as deployment of the code to production environments for the applicable...

  • Cloud Solutions Architect

    3 weeks ago

    Maryland Heights, Missouri, United States TEKsystems Full time

    Job Title: Cloud ArchitectWe are seeking a highly skilled Cloud Architect to join our team at TEKsystems. As a Cloud Architect, you will be responsible for designing, deploying, and implementing Private, Public, and Hybrid Cloud Technologies in accordance with industry best practices.Key Responsibilities:Work with Sales engineers/Cloud consultants to review...

  • System Architect

    10 hours ago

    Maryland, United States Modern Technology Solutions Inc Full time

    Job SummaryModern Technology Solutions Inc is seeking a highly skilled System Architect to lead the development of complex hardware/software systems. The ideal candidate will have a strong background in system engineering, with experience in requirements elicitation, analysis, and functional allocation. The successful candidate will be responsible for...