Data Engineer - SQL & Analytics

Metronet is one of the nation’s fastest-growing fiber-optic powerhouses, dedicated to building communities through advanced connectivity solutions. The Data Engineer will focus on writing and optimizing SQL, designing data models, and developing data pipelines to support business analytics and reporting needs.

Responsibilities:

• Write, review, optimize, and troubleshoot complex SQL queries that support business reporting, analytics, and data transformation
• Design and develop data serving and semantic layers to support business needs ranging from traditional reporting to reverse ETL and LLM/AI implementations
• Design and develop dimensional data models, semantic layers, and analytics-ready datasets that provide accurate, consistent data for reporting, self-service analytics, and business applications
• Build and maintain robust, scalable data pipelines to extract, transform, and load (ETL, ELT) data from various sources into the data platform using both batch processing and event-driven patterns
• Implement and automate data quality checks and monitoring to ensure data accuracy and drive observability
• Manage, troubleshoot and optimize existing data infrastructure, including cloud-based solutions and on-premises systems
• Leverage modern cloud data platforms such as Microsoft Fabric, Databricks, and Snowflake for data storage, transformation, and analytics
• Work closely with data analysts, data scientists, and business stakeholders to understand their data needs and deliver solutions
• Identify and resolve data-related issues and challenges for technical and non-technical stakeholders
• Support company-wide projects ranging from server migrations to mergers and acquisitions as a data and systems expert
• Automate data processes to improve efficiency and reduce manual effort. Implement modern concepts like metadata-driven pipelines and Infrastructure-as-Code that will play a key role in a scalable, resilient data platform
• Document data processes, architecture, and workflows
• All other duties as assigned

Requirements:

• Bachelor's degree in computer science, engineering, or a related field
• 3 – 5 years of experience as a Data Engineer or Analytics Engineer
• Advanced SQL skills are required, including experience writing, optimizing, and troubleshooting complex SQL queries used in production environments
• Experience with Spark (PySpark, Spark SQL, etc.)
• Experience with developing bespoke data pipelines and handling various authentication patterns
• Experience partnering directly with business stakeholders to gather requirements and translate them into scalable technical solutions
• Experience with data warehousing and data lake technologies, concepts and best practices
• Experience designing dimensional models and semantic layers for reporting and analytics
• Understanding of data modeling and ETL processes and best practices
• Experience within Azure, AWS, or similar cloud environments
• Strong analytical and problem-solving skills
• Experience implementing data quality monitoring and observability solutions
• Willingness to work as a team and independently
• Must be legally authorized to work in the U.S
• Previous experience in analytics engineering, business intelligence, reporting, or data analytics is a plus
• Experience working on small, collaborative engineering teams where individuals are expected to own solutions from requirements through implementation is preferred
• Experience building and maintaining production dbt models is strongly preferred
• Experience with Microsoft Fabric, Databricks, Snowflake, or other modern cloud data platforms is preferred