SQL Database Architect

Core Roles & Responsibilities 1. Architectural Strategy & Migration Design Modern Data Architecture: Design and evolve a Lakehouse/Mesh architecture using AWS S3, Glue, and Amazon Redshift. Legacy EDW Migration: Execute the migration strategy for moving MS SQL Server EDW to AWS, ensuring high performance and data integrity. Pipeline Modernization: Refactor legacy SSIS packages into cloud-native services using AWS Glue, Step Functions, or MWAA (Airflow). BI & Report Modernization: Lead the migrat

SCOPE OF SERVICES Collect and translate reporting and dashboard requirements from internal stakeholders into reporting solutions to meet business needs. Partner with internal stakeholders to identify opportunities to improve existing reports before translating them into a VBA-compatible format, as applicable. Identify opportunities to scale the report development effort, such as leveraging standardized formats across multiple stakeholders using similar documents. Support internal Client teams to

Hi Good Afternoon, Hope you are doing well. We have a role for the below requirement. Role: Database Architect, Level 3 Location: Remote Duration: 12 Months Job Description Design and maintain reporting data models, including fact and dimension structures, semantic layers, and reporting datasets. Define and document data architecture standards, best practices, and governance guidelines. Ensure data models support business KPIs, operational reporting, dashboards, and advanced analytics. Partn

Desired Experience Gathering requirements and developing technical specifications for ETL 6 years Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx) Developing various types of data loads (e.g. incremental, history/full, survivorship rules) 6 years Implementing change data capture (CDC) 4 years Testing and debugging ETL 6 years Developing complex SQL - 6 years ETL job scheduling 2 years Loading data warehouses using ETL tools 2 years Management of