Senior Data Engineer
Synoptek · Los Angeles, CA · 1 mo ago
Information TechnologyFull-time
About the role
Synoptek is seeking a Senior Software Engineer – Business Intelligence to design, develop, optimize, and support scalable business intelligence solutions, ETL pipelines, enterprise reporting platforms, and analytics environments. The role provides technical leadership across BI initiatives, contributes to data architecture, reporting optimization, performance tuning, and ensures data quality, reporting accuracy, and operational efficiency. Collaboration with business stakeholders, analytics teams, developers, and technical leadership is essential, as is mentoring junior team members.
Responsibilities
- Design, develop, maintain, and optimize business intelligence solutions, ETL workflows, reporting systems, and data integration processes.
- Collaborate with business, analytics, and technical teams to gather requirements and deliver reporting and analytics solutions.
- Develop and maintain data models, SQL scripts, stored procedures, dashboards, and reporting solutions.
- Build, optimize, and support ETL pipelines across on‑premises and cloud environments.
- Troubleshoot and resolve complex reporting, data quality, performance, and integration issues.
- Validate reporting logic, data transformations, and reporting accuracy.
- Perform performance tuning for SQL queries, stored procedures, ETL workflows, and reporting platforms.
- Participate in architecture discussions and provide technical recommendations aligned with business objectives.
- Create and maintain technical documentation including solution designs, data mappings, and operational procedures.
- Participate in code reviews and enforce development, reporting, and data governance standards.
- Mentor junior developers through technical guidance and knowledge‑sharing activities.
- Support Agile delivery activities including sprint planning, backlog refinement, and project execution.
- Collaborate with stakeholders and leadership teams to support business intelligence initiatives.
- Drive continuous improvement initiatives related to reporting quality, analytics performance, and operational efficiency.
Mandatory 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 Role Design
Desired Skills
- Oracle ERP Integration
- SAP ERP Integration
Qualifications
- At least 5 years of experience in business intelligence development, software engineering, data engineering, enterprise reporting, or analytics environments.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, AI Agent Engineering, or a related technical field (required).
- Technical certifications related to Microsoft BI, Azure Data Engineering, Cloud Analytics Platforms, or equivalent technologies (preferred).
- FLSA exempt position.
Location
Los Angeles, California, United States (USA)