ARCHITECT, DATA

Job Summary

The Data Architect will lead and perform complex analysis of the existing Totes data warehouse, the existing BI report structure and be responsible for ongoing development, support, and administration of all database environments.

This position requires immense knowledge and hands-on experience with BI and DW practices, development, implementations, reporting tools, report development, report improvements, data structures, data modeling, data warehousing, Structured Query Language (SQL), SQL Server, SQL SSIS, SSRS, PowerBI and Azure platform

In addition to very strong technical skills, this position will have superb business process analysis and strong interpersonal skills to work with leadership to provide technical solutions to support business needs. This will include extracting and analyzing data, integrating systems, synthesizing the data into information consumable by business decision makers, providing consultation, leadership, and mentoring on projects with functional as well as technical personnel.

Role and Responsibilities

• Review, learn and maintain existing documentation for BI, DW, PowerBI Reports and Dashboards
• Make existing BI, DW, PowerBI, and ETL process improvements for more accuracy and efficiency
• Collaborate with developers, business analysts, and cross department teams in conceptualizing and developing new requirements, actionable data and insights, and enhancements
• Provide strategic and tactical solutions for BI, DW, PowerBI Reports and Dashboards, DBA functions
• Provide end to end support through requirements gathering, design, development, testing, implementation, and maintenance
• Design additional database schemas, tables, indexes, relationships, ETL processes as needed using MS SQL Server stack
• Mentor other IT team members, providing documentation and learning experiences, sharing development opportunities

Required Skills

Skills and Qualification

• 7 years experience in design and create application architecture and develop solutions on SQL Server Technology stack (SQL 2019, SSIS, SSRS, SSAS, PowerBI) that achieve business objectives that are secure, scalable and maintainable; translating business requirements into systems, services, and solutions.
• Should have worked as a developer for BI projects including Data Warehousing, Data Migration and Reporting. Hand on experience on various BI projects/technologies
• Good experience in developing complex MSBI (SSIS, SSRS) and Power BI applications
• Ability to quickly analyse existing T-SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.
• Demonstrate deep expertise in SQL based platforms, Cloud storage and compute management
• BTech of BE degree in a computer discipline or relevant certification.