In this position, you will be responsible for data architecture design, work closely with our software and application development teams to recommend structure of our databases and warehouses built on MS SQL Server instances, as well as MS Azure environment to collect, store and deliver most optimal datasets to our Business Analysts to perform their analyses and create outstanding PowerBI dashboards in Azure service.
On daily basis, you will study end users and project needs, as well as asses data infrastructure and its implementation to provide insight into architecture changes. You will develop database design, often in cooperation with a project team, to ensure that E2E business requirements are met. Part of your responsibilities will be administration for new and existing database systems. You will be responsible for constantly monitoring our dataflow and immediately addressing databases issues and problems. On top of project related involvements, you will create and maintain a data architecture documentation and security guidelines. You will also play a key role to identify trends in the database usage and use this information to improve performance and security and recommend new ways to improve the existing database
We work with:
MS SQL Server 2016, 2017 (on-premises, Azure IaaS)
Azure SQL Databases, Azure Blob Storage,MS SQL Server Integration Services
Azure Analysis Services, PowerBI
Business Process Modeling, Data Flow, Data Modeling and UML tools (e.g. Microsoft Visio, MagicDraw)
Variety of data types and sources (SQL Server, Rest API, Excel, CSV, JSON)
Azure DevOps
Our expectations:
3+ years of professional experience in data modeling, processing and warehousing
Expert knowledge in MS SQL Server and T-SQL
Good technical background related to data flow technologies in Microsoft environment (e.g. SSIS)
Good understanding of RDBMS model and database design
Very good knowhow about database administration and security aspects
Solid experience with performance optimization
Fluent in Business English (both written and spoken)
Strong analytical, problem solving and synthesis skills
Experience gathering and analyzing system requirements
Organizational skills and ability to work under time pressure and with complex tasks
Team player and good communication skills
Highly responsible person who act independently within his/her own responsibility area
Nice to have
Experience designing or working with cloud environments (Microsoft Azure preferred)
PowerBI and Analysis Services or equivalent experiences with similar technologies
Knowledge in shell scripting (e.g. PowerShell)
Familiarity in C# programming
Microsoft certifications Microsoft certifications
SSDT database project development and deployment
Automation of Database/Analysis Services/ SSIS deployment and maintenance
