Senior BI Engineer: Modern Analytics & ELT Leader

Prosum; Los Angeles, California (CA, MO); On-site; USD 140,000 - 190,000; Full time

Job summary

Prosum in Los Angeles is seeking a Senior BI / Analytics Engineer to design and scale a modern data ecosystem. You will build scalable ELT pipelines, semantic layers, and executive dashboards using dbt, Snowflake, and Power BI.

The role emphasizes data modeling, analytics engineering, and governance, with responsibility for ingestion, testing, scheduling, and end-user training across Sales, Marketing, Finance, and Operations.

Qualifications

• 7+ years of experience in BI/Analytics engineering, Dashboard Development, or ELT-focused roles.
• Hands-on with dbt including modeling, testing, documentation, and orchestration.
• Strong experience with Snowflake administration, optimization, and performance tuning.
• Advanced Power BI experience including semantic modeling, dataflows, and Row-Level Security (RLS).
• Experience with Fivetran connectors and API-based data ingestion.

Responsibilities

• Design 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.
• 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.
• 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.
• 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.
• Design and develop interactive dashboards and reporting solutions using Power BI.
• Build advanced DAX calculations, semantic models, dataflows, and RLS configurations.
• Deliver analytics solutions supporting Sales, Marketing, Finance, and Operations teams.
• Provide end-user training and documentation to support adoption and 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.

Skills

dbt

Snowflake

Power BI

SQL

Data modeling

Analytics engineering

DAX

Data governance

API integration

Fivetran

Tools

dbt Cloud

Snowflake

Power BI

Fivetran

Job description

Prosum in Los Angeles is seeking a Senior BI / Analytics Engineer to design and scale a modern data ecosystem. You will build scalable ELT pipelines, semantic layers, and executive dashboards using dbt, Snowflake, and Power BI.

The role emphasizes data modeling, analytics engineering, and governance, with responsibility for ingestion, testing, scheduling, and end-user training across Sales, Marketing, Finance, and Operations.