Senior Data Engineer - SQL & Azure Data Warehousing
About The Position
SuperbTech is seeking an experienced Senior Data Engineer to join an established private water utility's IT Department. The role is responsible for designing, developing, maintaining, and optimizing enterprise databases, data warehouses, and data integration solutions. The engineer will work across departments to deliver scalable data solutions, improve database performance, integrate enterprise systems, and support business intelligence and reporting initiatives. The position is 100% onsite in Fontana, CA or El Monte, CA, with a 4/10, 9/80, or 5/40 schedule. It is a full-time, direct-hire role. The successful candidate will bring expert SQL development skills and extensive experience with Microsoft SQL Server and Azure technologies. They will independently design and implement enterprise data warehouses, develop ETL/ELT pipelines and dimensional models, optimize data platforms, and support Power BI reporting. The role also involves troubleshooting complex data issues, collaborating with internal departments to translate requirements into technical solutions, and maintaining documentation, security, and development standards.
Requirements
- At least 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.
Nice To Haves
- Experience designing enterprise data warehouse solutions that integrate 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.
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 for 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.
- Optimize SQL queries, analyze execution plans, create indexes, and tune database performance.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
