Senior Data Engineer - SQL & Azure Data Warehousing
Location: Fontana, CA / El Monte, CA
Employment Type: Full-Time | Direct Hire
Work Arrangement: 100% Onsite
Schedule: 4/10 or 9/80 or 5/40
Position Overview
SuperbTech is seeking an experienced Senior Data Engineer - SQL & Azure Data Warehousing to join an established private water utility's IT Department. This position will be responsible for designing, developing, maintaining, and optimizing enterprise databases, data warehouses, and data integration solutions.
The Senior Data Engineer will work with departments across the organization to develop scalable data solutions, improve database performance, integrate enterprise systems, and support business intelligence and reporting initiatives. The ideal candidate will possess expert-level SQL development skills, extensive experience with Microsoft SQL Server and Azure technologies, and the ability to independently design and implement enterprise data warehouses.
Key Responsibilities
- Design, develop, and optimize complex SQL queries, stored procedures, views, functions, triggers, and database scripts.
- Develop, maintain, and optimize relational databases using SQL Server, Azure SQL, Oracle, PostgreSQL, MySQL, and related technologies.
- Design and maintain database schemas, relationships, indexes, and data structures to support enterprise applications and reporting.
- Independently design, develop, implement, and maintain enterprise data warehouse solutions.
- Develop dimensional data models, fact and dimension tables, star schemas, staging layers, and reporting structures.
- Design and maintain ETL/ELT pipelines using Azure Data Factory and related Microsoft Azure technologies.
- Integrate data from enterprise applications, databases, REST APIs, files, and third-party systems.
- Develop data transformation, validation, cleansing, reconciliation, and incremental loading processes.
- Perform SQL query optimization, execution plan analysis, indexing, and database performance tuning.
- Develop and maintain Power BI dashboards, reports, semantic models, DAX measures, and Power Query transformations.
- Monitor and troubleshoot database performance, data warehouse operations, failed jobs, data pipelines, and reporting issues.
- Support Azure SQL, Azure Storage, and cloud-based data integration solutions.
- Collaborate with internal departments to understand business requirements and translate them into scalable database and reporting solutions.
- Support integrations involving Microsoft 365, SharePoint Online, and Microsoft Power Platform technologies.
- Maintain technical documentation, data mappings, database security, and development and change-management standards.
Required Qualifications
- 7+ years of experience in SQL development, database engineering, or enterprise data warehousing.
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.
- Expert-level SQL development skills, including complex queries, stored procedures, views, indexing, and performance optimization.
- Strong hands-on experience with Microsoft SQL Server, Azure SQL, and additional relational database technologies such as Oracle, PostgreSQL, or MySQL.
- Proven experience independently designing, developing, implementing, and maintaining enterprise data warehouses.
- Strong knowledge of dimensional data modeling, fact and dimension tables, star schemas, and enterprise data warehouse architecture.
- Hands-on experience developing ETL/ELT pipelines using Azure Data Factory.
- Experience with Microsoft Azure, cloud-based databases, data storage, and enterprise data integrations.
- Proficiency in Power BI, DAX, Power Query, and SQL-based reporting solutions.
- Knowledge of Python, REST APIs, JSON, and database automation.
- Experience with data validation, performance optimization, troubleshooting, and database deployments.
- Familiarity with Microsoft 365, SharePoint Online, Power Automate, and Power Platform integrations.
- Knowledge of database security, Git, Azure DevOps, and change-management practices.
- Strong analytical, troubleshooting, communication, and problem-solving skills.
- Ability to independently develop technical solutions and translate business requirements into scalable database and reporting systems.
Preferred Qualifications
- Experience designing enterprise data warehouse solutions integrating customer information, billing, finance, and operational systems.
- Experience with advanced SQL performance tuning and database optimization across multiple relational database platforms.
- Experience with historical data tracking, incremental data loading, and complex data transformation processes.
- Experience with Azure Storage and cloud-based data integration architecture.
- Experience developing Python-based database automation and integration solutions.
- Experience supporting enterprise application integrations and Microsoft Power Platform environments.
Ideal Candidate
The ideal candidate is an experienced Senior Data Engineer with a strong background in SQL development, Microsoft SQL Server, Azure SQL, enterprise data warehousing, and Azure Data Factory.
This individual has demonstrated experience independently designing and implementing enterprise data warehouse solutions, developing complex ETL/ELT pipelines, optimizing database performance, and integrating data across multiple business systems.
The successful candidate will possess advanced SQL development capabilities, strong analytical and problem-solving skills, and experience supporting Power BI reporting and business intelligence initiatives. They will be comfortable collaborating with business departments, troubleshooting complex data issues, and delivering reliable, scalable data solutions with minimal supervision.
SuperbTech, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment in accordance with applicable federal, state, and local laws.