Hybrid/Local Azure Synapse/Snowflake DW Architect

Tech Brand Staffing - Richmond, VA

Full-time

Hybrid - Richmond, VA

About the position

The Hybrid/Local Azure Synapse/Snowflake Data Warehouse Architect position is designed for an experienced data architect who will oversee and enhance existing data warehouse technologies while transitioning to modern cloud-based solutions. The role emphasizes data governance, quality management, and collaboration with enterprise architecture to create strategic roadmaps for data technologies. The ideal candidate will have extensive experience in data warehousing, data architecture, and cloud infrastructure, particularly with Azure Synapse and Snowflake.

Responsibilities

• Provide technical oversight and support for existing data warehouse technologies including Oracle Data warehouse and DataStage.
• Collaborate with Enterprise Architecture teams to define and implement roadmaps for transitioning to modern cloud-based data warehousing solutions.
• Design, develop, and maintain data governance and management processes using tools like IGC, IKC, or Collibra.
• Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies.
• Ensure the data infrastructure meets the needs of business operations by ensuring data quality, integrity, and security.
• Work closely with business analysts, developers, business users, architects, and DBAs to ensure the data warehouse supports business goals.
• Drive initiatives related to data integration, ETL processes, and data migration strategies.
• Provide leadership and mentorship to the data warehouse team, ensuring best practices in data architecture and engineering are followed.
• Monitor performance and manage scaling strategies for existing data warehouse environments.
• Stay up to date with industry trends and innovations in data warehouse and data management technologies, recommending improvements as necessary.

Requirements

• 15+ years of experience in data warehousing and data architecture.
• Extensive experience in data mining, large scale data modeling, data profiling, and data mapping.
• Experience with Azure Cloud, Azure Data Factory, and Data Bricks.
• Experience with different database platforms and services like SOAP, REST, etc.
• Strong experience with Oracle, DataStage, and IBM Integration Bus (IIB) for data integration and ETL.
• Solid experience with data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC), or Collibra.
• Expertise with modern cloud data warehouse platforms such as Azure Synapse or Snowflake.
• Experience in defining and implementing data governance frameworks and ensuring data quality management.
• Proven experience in designing and implementing scalable data warehouse solutions and strategies.
• Understanding of ETL processes, data integration strategies, and data migration in both on-premise and cloud environments.
• Familiarity with data modeling, data lakes, and big data technologies.
• Strong analytical and problem-solving skills with the ability to balance competing priorities.
• Excellent communication and stakeholder management skills, with the ability to work cross-functionally across teams.

Nice-to-haves

• Experience to use Snowflake
• Experience with Automation and AI in Data Warehousing
• Knowledge of big data tools like Hadoop, Spark, and Kafka.
• Certifications in Oracle, Azure, or Snowflake technologies.
• Experience with data privacy regulations like GDPR, CCPA, and best practices in data security.

Benefits

• Hybrid work environment with in-person requirements 2-3 days a week for the first 3 months and once a month thereafter.