DWH/Database Architect

Minimum 10 years of experience in design, development, and maintenance of MS SQL database. Strong knowledge on Analytical tools like SSRS, SSIS and, SSAS. Strong expertise in writing ETLs, Data Warehouse, and other Big Data tools and methodologies.Extensive and in-depth knowledge of configuring and tuning of web, application and database servers for enterprise applications like ERP, CRM and Supply Chain Ability to work on both on-premises and Cloud environment.

Knowledge on any one of the popular visualization tools like PowerBI, Strong analytical capabilities Experience with Meta Data tools Advanced problem solving skills Must be conversant with Industry wide Database Standards Strong understanding of all versions of Microsoft SQL Server including SSIS and Reporting services (SSRS)mplement CI/CD based application development methodology using tools like Jenkins/TFS/power shell etc. Design and Development Harmonising our data architecture from Power BI Report Server with Power BI Cloud. Architect, develop, test and maintain scalable data warehouses and data pipelines.

Design, develop and test scalable ETL processes, including error handling. Creating databases, advanced data modelling, star and snowflake schemas. Writing scripts for stored procedures, database snapshots backups and data archiving.

Preparing data structures for advanced analytics and self-service reporting. Delivering projects within an AGILE environment.Data Integrity and Maintenance Ensuring the data tells one version of the truth: consistent naming conventions and calculations. Creating technical documentation and Best Practices.

Troubleshooting user issues in the Service Help Desk. Qualifications Experience: Translating business needs to design and develop tools for data analysis. Architecting cloud and on-premise data solutions; data warehouses and data lakes.

Data mining, data modelling and dealing with big data. Database management systems (SQL and NoSQL), OLAP and ETL processes. Data cleansing, testing and optimising the performance of BI tools.

Working in staging and production environments. AGILE Software Development Lifecycle processes and AGILE tooling (JIRA /Confluence). A background in Data Engineering, as part of a Business Intelligence, IT or Data Science team.

Skills: Analytical thinker with exceptional problem-solving aptitude. Communicating complex technical matters in laymans terms to non-technical stakeholders. Expertise across Microsofts Stack including Excel, Power BI, Visual Studio, Azure.

Expert in Query and program languages MS SQL Server, T-SQL, PostgreSQL, MY SQL, Python, R. Excellent working knowledge of ETL packages such as SSIS, Talend. Skilled in developing a wide range of APIs.

Working in Windows and Linux development environments. Creating Statistical and Machine Learning models Attributes: Exceptional attention to detail, commitment to data integrity and service quality. Self-starter learns and adapts quickly.

An interest in learning new frameworks and languages. A communication style and responsiveness that fosters effective working relationships. A positive can-do attitude and delivers well under pressure amid tight deadlines.

Works well in a team environment, willing to share expertise and learn from others.