Sr. Data Engineer

BICP, a market leader in Decision Intelligence, enterprise modernization, and data-driven transformation, is hiring an Sr. Data Engineer, to support a premium lifestyle apparel client in San Diego, California. We are seeking to hire a Senior Data Engineer to support and enhance our clients Enterprise Data Platform while enabling analytics, reporting, and emerging AI capabilities across the organization. This individual will play a key role in designing, developing, and maintaining scalable data pipelines, data models, and cloud-based data solutions that support critical business functions. The ideal candidate is a hands-on engineer with strong experience in modern cloud data platforms, data integration, and data warehousing who enjoys collaborating with business and technical teams to deliver reliable, high-quality data solutions. Key Responsibilities Data Engineering & Platform Development • Design, develop, and maintain scalable data pipelines and data integration processes. • Build and optimize ELT/ETL workflows using Azure Data Factory (ADF), Snowflake, SQL, and related technologies. • Support data ingestion, transformation, and delivery for both operational and analytical use cases. • Ensure data quality, reliability, performance, and availability across the enterprise data platform. • Monitor and troubleshoot data pipelines, workflows, and production issues. Data Modeling & Analytics Support • Develop and maintain data models that support enterprise reporting and analytics. • Partner with business stakeholders, analysts, and reporting teams to understand data requirements and deliver scalable solutions. • Support self-service reporting and business intelligence initiatives. • Contribute to semantic layer development and data standardization efforts. • Enable reporting across key business domains including sales, marketing, supply chain, planning, operations, and product development. Cloud Data Platform Support • Support the ongoing evolution of the Azure-based Enterprise Data Platform. • Work with structured and semi-structured data sources across multiple business systems. • Participate in platform enhancements, performance tuning, and data governance initiatives. • Collaborate with architects and technical leadership on future platform improvements. AI & Data Innovation • Support data engineering initiatives related to AI, machine learning, and LLM-based solutions. • Assist in preparing and organizing enterprise data for AI and advanced analytics use cases. • Contribute to semantic models and data structures that support AI-enabled applications and intelligent data retrieval. Agile Delivery & Collaboration • Participate in sprint planning, backlog refinement, and Agile development processes. • Collaborate with business users, analysts, product owners, and technical teams to deliver solutions aligned to business priorities. • Document data flows, technical solutions, and operational processes. • Contribute to continuous improvement of engineering standards and delivery practices. Required Qualifications Experience • 5+ years of experience in Data Engineering, Data Warehousing, or related roles. • Strong experience building and supporting cloud-based data platforms. • Hands-on experience with: Snowflake, Azure Data Factory (ADF), SQL and Azure Cloud Services • Experience developing and maintaining ETL/ELT pipelines. • Strong understanding of data modeling and data warehousing concepts. • Experience supporting analytics and reporting environments. • Familiarity with Agile delivery methodologies. Technical Skills • Advanced SQL development and optimization. • Data pipeline development and orchestration. • Data integration across multiple source systems. • Data quality, validation, and troubleshooting. • Experience working with large and complex datasets. Nice-to-Have Qualifications • Experience designing enterprise data architecture and data platform roadmaps. • Experience with MicroStrategy/Strategy, Power BI, Tableau, or other BI platforms. • Experience supporting AI, machine learning, LLM, or semantic layer initiatives. • Experience with Databricks, dbt, Spark, Python, or related modern data engineering tools. • Retail, consumer products, apparel, supply chain, or manufacturing industry experience. • Experience participating in platform modernization or cloud migration initiatives. • Exposure to data governance, metadata management, and master data management programs. Key Attributes • Strong problem-solving and analytical skills. • Hands-on, execution-oriented mindset. • Ability to balance technical depth with business understanding. • Strong communication and collaboration skills. • Self-starter who can work independently while partnering effectively across teams. This role is best suited for a senior-level engineer who enjoys building scalable data solutions, improving data accessibility, and enabling better business decisions through reliable and modern data platforms. What We Offer • Competitive compensation • Unique, start-up culture with the stability of legacy enterprise customers • Opportunities for growth and professional development • Dynamic and collaborative team culture About BICP BICP is a consulting firm focused on delivering leading-edge AI, ML and Analytics solutions to our enterprise customers. With deep experience across a diverse ecosystem of leading-edge data products and cloud-based platforms we have the required ambiguity and expertise to deliver best-in-breed solutions tailored to our client’s critical business data needs. BICP is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.