Senior BI Data Engineer - Lead ETL & Analytics

Synoptek; Los Angeles (CA); On-site; USD 120,000 - 170,000; Full time

Job summary

Synoptek seeks a Senior Software Engineer - Business Intelligence to design, develop, and optimize scalable BI solutions and ETL pipelines across on‑prem and cloud. You will collaborate with stakeholders to deliver reliable analytics environments, implement data quality controls, and mentor junior team members.

Role requires 5+ years in BI or analytics, strong SQL/ETL skills, data modeling, and experience with data governance.

Qualifications

• Requires at least 5 years of experience in BI development, software engineering, data engineering, enterprise reporting, or analytics environments.
• Bachelor’s degree in a related technical field is required; cloud/BI certifications are preferred.
• Strong SQL, ETL, data modeling, data governance, and data quality skills are essential.

Responsibilities

• Design, develop, maintain, and optimize BI solutions, ETL workflows, reporting, and data integration.
• Collaborate with business, analytics, and technical teams to gather requirements and deliver solutions.
• Develop and maintain data models, SQL scripts, stored procedures, dashboards, and reports.
• Build and support ETL pipelines across on‑premises and cloud environments.
• Troubleshoot data quality, performance, and integration issues and validate reporting logic.
• Participate in architecture discussions and provide technical recommendations.
• Create and maintain technical documentation including data mappings and procedures.
• Mentor junior developers and participate in Agile delivery and sprints.

Skills

ETL Development

Data Engineering

SQL Server

SQL

Data Modeling

Data Warehousing

Dimensional Modeling

Data Integration

ETL Pipelines

Stored Procedures

Query Optimization

Performance Tuning

Data Quality Management

Analytics

Technical Documentation

Agile Methodology

SDLC

Data Governance

Troubleshooting

Mentoring

Communication Skills

Problem Solving

Python

AI Agent

GenAI/LLM

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, AI Agent Engineer, or related technical field

Job description

Synoptek seeks a Senior Software Engineer - Business Intelligence to design, develop, and optimize scalable BI solutions and ETL pipelines across on‑prem and cloud. You will collaborate with stakeholders to deliver reliable analytics environments, implement data quality controls, and mentor junior team members.

Role requires 5+ years in BI or analytics, strong SQL/ETL skills, data modeling, and experience with data governance.