As an Enterprise Data Warehouse Architect, you will be a senior technical leader responsible for designing, implementing, and supporting scalable, secure, and resilient Data Warehouse (DW) and Business Intelligence (BI) solutions. Your role will involve blending expertise in architecture, data modeling, ETL development, analytics, security, and governance, while mentoring technical teams to deliver reliable data and actionable business insights. **Key Responsibilities:**
Design and implement a resilient Data Warehouse architecture ensuring data quality, completeness, error handling, monitoring, and auditability. - Review existing DW/BI architecture, identify gaps, redundancies, and optimization opportunities. - Develop and maintain an architecture review plan, including evaluations, recommendations, and updates. - Manage enterprise Data Warehouses and Data Marts to support current and future analytics needs. - Integrate all data sources and touchpoints across the enterprise. - Implement dimensional data structures using best practices. - Design, test, and deploy ETL/ELT solutions for large-scale data processing. - Lead DW/BI initiatives as the primary senior technical developer. - Enhance data models, ETL processes, and reporting solutions for improved performance and scalability. - Perform complex data analysis to understand data structures, business processes, and use cases. - Identify trends and patterns in datasets to deliver meaningful business insights. - Develop and support enterprise reporting, dashboards, KPIs, and analytics solutions. - Optimize BI solutions for performance and usability. **Security, Governance & Compliance:**
Lead Data Warehouse security architecture design and implementation. - Enforce comprehensive security controls, including authentication and data access policies. - Define information security requirements and remediation plans. - Manage data security features for data-at-rest and data-in-transit. **Leadership, Collaboration & Delivery:**
Mentor team members in DW/BI architecture and best practices. - Collaborate with stakeholders to define requirements and meet delivery timelines. - Translate complex requirements into architectural strategies. - Monitor progress, risks, and dependencies. **Operations, Quality Support:**
Provide production support, troubleshooting, and performance tuning for DW/BI solutions. - Design backup, recovery, and disaster recovery processes. - Identify and mitigate technical risks and delivery issues. - Conduct quality assurance activities. **Standards, Documentation Compliance:**
Contribute to EDW/BI standards and best practices. - Ensure adherence to operating standards for source code control and release management. - Assist in planning and resourcing reporting solutions. - Produce project artifacts including technical requirements, test plans, system guides, and documentation. **Experience:**
8-12 years of experience in Enterprise Data Warehousing, BI, and Analytics roles. **Technical Skills:**
Expertise in Microsoft BI platform, including SQL Server, SSIS, SSAS, SSRS, Power BI, and Excel. - Strong data modeling, SQL programming, and ETL development skills. - Experience in delivering BI solutions with robust security. - Deep understanding of DW/BI security, performance tuning, and query optimization. - Familiarity with scheduling tools and Big Data architectures. **Professional Skills:**
Strong analytical, problem-solving, and critical-thinking abilities. - Ability to manage multiple priorities with attention to detail. - Self-motivated, results-driven with a sense of ownership. - Strong organizational, planning, and time-management skills. - Proficient in MS Office, Visio, Project, and internet tools. **Educational Qualification:**
ME (IT, Computer), BE (IT, Computer), MCA, MSC-IT, BCA As an Enterprise Data Warehouse Architect, you will be a senior technical leader responsible for designing, implementing, and supporting scalable, secure, and resilient Data Warehouse (DW) and Business Intelligence (BI) solutions. Your role will involve blending expertise in architecture, data modeling, ETL development, analytics, security, and governance, while mentoring technical teams to deliver reliable data and actionable business insights. **Key Responsibilities:**
Design and implement a resilient Data Warehouse architecture ensuring data quality, completeness, error handling, monitoring, and auditability. - Review existing DW/BI architecture, identify gaps, redundancies, and optimization opportunities. - Develop and maintain an architecture review plan, including evaluations, recommendations, and updates. - Manage enterprise Data Warehouses and Data Marts to support current and future analytics needs. - Integrate all data sources and touchpoints across the enterprise. - Implement dimensional data structures using best practices. - Design, test, and deploy ETL/ELT solutions for large-scale data processing. - Lead DW/BI i