Data warehouse architect/engineer

Data Warehouse Architect/EngineerDhaka Technologies Limited is looking for two (2) Data Warehouse Architect/Engineers for a client in Annapolis, Maryland. This is a Hybrid Full Time position.Essential Functions:Active involvement in all aspects of designing, creating, and specifying components for DW and ETL processes.Work with technical, functional, and management representatives to provide:Source Data Model to DW Logical Design ERDUnderstand the current data structure and star schema models.Create a logical data warehouse design.Collaborate with the platform administration team to design and document the ETL process, including system architecture and requirements.Assist in the development, implementation, and testing of ETL tools.Develop effective data warehouse models representing data entities based on analytical, reporting, and bulk data needs.Collaborate with the platform administration team to create a physical data warehouse design, focusing on data quality and operational efficiency.Work with business and technology stakeholders to ensure the development and effective utilization of data warehouse architecture.Ensure all work complies with regulatory standards to protect sensitive data.Provide weekly progress reports on programs and projects.Communicate project progress and status weekly.Submit additional reports as required by the supervising manager.Skills, Experience, & Capabilities:Meet the following minimum qualifications:Bachelor's degree in computer science, Information Technology, Engineering, or a related field. A master's degree is preferredAt least 5 years of experience in data warehouse architecture, design, and development.Proficiency in querying source data.Experience in the design and extension of data marts, metadata, and data models.Ensuring all data warehouse architecture codes are maintained in a version control system.Advanced experience in developing codes, quality assurance testing, and administering RDBMS.Proficient in structuring optimized data workflows within Azure's architecture.Experience with ETL tools, Visual Studio, and managing XML and SQL.Knowledge of scripting languages (e.g., Python) for task automation in Azure.Strong ability to write optimized SQL queries and manage databases, especially in Azure SQL and other SQL-based services.Advanced experience with SQL Server 2016+, Azure Data Factory, SSIS, and stored procedures.Proficiency in dimensional modeling techniques (STAR schema, Snowflake schema, etc.).Familiarity with BI best practices, relational structures, dimensional data modeling, and reporting techniques.Ability to design and build BI solutions, including query and data load optimization, and addressing data integrity issues.Experience in designing and implementing database models and schemes for efficient data storage, retrieval, and analysis.Skills in monitoring and optimizing data systems for performance, scalability, and integrity.Proficiency in ETL procedures, data quality verification, and normalization processes.Experience with Power BI, Tableau, Azure Synapse, Azure Data Factory, Azure Blob Storage, Azure Databricks, Microsoft Fabric, and One Lake.Strong analytical, consultative, and communication skills.Ability to work effectively with peers, end users, vendor staff, and all management levels.Capabilities in critical thinking, problem-solving, and mentoring.Quick learning and prototyping of new technologies.How to Apply:Interested candidates should submit their resume and cover letter to View email address on click.appcast.io. Please include "Data Warehouse Architect/Engineers Application" in the subject line.