Senior Data Platform Architect (Azure & Snowflake)

BICP; San Diego (CA); On-site; USD 180,000 - 240,000; Full time

Job summary

BICP is seeking a Principal Data Engineer to lead and contribute hands-on to a modern enterprise data platform for retail and apparel analytics. The role combines technical leadership with hands-on implementation across cloud data technologies.

The candidate will shape data architecture, establish engineering standards, and build scalable data solutions while collaborating with analytics, product, and business teams to deliver trusted data products for reporting, ML, and AI initiatives across

Qualifications

• 5+ years in data engineering, software engineering, data architecture, or related discipline.
• Experience as principal engineer, technical lead, data architect, or senior engineering leader.
• Advanced hands-on experience with Microsoft Azure, Snowflake, Azure Data Factory, and Azure Databricks.
• Strong programming experience with Python and PySpark.
• Expert-level SQL skills, including query optimization and performance tuning.
• Experience designing and delivering enterprise-scale ETL/ELT pipelines.

Responsibilities

• Provide technical leadership for the design and evolution of a modern, cloud-based enterprise data platform.
• Architect and develop scalable data pipelines using Azure Data Factory, Azure Databricks, Snowflake, Python, PySpark, and SQL.
• Establish reusable engineering patterns for data ingestion, transformation, orchestration, modeling, testing, deployment, and monitoring.
• Design batch and near-real-time integrations across enterprise applications, APIs, cloud platforms, and third-party data sources.
• Develop curated data products that support enterprise reporting, self-service analytics, data science, machine learning, and generative AI.
• Partner with business and technology leaders to translate strategic priorities into scalable technical solutions.
• Support data domains including marketing, merchandising, planning, supply chain, order fulfillment, consumer sales, retail, finance, and product development.
• Improve data quality, observability, lineage, security, governance, performance, and platform reliability.
• Optimize Snowflake and Databricks workloads for scalability, performance, maintainability, and cost efficiency.
• Define and promote engineering best practices, including version control, automated testing, CI/CD, code reviews, documentation, and infrastructure automation.
• Lead technical design and architecture reviews, evaluating tradeoffs across platforms, technologies, and implementation approaches.
• Diagnose and resolve complex issues affecting pipelines, data platforms, integrations, and downstream applications.
• Mentor data engineers and provide technical guidance across internal and distributed delivery teams.
• Collaborate with data science and AI teams to ensure enterprise data is accessible, governed, and production-ready for advanced use cases.

Skills

Azure Data Factory

Azure Databricks

Snowflake

PySpark

Python

SQL performance

Tools

Power BI

Tableau

Microsoft Fabric

MicroStrategy

Job description

BICP is seeking a Principal Data Engineer to lead and contribute hands-on to a modern enterprise data platform for retail and apparel analytics. The role combines technical leadership with hands-on implementation across cloud data technologies.

The candidate will shape data architecture, establish engineering standards, and build scalable data solutions while collaborating with analytics, product, and business teams to deliver trusted data products for reporting, ML, and AI initiatives across