Position: Data Warehouse Architect/Engineer
Company: Trust Sourcing
Category: Data Engineer
Experience required: 5y
English level: upper
Published: 2023-07-01T00:00:00+03:00

This is a remote position.

We are a leading blockchain technology corporation. Our mission is to drive global adoption of blockchain services, and we're already recognized as a world leader in Bitcoin Infrastructure. With a worldwide team led by industry experts, we're expanding the reach of blockchain to shape a better future.

We're looking for a temporary Data Warehouse Architect/Engineer specializing in Azure Synapse, Analysis Services, and Power BI. The successful candidate will lead the development of enterprise-scale analytics systems and data warehouses based on Azure Architecture. You'll need deep knowledge and experience in Data Architecture, Data Warehouse Concepts, and large-scale Reporting and Analytical systems.

 

**Role and Responsibilities**

- Thoroughly comprehend both current and future requirements, actively participate in and lead discussions to provide clarity, extract detailed information, and contribute positively to the overall quality of the project. 

-  Create comprehensive designs for the overall system and its subsystems, and develop detailed design documents that outline the implementation plan for the entire team. Review, obtain approval from all stakeholders, and establish clear expectations for project execution. 

- Actively collaborate with relevant stakeholders and the product manager throughout all stages of the project lifecycle – from requirements gathering and solution design reviews to development, testing, UAT, delivery, and support. 

- Drive innovative solutions in design, leveraging the latest best practices in Data Warehousing, Data Analytics, and the Azure Cloud platform.

- Adhere to and implement industry best practices across all facets of the project delivery.

-  Ensure the design proposal makes a balanced trade-off across schedule, cost, technology, security, and compliance requirements.

- Guarantee that design proposals account for a balanced trade-off among key factors such as schedule, cost, technology, security, and compliance requirements.

- Be prepared to actively participate in development efforts at all levels, whether that means assisting other developers or personally contributing to ensure project momentum.

- Serve as a mentor to a team of engineers, including database developers, analytics experts, and data integration/visualization engineers. Provide both technical and non-technical guidance to enhance their skills and ensure the delivery of high-quality implementations for successful project completion. 

- Establish and rigorously enforce best practices for data systems development across all projects, incorporating process, education, training, and thorough review mechanisms. 

**Requirements**

- 8-10 years of relevant experience in architecting, designing, and developing data warehouse systems (SQL Server based on Cloud/on-premise and Analytics) at the enterprise level. Additional experience in a technical leadership role is required.

- Proven track record in building end-to-end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.

- Demonstrated experience in developing Data platforms using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, and Azure IaaS/PaaS related to the database.

- Proven experience in building data warehouse/analytical systems using Azure Synapse product, Power BI Architecture, and BI Report delivery using PowerBI, Tableau, or QlikView.

- Strong experience in Performance Tuning / Optimization Initiatives using DB Profiler tools.

- Blockchain or Financial domain experience, including specific industry standards or practices and familiarity with relevant regulatory and compliance requirements