Data Architect

1 week ago

Maryland Line, United States Barrow Wise Consulting, LLC Full time

Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.

Responsibilities:

The Data Architect will support Barrow Wise's CPS project and perform the following duties:

  • Enable the management and sharing of infectious disease data between Chicago Public Schools and the Health Department
  • Improvement of data quality (business processes, governance, systems/applications, etc.)
  • Efficiency of 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 (data fabric, active metadata, Data Lake, 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 the source data into the target warehouse and test final transformations
  • Maintain and create extensions to ODS
  • Assist in designing the data warehouse and ensure that 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
  • Work remotely
An ideal candidate has the following:
  • U.S. Citizenship
  • A Master's degree from an accredited college or university in computer science, data science, engineering, or related field, required 8 years of technology delivery experience with at least 7 years focus on database system architecture and design, including the following is required:
    • 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
  • Ability to socialize and communicate the technical architecture and design to business and developers
  • Expertise in BI and data warehousing principles, including data modeling, data quality
  • Extract/transform/load processes as they apply to data preparation for BI/ Analytic solutions
  • Expert level knowledge of T-SQL, Stored Procedures, Data Modeling, Views, and Functions
  • Ability to resolve performance issues
  • Ability to collaborate and excel in complex, cross-functional teams involving data scientists, business analysts, and stakeholders
  • Familiarity with the latest trends in data engineering and data management (APIs, data virtualization,
  • stream data integration, augmented data integration)
  • Familiarity with SQL Server database administration
  • Familiarity with modern ETL integration solutions (SSIS, Ab Initio, Datastage, Informatica, Azure Data
  • Factory)
  • Familiarity with K-12 Education is preferred


Join the team at Barrow Wise Consulting, LLC, for a fulfilling and engaging experience Our team is dedicated to providing innovative solutions to our clients in an ethical and diverse work environment. We offer competitive compensation packages, excellent benefits, and opportunities for growth and advancement. Barrow Wise is an equal opportunity, drug-free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LBGT are welcome to apply.

Our employees stand behind Barrow Wise's core values of integrity, quality, innovation, and diversity. We are confident that Barrow Wise's core values, business model, and team focus create positive career paths for our employees. Barrow Wise will continue to lead the industry in delivering new solutions to clients and persevere until the client is overjoyed.

  • Hybrid Data Architects/Engineers

    1 week ago

    Maryland Line, United States Quantum Strides LLC Full time

    About the job Hybrid Data Architects/Engineers Title: Hybrid Data Architects/Engineers Location: Maryland, USA (Hybrid) Quantum Strides LLC is a leader in Integrated Workplace Management Solutions (IWMS) space specializing in solutions for Real Estate and Asset management, Capital Projects, Space & Move management, Operations & Maintenance and...

  • Cloud Architect

    1 week ago

    Maryland Line, United States LCG Full time

    This job opportunity is part of an RFP process; candidates are invited to submit their resumes detailing relevant experience. Location: Bethesda, MD (Hybrid) LCG is a minority-owned technology consulting firm that has been a trusted partner to more than 40 federal agencies, including 21 of the 27 Institutes and Centers (ICs) at the National Institutes of...

  • Data Warehouse Architect/Engineer

    1 week ago

    Maryland, United States Quantum Strides LLC Full time

    Job Title: Hybrid Data Architects/EngineersLocation: Maryland, USA (Hybrid)Quantum Strides LLC is a leading provider of Integrated Workplace Management Solutions (IWMS) specializing in solutions for Real Estate and Asset management, Capital Projects, Space & Move management, Operations & Maintenance, and Sustainability Solutions.Our company is headquartered...

  • AWS Cloud infrastructure Architect

    1 week ago

    Maryland Line, United States Omni Inclusive Full time

    • Expert in Data center technology ( VMware/Hyper-V/Storage) • Management, maintenance, and optimization of cloud-based data center infrastructure, with a focus on AWS services. • Deploy, configure, and maintain virtualization technologies within the AWS cloud environment, ensuring scalability and performance. • Collaborate with cross-functional...

  • GCP Engineer

    4 months ago

    Maryland Line, United States Photon Full time

    Job DescriptionResponsibilities: Infrastructure as Code (IaC): Design, implement, and manage infrastructure as code using Terraform for GCP environments. Ensure infrastructure configurations are scalable, reliable, and follow best practices. GCP Platform Management: Architect and manage GCP environments, including compute, storage, and networking...

  • Cloud Security Engineer

    7 days ago

    Maryland Line, United States Convergenz Full time

    As a Cloud Security Engineer, you will work within our growing DevSecOps practice delivering features to support developing, testing, and monitoring secure cloud architectures for cloud migration, cloud optimization and cloud deployment. We are looking for candidates with 3-5 years experience with cloud platform services, cybersecurity and DevOps practices...

  • Chief Software Architect

    7 days ago

    Maryland City, Maryland, United States Secure Innovations LLC Full time

    About Secure Innovations LLCSecure Innovations LLC is a leading provider of innovative cybersecurity solutions, striving to become experts in the field by focusing solely on Cybersecurity. Our mission is to provide exceptional services while prioritizing our employees and customers. We believe in maintaining a strong work-life balance through employee...

  • Cyber Security Architect

    7 days ago

    Maryland City, Maryland, United States Secure Innovations LLC Full time

    Secure Innovations LLC is a cutting-edge company that focuses exclusively on cybersecurity. As a Cyber Security Architect, you will be working with a massively parallel enterprise platform built with Java and Open Source Software products, including Kubernetes, Hadoop, and Accumulo. The platform enables the execution of data-intensive analytics on a managed...

  • Senior Cloud Lead Developer

    1 week ago

    Maryland Line, United States LCG Full time

    Location: Bethesda, MD Required Clearance: Ability to obtain Public Trust Position Description: We are seeking a Senior Cloud Lead Developer is responsible for designing and deploying advanced cloud-based solutions using AWS, Azure, or GCP, focusing on data storage, processing, and analytics. This role involves collaborating with cross-functional teams to...

  • Azure Cloud Systems Administrator

    1 week ago

    Maryland Line, United States GovStaff Full time

    GovStaff is seeking an experienced Azure Cloud Systems Administrator for a permanent job opening we have in Aberdeen Proving Ground, MD. Hybrid work arrangement with 2 days per week in the APG, MD office and 3 days remote. Potential candidates must be within commuting distance or willing to relocate. The selected professional will be responsible for...

  • Mobile Implant Software Engineer

    3 weeks ago

    Maryland Line, United States REDLattice Full time

    Title: Mobile Implant Software Engineer Location: Maryland Position Overview: REDLattice is seeking an experienced Mobile Vulnerability Researcher with a strong background in Computer Network Operations (CNO) and software development. The ideal candidate will have extensive experience supporting the Department of Defense and the Intelligence community,...

  • Senior Systems Engineer

    1 week ago

    Maryland Line, United States LCG Full time

    This job opportunity is part of an RFP process; candidates are invited to submit their resumes detailing relevant experience. Location: Bethesda, MD (Hybrid) LCG is a minority-owned technology consulting firm that has been a trusted partner to more than 40 federal agencies, including 21 of the 27 Institutes and Centers (ICs) at the National Institutes of...

  • Solutions Architect

    5 days ago

    NORTH BETHESDA, Maryland, 20852, Montgomery County, MD, United States Sodexo Full time

    Unit Description: At Sodexo, we are at the forefront of innovation, leveraging cutting-edge technology to drive business success. We are seeking a highly skilled and motivated Solutions Architect - Enabling Services to join our dynamic team. If you are passionate about designing robust solutions and leading technical initiatives, we want to hear from you!...

  • Network Engineer, Mid

    1 week ago

    Maryland Line, United States LCG Full time

    This job opportunity is part of an RFP process; candidates are invited to submit their resumes detailing relevant experience. Location: Bethesda, MD (Hybrid) LCG is a minority-owned technology consulting firm that has been a trusted partner to more than 40 federal agencies, including 21 of the 27 Institutes and Centers (ICs) at the National Institutes of...

  • Chief Software Solutions Architect

    2 weeks ago

    Maryland Heights, Missouri, United States Spectrum Full time

    Spectrum is a dynamic and innovative company that offers a comprehensive compensation package to its employees. The estimated annual salary for this role is $125,000 - $175,000.As Chief Software Solutions Architect, you will play a crucial part in designing, developing, testing, modifying, implementing, and supporting software systems, including OLTP...

  • Cloud Architect

    3 months ago

    Maryland Heights, United States TEKsystems Full time

    Job DescriptionJob Description O-2790803** U.S. Citizens and GC Holders **Fully Remote but must be willing to travel 40% of the time.Top Skills:Must have at least 3 years of experience with Cloud Technologies (AWS, AZURE, Google)Experience with Automation and Infrastructure as Code concepts using tooling such as Terraform, Ansible, CloudFormation, etc Job...

  • AWS Cloud Infrastructure Expert

    7 days ago

    Maryland, United States Omni Inclusive Full time

    Expert in Cloud Technology: Omni Inclusive seeks a skilled Cloud Infrastructure Architect to manage, maintain, and optimize cloud-based data center infrastructure, focusing on AWS services. The ideal candidate will collaborate with cross-functional teams to design and implement cloud-based solutions, monitor and troubleshoot cloud infrastructure for...

  • Cyber Security Architect Lead

    1 week ago

    Maryland City, Maryland, United States Jacobs Full time

    As a Senior Software Engineer at Jacobs, you will play a pivotal role in supporting mission-critical projects that have a direct impact on the nation's security and intelligence mission.The role requires close collaboration with Blue Team operators to develop data collection and analysis tools. This involves reviewing and developing tool requirements before...

  • Plant Manager- Metal Fabrication

    1 month ago

    center line, United States LHH Full time

    LHH Recruitment Solutions is hiring a Plant Manager for a growing Metal Fabrication organization in Center Line, MI . As the Metal Fabrication Plant Manager, you will play a crucial role in fostering an environment aligned with The clients core values: openness and honesty, dependability, adaptability, taking ownership, and maintaining a positive attitude....

  • Plant Manager- Metal Fabrication

    1 month ago

    Center Line, United States LHH Full time

    LHH Recruitment Solutions is hiring a Plant Manager for a growing Metal Fabrication organization in Center Line, MI . As the Metal Fabrication Plant Manager, you will play a crucial role in fostering an environment aligned with The clients core values: openness and honesty, dependability, adaptability, taking ownership, and maintaining a positive attitude....