Senior BI / Analytics EngineerSalary Range: $150k to $165kLocation: Brentwood, CA (Mon-Thur onsite / Fridays remote)
Overview
A growing organization is seeking a Senior BI / Analytics Engineer to help build and scale a modern data and analytics ecosystem. This role will focus on designing and maintaining scalable ELT pipelines, data models, semantic layers, and executive-level dashboards using modern cloud data technologies.
The ideal candidate brings deep expertise in dbt, Snowflake, Power BI, and modern ingestion platforms, with a strong foundation in data modeling, analytics engineering, and business intelligence best practices.
Key Responsibilities
Semantic Layer & Data Modeling
- Develop and maintain semantic layers supporting operational and executive reporting
- Create dimensional and subject-area data models aligned to business functions including CRM, sales, marketing, finance, operations, compliance, and customer support
- Standardize KPIs, metrics, calculations, and business definitions across reporting environments
- Collaborate with stakeholders to translate business requirements into scalable analytics solutions
Data Transformation & ELT Orchestration
- Design, build, and optimize dbt Cloud transformation models including staging, core, and mart layers
- Implement automated testing frameworks for schema validation, data quality, and business logic
- Manage dbt Cloud job scheduling, orchestration, and deployment workflows
- Ensure reliable ingestion-to-transformation-to-delivery pipelines
Snowflake Administration & Optimization
- Configure and manage Snowflake warehouses, roles, permissions, and resource monitors
- Optimize warehouse performance, scalability, and cost management
- Configure and maintain connectors and integrations with operational systems
- Troubleshoot data pipeline and query performance issues
Data Ingestion & Integration
- Configure and maintain Fivetran connectors and ingestion pipelines
- Support API-based ingestion processes where needed
- Monitor connector health, schema drift, and incremental loading processes
- Maintain integrations across multiple enterprise systems and data sources
Analytics & Dashboard Development
- Design and develop interactive dashboards and reporting solutions using Power BI
- Build advanced DAX calculations, semantic models, dataflows, and row-level security configurations
- Deliver analytics solutions supporting Sales, Marketing, Finance, and Operations teams
- Provide end-user training and documentation to support adoption and governance
Data Quality & Governance
- Implement automated monitoring, alerts, and data quality controls
- Maintain lineage and documentation across analytics and transformation platforms
- Perform data reconciliation and troubleshooting across multiple source systems
- Support governance, consistency, and reporting accuracy initiatives
Required Qualifications
- 7+ years of experience in BI Engineering, Analytics Engineering, Dashboard Development, or ELT-focused roles
- Deep hands-on expertise with dbt including modeling, testing, documentation, and orchestration
- Strong experience with Snowflake administration, optimization, and performance tuning
- Advanced Power BI experience including:
- Semantic modeling
- DAX development
- Dataflows
- Row-Level Security (RLS)
- Governance best practices
- Experience with Fivetran connectors and API-based data ingestion
- Strong SQL development and dimensional data modeling skills
- Experience integrating and reconciling data from platforms such as Salesforce, HubSpot, NetSuite, QuickBooks, and call-center systems
- Strong analytical, troubleshooting, and communication skills
Preferred Qualifications
- Experience with Python, C#, or other programming languages
- Exposure to Azure data services, Functions, or API Gateway technologies
- Background supporting financial services, regulated industries, or compliance-focused environments
- Experience with Power BI administration and enterprise governance
Preferred Technical Environment
- dbt Cloud
- Snowflake
- Power BI
- Fivetran
- SQL
- Salesforce
- HubSpot
- NetSuite / QuickBooks
- API integrations
- Cloud-based analytics platforms
Additional Information
- Senior-level opportunity with high visibility and impact
- Opportunity to help build and modernize enterprise analytics infrastructure
- Collaborative, data-driven environment
- Competitive compensation and benefits package available based on experience