Hybrid Data Architects/Engineers

Quantum Strides LLC; Maryland; On-site; USD 90,000 - 130,000; Full time

Job summary

A leader in data management solutions is seeking a Hybrid Data Architect/Engineer for their Maryland office. The ideal candidate will design and build data warehouse solutions, ensuring effective communication with both technical and business teams. Strong experience in SQL, ETL tools, and Azure technologies is required. This role offers an opportunity to work with Fortune 500 clients and leads in the Integrated Workplace Management Solutions space.

Qualifications

• Ability to query source data.
• Write optimized SQL queries and manage databases.
• Designing and implementing database models and ETL procedures.

Responsibilities

• Design and build data warehouse solutions using conventional technologies.
• Collaborate with technical and business personnel to design data architectures.
• Monitor and optimize data systems and infrastructure.

Skills

Database and analytical skills

Knowledge and experience with ETL tools

Strong analytical and communication skills

Experience with BI best practices

Knowledge of scripting languages like Python

Tools

Power BI

Azure Synapse

Azure Data Factory

SQL Server 2016+

Job description

Overview

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 Sustainability Solutions. Headquartered in the Washington DC metro area Quantum Strides has workforce in the United States, Canada and India helping us serve our clients across diverse geographical regions. We are a partner of choice for several Fortune 500 clients and large System Integrators.

Learn more about us at: www.quantumstrides.com

The Hybrid Data Architects/Engineers will provide Data Warehouse Architect/Engineer services to serve as the primary resource(s) responsible for designing and building a data warehouse solution and working with conventional data warehouse technologies to devise plans that support designing data warehouse solutions in alignment with the client\'s initiatives.

Responsibilities

• Design and build data warehouse solutions using conventional data warehouse technologies in alignment with client initiatives.
• Collaborate with technical and business personnel to design data architectures that meet requirements.
• Maintain effective working relationships with peers, end users, vendor development staff, and management at all levels.
• Prototype and evaluate new technologies as needed and provide guidance on adoption.
• Write optimized SQL queries and manage databases, with frequent interaction with Azure SQL database and other SQL-based services.

Qualifications

• Database and analytical skills.
• Ability to query source data.
• Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing XML and SQL.
• Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.
• Strong analytical, consultative, and communication skills; ability to make good judgments and work with both technical and business personnel.
• Ability to work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and personnel.
• Critical thinking and problem solving; effective communication and mentoring needs; ability to learn and prototype new technologies quickly.
• Write optimized SQL queries and manage databases; Azure data analysts frequently interact with Azure SQL database and other SQL-based services.
• Experience with BI best practices, relational structures, dimensional data modeling, SQL skills, data warehouse and reporting techniques.
• Dimensional modeling, STAR schema design, Snowflake schema design, slowly changing dimensions, confirmed dimensions.
• Designing and building BI solutions by monitoring and tuning queries and data loads, addressing data integrity questions, data mapping, monitoring performance and communicating issues.
• Designing and implementing database models, schemas, 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 and ensuring data quality and cleansing.
• Normalization process.
• Extending data marts, metadata, and data models.
• Maintaining all data warehouse architecture codes in a version control system.
• Advanced experience with SQL Server 2016+ and with Azure Data Factory, SSIS and stored procedures.
• Advanced experience developing code, testing for quality assurance, and administering RDBMS.
• High proficiency in dimensional modeling techniques and their applications.
• Azure architecture understanding to structure optimized data workflows.
• Tools: Power BI, Tableau, Azure Synapse, Azure Data Factory, Azure Blob Storage, Azure Databricks, Microsoft Fabric, One Lake.