You are viewing a preview of this job. Log in or register to view more details about this job.

Data Engineer / Sr. Data Processing System Programmer

Passaic Valley Water Commission
Email

Job Title: Data Engineer / Sr. Data Processing System Programmer

Job Summary:

We are seeking a highly skilled and detail-oriented Data Engineer to design and implement scalable data solutions and dashboards that empower data-driven decision-making across the organization. This role requires strong expertise in SQL, Python, and Power BI, along with a solid foundation in data architecture, ETL processes, and cloud technologies.

Key Responsibilities:

  • Design, develop, and maintain data pipelines and ETL processes to support analytics and reporting.
  • Build and optimize Power BI dashboards and reports to visualize key performance indicators and business metrics.
  • Write advanced SQL queries for data extraction, transformation, and analysis across multiple data sources.
  • Use Python for data wrangling, automation, API integration, and custom analytics workflows.
  • Collaborate with cross-functional teams to gather requirements and deliver data solutions aligned with business goals.
  • Ensure data quality, governance, and security across all data assets and reporting tools.
  • Monitor and troubleshoot data workflows, ensuring high availability and performance.
  • Document data models, data dictionaries, and dashboard logic for transparency and maintainability.

Required Technical Skills:

  • SQL: Advanced query writing, performance tuning, stored procedures, and data modeling.
  • Python: Data manipulation (Pandas, NumPy), scripting, automation, and API integration.
  • Power BI: DAX, Power Query (M), data modeling, and dashboard design.
  • ETL Tools: Experience with tools like Azure Data Factory, Apache Airflow, or similar.
  • Data Warehousing: Knowledge of star/snowflake schemas, dimensional modeling, and OLAP concepts.
  • Platform (especially services like Azure SQL, S3, BigQuery, etc.).
  • Version Control: Git/GitHub or similar tools for code and pipeline versioning.
  • Data Formats: JSON, Parquet, Avro, CSV, XML.
  • APIs: RESTful API integration for data ingestion and automation.
  • CI/CD: Familiarity with DevOps practices for data pipelines and dashboard deployment.

Preferred Qualifications:

  • Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
  • 2+ years of experience in a data engineering or analytics engineering role.
  • Experience with data governance, data cataloging, and metadata management tools.
  • Familiarity with containerization (Docker) and orchestration tools (Kubernetes) is a plus.
  • Experience with real-time data processing (e.g., Kafka, Spark Streaming) is a bonus.

 

Apply: Job Announcements - Passaic Valley Water Commission