Job Title: Senior Data EngineerLocation: Anaheim, CA (Hybrid โ 2 to 3 days onsite per week)
Duration:6+ Months
ย
Note : W2 role No C2CJob Summary
We are seeking an experienced Senior Data Engineer to join our team in Anaheim, CA. The ideal candidate will have a strong background in SQL Server, ETL development, data warehousing, and data integration. This is a hybrid role requiring candidates to work onsite 2โ3 days per week, so local candidates from the Los Angeles or Orange County area are preferred.
Required Skills
- 7+ years of experience as a Data Engineer or similar role.
- Strong experience with Microsoft SQL Server.
- Advanced SQL programming and query optimization skills.
- Hands-on experience developing and maintaining SSIS ETL packages.
- Experience designing and implementing data pipelines.
- Strong understanding of data warehousing concepts and architectures.
- Experience with data modeling and data integration.
- Ability to analyze business requirements and translate them into scalable data solutions.
- Strong troubleshooting and performance tuning skills.
Responsibilities
- Design, develop, and maintain scalable ETL processes using SSIS.
- Develop and optimize SQL Server databases, stored procedures, views, and queries.
- Build and maintain reliable data pipelines for data ingestion and transformation.
- Design and support enterprise data warehouse solutions.
- Create logical and physical data models to support business reporting and analytics.
- Integrate data from multiple sources while ensuring data quality and consistency.
- Monitor ETL jobs, troubleshoot issues, and optimize performance.
- Collaborate with business stakeholders, analysts, and development teams to deliver data solutions.
- Document technical designs, processes, and data flows.
Preferred Qualifications
- Experience working in enterprise data warehouse environments.
- Knowledge of database performance tuning and optimization.
- Excellent analytical, problem-solving, and communication skills.
- Experience working in Agile development environments.