Data warehouse architect/engineer

By /

Data warehouse architect/engineer

Job Type : Contract C2C/W2

Visa Status : Any

Salary : Negotiable based on Experience

Job summary

Dhaka 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:

 Data Warehouse (DW) and ETL Process Design:

  • Active involvement in all aspects of designing, creating, and specifying components for DW and ETL processes.

Service Coordination:

  • Work with technical, functional, and management representatives to provide:
  • Source Data Model to DW Logical Design ERD:
  • Understand 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.

DW Schema Development:

  • Develop effective data warehouse models representing data entities based on analytical, reporting, and bulk data needs.

DW Physical Design:

  • Collaborate with the platform administration team to create a physical data warehouse design, focusing on data quality and operational efficiency.

Stakeholder Collaboration:

  • Work with business and technology stakeholders to ensure the development and effective utilization of data warehouse architecture.

Regulatory Compliance:

  • Ensure all work complies with regulatory standards to protect sensitive data.

Reporting:

  • 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 preferred
  • At 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:

Application Process : Interested candidates should submit their resume and cover letter to hr@dhakatech.us. Please include “Data Warehouse Architect/Engineers Application” in the subject line.

Are You interested?

Empowering innovation, building futures-join our IT revolution!





    Scroll to Top