This is a multi-level posting. Candidates may be considered for any of the posted levels 14/15/16/17, depending on their level of experience and depth of expertise.
As a Data Engineer, you will design, build, and maintain scalable data pipelines and infrastructure to support analytics, reporting, and data science initiatives. You will work closely with cross-functional teams to ensure data is accessible, reliable, and secure across the organization.
Bachelor's degree in information systems, computer science or related technical field or equivalent work experience. (Typically four years of additional related, progressive work experience would be needed for candidates applying for this position who do not possess a bachelor's degree.)
A minimum of two years additional direct related technical experience in IT operations or data engineering experience with foundational knowledge of database structures, principles, and practices. is required for the level 1.
A minimum of three or more years additional direct related technical experience in data engineering, data integration, or database administration, with hands-on experience in Azure data services and pipeline development is required for the level 2 and 3.
Six or more years of experience with advanced knowledge of data architecture, cloud platforms (especially Azure), and enterprise data solutions is required for the sr level.
Proficiency in data engineering tools and platforms, especially Azure Data Factory and Azure Databricks.
Strong understanding of data modeling, ETL/ELT processes, and performance tuning of enterprise-level applications.
Expert-level knowledge of data-related technologies from architecture to administration, including design, development, optimization, and licensing.
Proven experience working in the utility industry is required
Effective oral and written communication skills, with the ability to collaborate across teams and mentor junior engineers.
Strong analytical and problem-solving abilities.
Ability to prioritize and manage multiple tasks and projects concurrently.
Employees must be able to perform the essential functions of the position, with or without an accommodation.
All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.
Primary Job Duties and Responsibilities (Essential Job Functions)
Design and Develop Scalable Data Pipelines
- Design and implement scalable data ingestion and transformation frameworks using Azure services enabling structured, semi-structured, and unstructured data to be efficiently processed and integrated into enterprise data platforms
- Build and maintain robust ETL/ELT pipelines using Azure Data Factory and Azure Databricks.
- Integrate data from diverse sources including on-premises systems, cloud storage, APIs, and streaming platforms.
Databricks Development and Optimization
- Develop and optimize notebooks and workflows in Azure Databricks using PySpark, SQL.
- Implement Delta Lake for efficient data storage, versioning, and ACID transactions.
- Leverage Databricks features such as Unity Catalog and job orchestration.
Data Modeling and Architecture
- Design and implement data models (star/snowflake schemas) for analytics and reporting.
- Collaborate with architects to define data lakehouse architecture and best practices.
- Hands-on experience implementing and optimizing data solutions using the Medallion Architecture (Bronze, Silver, Gold layers) for scalable and structured data processing
Data Quality and Governance
- Implement data validation, profiling, and cleansing routines.
- Ensure compliance with data governance policies, including data lineage and metadata management.
Performance Tuning and Monitoring
- Monitor and optimize performance of Spark jobs and data pipelines.
- Troubleshoot and resolve issues related to data latency, job failures, and resource utilization.
Collaboration and Stakeholder Engagement
- Work closely with data scientists, analysts, and business units to understand data requirements.
- Translate business needs into technical solutions that are scalable and maintainable.
Security and Compliance
- Implement role-based access control (RBAC), encryption, and secure data handling practices.
- Ensure compliance with industry regulations (e.g., NERC CIP, GDPR, HIPAA if applicable).
Documentation and Best Practices
- Maintain clear documentation of data flows, architecture, and operational procedures.
- Promote best practices in code versioning, testing, and CI/CD for data engineering.
Pay Range: 77,200-146,700
Data & Analytics (1)