About the role
- We are seeking an experienced Senior Solution Architect – Data Warehousing & Database Management to lead the architecture, design, and implementation of enterprise-grade data solutions.
- The role will drive scalable, secure, and high-performing data warehouse and database architectures across on-premises, cloud, and hybrid environments.
- Work closely with business stakeholders, data engineering teams, analytics teams, and infrastructure teams to translate business requirements into robust technical solutions aligned with enterprise architecture and organizational objectives.
- Provide technical leadership across data modernization, integration, migration, governance, performance optimization, and enterprise data management initiatives.
Job Description
- Design end-to-end data warehousing and database management solutions, including data models, database architectures, and ETL/ELT frameworks.
- Evaluate and recommend modern data platforms and technologies such as Snowflake, Azure Synapse, AWS Redshift, Google BigQuery, Databricks, Oracle, and SQL Server.
- Lead data integration and migration initiatives from legacy platforms to modern cloud data environments, ensuring data quality, consistency, and lineage.
- Establish architectural standards and best practices for database design, data modeling, metadata management, security, and performance optimization.
- Oversee database performance, scalability, high availability, disaster recovery, and enterprise data security architecture.
- Collaborate with business, governance, compliance, and technology stakeholders to define data strategies, architecture roadmaps, and implementation plans.
- Lead architectural reviews, mentor technical teams, and ensure effective documentation, knowledge sharing, and continuous improvement.
Qualifications
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related discipline (preferred).
- Relevant cloud platform certifications, such as Azure Data Engineer Associate, AWS Solutions Architect, or Google Professional Data Engineer (preferred).
- 10–15 years of professional experience in data architecture, data warehousing, and database management, including 5+ years in an architect-level role.
- Proven experience designing and implementing enterprise data solutions using platforms such as Snowflake, Azure Synapse, AWS Redshift, Google BigQuery, Oracle, and SQL Server.
- Strong expertise in conceptual, logical, and physical data modeling, database architecture, and performance tuning.
- Hands-on experience with ETL/ELT frameworks, data integration tools, and scripting languages, including SQL, Python, and Shell.
- Experience designing cloud data ecosystems, hybrid architectures, and data lake and data warehouse integrations.
- Experience architecting data migration and modernization initiatives, including legacy-to-cloud platform migrations and reporting technology transitions such as Qlik to Power BI and Teradata to Snowflake.
- Practical exposure to data ingestion, transformation, and integration tools such as Informatica, Alteryx, Azure Data Factory, and dbt.
- Experience optimizing database performance through indexing, partitioning, query tuning, and scalable database design.
- Strong understanding of data governance, metadata management, data lineage, data quality frameworks, and enterprise data management practices.
- Experience designing secure data environments with encryption, access controls, and compliance considerations, including GDPR and HIPAA.
- Experience collaborating with infrastructure teams on high availability, disaster recovery, and scalability planning.
- Exposure to business intelligence and reporting platforms such as Power BI, Tableau, or Qlik.
- Experience with CI/CD pipelines, modern DevOps practices, machine learning data pipelines, and analytics modernization programs is preferred.
- Demonstrated experience leading architectural reviews, mentoring technical teams, managing stakeholders, and contributing to data strategy and roadmap planning.
- Data Architecture & Warehousing: Enterprise data architecture, data warehousing, database management, cloud and hybrid architectures, data lake integration, and end-to-end solution design.
- Data Platforms & Databases: Snowflake, Azure Synapse, AWS Redshift, Google BigQuery, Databricks, Oracle, and SQL Server.
- Data Modeling & Database Management: Conceptual, logical, and physical data modeling, database design, indexing, partitioning, query tuning, and performance optimization.
- Data Integration & Engineering: ETL/ELT frameworks, data ingestion, data transformation, Informatica, Alteryx, Azure Data Factory, dbt, SQL, Python, and Shell scripting.
- Data Migration & Modernization: Legacy platform migration, cloud migration, data integration strategy, analytics modernization, and reporting platform transitions.
- Data Governance & Security: Enterprise data governance, metadata management, data lineage, data quality, encryption, access control, GDPR, and HIPAA compliance considerations.
- Performance & Infrastructure: Database optimization, scalability planning, high availability, disaster recovery, and secure data environments.
- BI & Reporting: Power BI, Tableau, and Qlik.
- DevOps & Emerging Technologies: CI/CD pipelines, modern DevOps practices, machine learning data pipelines, and cloud platform capabilities.
- Technical Leadership: Solution design, architectural reviews, technical guidance, mentoring, design walkthroughs, peer reviews, documentation, and knowledge sharing.
- Strategic & Business Skills: Strategic and analytical thinking, stakeholder engagement, business requirement translation, roadmap planning, budget estimation, problem-solving, innovation, and continuous improvement.
- Communication & Collaboration: Strong written and verbal communication, cross-functional collaboration, and the ability to engage effectively with business and technical stakeholders.
Perks & Benefits
Medical Insurance
Choose from Health Savings Plan, HRA, or PPO, whichever best fits your healthcare needs and budget.
Parental leave
Take the time you need to welcome and care for your growing family, with leave designed to support you through this milestone.
Training and development
Access structured, project-specific training and continuous learning opportunities that help you grow in your role and career.
Two-way transport
Enjoy stress-free commuting with two-way cab pick-up and drop-off facilities for every shift.
