About the position
At KorTerra, we’re on a mission to prevent damage and save lives through innovative technology solutions for the energy and utilities industries. Our collaborative and customer-focused environment empowers us to deliver impactful products that truly make a difference. We are seeking a highly skilled and visionary Principal Data Engineer to lead the strategy, architecture, and implementation of data engineering solutions across global projects and platforms. This role will be responsible for designing and developing scalable, high-performance data systems, fostering best practices, and ensuring data quality, security, and governance. As a Principal Data Engineer, you will collaborate with cross-functional teams, including data scientists, analysts, engineers, and business leaders, to drive technical innovation and ensure the successful delivery of cutting-edge data solutions. This role requires strong expertise in data pipelines, cloud computing, big data technologies, and data modeling, along with a passion for mentoring teams and shaping data engineering best practices.
Responsibilities
- Define and implement best practices for data architecture, governance, modeling, and integration to support analytics and business intelligence initiatives.
- Build robust, high-performance ETL/ELT pipelines using Azure Data Factory (ADF), SQL Server Integration Services (SSIS), and Snowflake for data ingestion, processing, and transformation.
- Develop and optimize data warehouses and lakehouses on Azure and Snowflake, ensuring scalability, reliability, and performance.
- Architect and maintain distributed data processing systems within Azure, leveraging technologies such as Azure Data Factory (ADF), SQL Server, Snowflake, and Power BI.
- Work closely with Principal Architects, data scientists, analysts, and IT teams to ensure alignment between business goals and technical requirements.
- Oversee the monitoring, maintenance, and optimization of data pipelines and infrastructure to ensure high availability, scalability, and reliability.
- Drive the evaluation and adoption of new tools, frameworks, and methodologies to improve data engineering efficiency and effectiveness.
- Ensure compliance with data quality, security, and governance policies, implementing data encryption, access control, and authentication best practices.
- Utilize Power BI for data visualization, reporting, and analytics, ensuring business users have access to actionable insights.
- Lead and mentor engineering teams, fostering a culture of technical excellence, innovation, and continuous learning.
Requirements
- 7+ years of professional experience in data engineering, big data technologies, or software development.
- Expertise in SQL, SQL Server, Snowflake, and Azure Data Factory (ADF) for big data processing and analytics.
- Strong hands-on experience with Azure data ecosystem (Azure Data Lake, Azure Synapse Analytics, Power BI).
- Extensive experience with ETL/ELT pipelines, data transformation, and automation using ADF, SSIS, or similar tools.
- Deep understanding of data modeling, warehousing, and governance practices.
- Experience with distributed computing, stream processing (Kafka, Kinesis), and event-driven architectures.
- Strong background in relational (SQL Server, PostgreSQL) and NoSQL databases (CosmosDB, DynamoDB).
- Experience with DevOps, CI/CD pipelines, Infrastructure as Code (IaC) tools such as Terraform or CloudFormation.
- Knowledge of data orchestration tools such as Apache Airflow or Temporal.io.
- Excellent problem-solving skills, strategic thinking, and ability to make data-driven technical decisions.
- Strong leadership, communication, and cross-functional collaboration skills.
Benefits
- Medical, Dental and Vision
- Flexible PTO Program
- Paid Sick and Safe Leave
- 401k with company match
- Life Insurance, LTD, and AD&D Insurance
- Flexible Spending Accounts
- Monthly company events
- Hybrid and flexible work schedule
- Professional development stipend
- and much more!
