Data Warehouse Architect/Engineer

7 days ago


Maryland, United States Quantum Strides LLC Full time

Job Title: Hybrid Data Architects/Engineers

Location: 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 in the Washington DC metro area and has a workforce in the United States, Canada, and India, enabling us to serve clients across diverse geographical regions. We are a partner of choice for several Fortune 500 clients and large System Integrators.

About the Job:

The Hybrid Data Architects/Engineers will be responsible for designing and building data warehouse solutions, working with conventional data warehouse technologies to devise plans that support designing data warehouse solutions in alignment with the client's initiatives.

Key Responsibilities:

Design and build data warehouse solutions using conventional data warehouse technologies.

Develop plans to support designing data warehouse solutions in alignment with client initiatives.

Requirements:

Database and analytical skills.

Ability to query source data.

Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).

Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.

Strong analytical, consultative, and communication skills, as well as the ability to make good judgment and work with both technical and business personnel.

Preferred Skills:

BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.

Dimensional modeling, STAR schema design, Snow fake schema design, slowly changing dimensions, confirmed dimensions.

Designing and building BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, data mapping, monitoring performance, and communicating functional and technical issues.

Designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis.

Monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity.

Designing and implementing ETL procedures for intake of data from multiple source systems, ensuring data quality and cleansing is verified.

Normalization process.

Performing the design and extension of data marts, meta data, and data models.

Ensuring all data warehouse architecture codes are maintained in a version control system.

Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure data factory, SSIS, and stored procedures.

Advanced experience developing codes, testing for quality assurance, administering RDBMS.

High proficiency in dimensional modeling techniques and their applications.

Azures architecture to structure optimized data workflows.

The following tools: Power BI, Tableau, Azure Synapse, Azure Data Factory, Azure Blob Storage, Azure Databricks, Microsoft Fabric, One Lake.



  • 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...

  • 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: ...


  • Maryland Heights, Missouri, United States Saxon Global Full time

    OverviewSaxon Global is seeking a highly skilled Senior Engineering Architect to join our team in St. Louis. This individual will be responsible for designing and implementing software applications that meet the needs of our clients.


  • Maryland City, Maryland, United States The Johns Hopkins University Applied Physics Laboratory Full time

    About the RoleWe are seeking a highly skilled Principal Software Engineer and Architect to join our team at The Johns Hopkins University Applied Physics Laboratory (APL). This is an exciting opportunity to work on cutting-edge projects that impact national security, space, and science challenges.


  • 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...


  • 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...


  • Maryland City, Maryland, United States Leidos Full time

    Leidos is seeking an experienced Digital Transformation Architect to join our Defense Enclave Services (DES) team, who will support a critical digital modernization program for the Defense Information Systems Agency (DISA) and Department of Defense (DoD) Fourth Estate Agencies.About the RoleThe System Architect will work closely with Leidos and Government...


  • Maryland City, Maryland, United States Johns Hopkins Applied Physics Laboratory (APL) Full time

    Job Title: Senior Project ArchitectThe Johns Hopkins University Applied Physics Laboratory (APL) is seeking a talented Senior Project Architect to join our team. As a Senior Project Architect, you will play a crucial role in designing and constructing buildings that meet the needs of our nation's most critical defense, security, space, and science...

  • Claims Data Engineer

    4 months 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: ...


  • Maryland City, Maryland, United States Leidos Full time

    About LeidosLeidos, a leading provider of defense and security solutions, is seeking an experienced Network Architect Specialist to join our team at Ft. Meade, MD.OverviewThe Defense Enclave Services (DES) program is a highly demanding mission that requires expert technical and professional management to support DISA's enterprise Information Technology (IT)...

  • 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...


  • Maryland Heights, United States Spectrum Full time

    Spectrum’s Product and Technology team creates, develops, and operates the nation’s fastest mobile service, most reliable internet service, most viewed live TV app, and the most advanced WiFi, serving nearly 100 million users and 500 million devices. We are transforming the next era of connectivity and entertainment experiences. The diversity of...

  • Cloud Architect

    7 days 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...


  • Maryland City, Maryland, United States Insight Global Full time

    Job SummaryA top-tier cloud architect is sought after by Insight Global to lead our cloud infrastructure engineering efforts. This role requires a seasoned professional with extensive experience in designing and implementing cost-effective cloud solutions on the AWS platform.About the RoleWe are looking for an expert in cloud architecture to join our team....


  • 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...


  • Maryland City, Maryland, United States Dezign Concepts LLC Full time

    Dezign Concepts LLCEstimated Annual Salary: $130,000 - $160,000About the RoleWe are seeking an experienced Principal Systems Architect to join our team at Dezign Concepts LLC. As a key member of our systems engineering group, you will play a crucial role in designing and developing state-of-the-art solutions for our clients.Job Responsibilities:Analyze user...


  • Maryland Heights, Missouri, United States TEKsystems Full time

    Job OverviewTEKsystems is seeking a highly skilled Cloud Architect to join our team. This role involves designing, deploying, and implementing Private, Public, and Hybrid Cloud Technologies in accordance with industry best practices.About the RoleThis is an exciting opportunity for a cloud expert to work on customer-facing engagements, leading large...

  • 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...

  • Solutions Architect

    4 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!...


  • Maryland City, Maryland, United States Advantage Engineering & IT Solutions Inc Full time

    Job SummaryWe are seeking an experienced Senior Technical Systems Architect to join our team at Advantage Engineering & IT Solutions Inc.About the RoleThis is a full-time position that offers a comprehensive compensation package, including a salary of $120,000 per year, plus benefits.The successful candidate will be responsible for managing system...