Position: Software Engineer Data Architect
Company: ITOMYCH STUDIO
Category: Data Analyst
Experience required: 5y
English level: upper
Published: 2023-07-01T00:00:00+03:00

We are seeking an experienced Data Architect focusing on Microsoft technologies to join our data management team. The successful candidate will design, create, deploy, and manage our company's data architecture using technologies such as MS SQL Server, Azure SQL, Cosmos DB, relational databases, NoSQL, and . NET. This includes developing data models, designing databases, creating ER diagrams, and planning and implementing robust data strategies to support the organization's goals

**About you**

5+ years of work experience as a Data Architect, Database Designer, or similar role in data management
Database Systems: Proficiency in traditional RDBMS systems like MS SQL Server and non-relational databases (NoSQL) such as Cosmos DB, MongoDB, etc
Transactional databases: understanding of transactional (live) data concepts and technologies
Data Warehousing: Understanding of data warehousing concepts and technologies
Data Modelling: Proficiency in data modeling techniques, including conceptual, logical, and physical data models, ER diagrams, and data dictionaries
ETL Processes: Knowledge of ETL (Extract, Transform, Load) tools and processes
Cloud Computing: Experience with cloud-based data solutions like Azure SQL, Blob Storage, Cosmos DB, Data Tables
Big Data Technologies is a plus: Familiarity with Big Data tools and technologies like Hadoop, Spark, and Kafka
Data Visualization: Familiarity with data visualization tools such as Power BI
Security: Knowledge of data security practices, including managing permissions, roles, and access controls
Data Governance: Understanding of data governance principles, data management, and data lifecycle
Good understanding of non-data related technologies: microservices, Web API, Message Queuing, unit testing, application security, software licensing, integration testing, containers, GIT, Azure DevOps, cloud environments and processes (Azure), deployment, Test automation, ORM, CI/CD, DevOps, etc
A knack for benchmarking and optimization
Understanding application and cloud security: OWASP, identity and access management, Active Directory, policies
Financial Data Management: Understanding of financial data and regulatory compliance requirements related to data handling in the financial sector
Excellent communication and teamwork skills
At least Upper-Intermediate English

**As a plus**

Knowledge of programming and scripting languages like .NET, PowerShell, SQL is a plus

**Responsibilities**

Develop and implement strategic data plans in alignment with company financial goals
Define the data architecture framework, standards, and principles, including modeling, metadata, security, and reference architectures
Design, create, deploy, and manage the organization's data architecture with a focus on MS SQL Server, Azure SQL, Cosmos DB, NoSQL databases, and .NET
Develop database solutions to store and retrieve company financial and not financial information efficiently
Identify strategic data requirements of enterprise stakeholders in the financial sector
Perform data profiling and data mapping to help data analysts and other users understand financial data
Work closely with BA and developers. Create data models and ER diagrams that enable the implementation of the intended business architecture in a financial context
Oversee the design and implementation of new data platform components and data processing
Ensure the accuracy, integrity, and compliance of data, keeping in mind financial regulations and data governance
Evaluate new data technologies and data analytics platforms to improve and optimize data systems
Understand and plan ETL from current systems and databases
Work with the team on multiple projects in order to deploy applications and systems to meet business requirements
Problem solver and understand the complex needs of the business and translate that into positive solutions
Ensure accurate and clean code and documentation is delivered and to a deadline, while reducing the commercial impact on the business
Translate business requirements of the design architecture into the computer software application
Support troubleshooting of data legacy systems 
Identify and design system requirements
Prepare and document standard operating procedures and protocols
Write comprehensive reports including assessment-based findings, outcomes and propositions for further system enhancements
Analyzing and implementing new protocols and technologies
Assist the IT and business as part of the solution design process
Assist team members with resolution of work problems
In a timely manner, assist and advise internal customers on technical issues, resolving any incident calls allocated
Assist internal clients in queries relating to the progress of outstanding/ongoing problems or the database design
Ensure all services provided by the function are compliant with the CBUAE, FINTX group policies & procedures.
Raise any concerns surrounding  compliance and risk-related issues, either  directly or through the whistleblowing procedure using 
Be aware within the team and wider  organization of the employee  responsibility in working in a risk-free and compliant manner
Attend risk and compliance awareness programs during the course of the employment, whether it is as part of the on-boarding process or the annual refresher training

**Interview steps**

CV is reviewed by technical specialists
Test Task
Client Interview (up to 60 minutes)
Feedback at each stage

**Our benefits**

Regular and predictable Performance Review process
Powerful team expertise and mentorship
Personal development plans
Assistance and expenses coverage in obtaining certification
Financial compensation for participation in conferences
Partial medical and educational expenses coverage
25 billable days off