NetWeb Software – Enterprise Data Warehouse Architect 

Job Description

Enterprise Data Warehouse Architect

The Enterprise Data Warehouse Architect is a senior, hands-on technical leader responsible for the design, implementation, and ongoing support of scalable, secure, and resilient Data Warehouse (DW) and Business Intelligence (BI) solutions. This role blends expertise in architecture, data modeling, ETL development, analytics, security, and governance, while mentoring technical teams to deliver reliable, high-quality data and actionable business insights.

Key Responsibilities :

Architecture, Design Development :

– Design and implement a resilient, end-to-end Data Warehouse architecture ensuring data quality, accuracy, completeness, error handling, logging, monitoring, and auditability.

– Review and assess existing DW/BI architecture to identify gaps, redundancies, and opportunities for optimization.

– Develop and maintain an architecture review plan, including periodic evaluations, recommendations, and roadmap updates.

– Develop and manage enterprise Data Warehouses and Data Marts, supporting current and future analytics needs.

– Evaluate, document, and integrate all data sources and integration touchpoints across the enterprise.

– Model and implement dimensional data structures (facts, dimensions) using industry best practices.

– Design, build, test, and deploy comprehensive ETL/ELT solutions for large-scale data processing.

– Serve as the primary senior technical developer for DW/BI initiatives, providing deep hands-on expertise.

– Propose enhancements to existing data models, ETL processes, and reporting solutions to improve performance, scalability, and maintainability.

Analytics, Reporting & Business Intelligence :

– Perform complex data analysis to build a deep understanding of data structures, business processes, and use cases.

– Identify, analyze, and interpret trends and patterns in complex datasets to deliver meaningful business insights.

– Develop, deliver, and support enterprise reporting, dashboards, KPIs, and advanced analytics solutions.

– Ensure BI solutions are optimized for performance, scalability, and usability.

Security, Governance & Compliance :

– Own and lead the overall Data Warehouse security architecture, from design to implementation.

– Define and enforce comprehensive security controls, including authentication, authorization, and data access policies.

– Define information security requirements and remediation plans, including policy-, rule-, and attribute-based access controls.

– Enable and manage data-at-rest and data-in-transit security features.

– Apply data governance best practices to ensure proper data lineage, stewardship, and regulatory compliance.

Leadership, Collaboration & Delivery :

– Serve as a technical lead and mentor, guiding team members in DW/BI architecture, and best practices.

– Partner with business stakeholders, data stewards, and IT teams to define requirements, prioritize work, and meet delivery timelines.

– Translate complex business and technical requirements into clear architectural strategies and implementable solutions.

– Track progress against delivery plans and monitor milestones, risks, and dependencies.

Operations, Quality Support :

– Provide senior-level production support for all DW/BI solutions, including troubleshooting and performance tuning.

– Design and maintain backup, recovery, and disaster recovery processes for all data sources and platforms.

– Identify, communicate, and mitigate technical risks and delivery issues in a timely manner.

– Perform quality assurance activities, including design and deliverable reviews.

– Assist with organizing, documenting, and managing – A and production releases.

Standards, Documentation Compliance :

– Contribute to the development, enforcement, and continuous improvement of EDW/BI standards and best practices.

– Ensure adherence to team operating standards for source code control, issue tracking, time reporting, and release management.

– Contribute to planning, estimation, and resourcing of reporting and analytics solutions.

– Produce high-quality project artifacts, including :

1. Technical requirements and specifications

2. Test plans and documentation

3. System and operations guides

4. Issue and enhancement documentation

5. Backup and disaster recovery plans

Experience :

– 8- 12 years of relevant experience in Enterprise Data Warehousing, BI, and Analytics roles.

Are you interested in this position?

Apply by clicking on the “Apply Now” button below!

#GraphicDesignJobsOnline

#WebDesignRemoteJobs #FreelanceGraphicDesigner #WorkFromHomeDesignJobs #OnlineWebDesignWork #RemoteDesignOpportunities #HireGraphicDesigners #DigitalDesignCareers# Dynamicbrand guru