Data Engineer Ii.info Tech - Operations

Mid-Level Technical Contributor

Mid-level technical contributor responsible for designing and maintaining robust data pipelines, performing data transformations, and supporting enterprise reporting and analytics efforts. Works across departments to build scalable solutions that ensure reliable, secure, and high-quality data is available to business users, analysts, and downstream applications. Contributes to data modeling, integration, testing, and documentation in collaboration with analysts, data scientists, developers, and system owners.

Designs, develops, and maintains scalable data pipelines and workflows across structured and semi-structured data sources. Writes performant and reusable SQL queries, scripts, or jobs for data ingestion, transformation, and delivery. Integrates internal and external data sources with enterprise data platforms, lakes, or warehouses. Performs data profiling, cleansing, and standardization to improve data quality. Monitors data pipeline health and troubleshoots failures or anomalies.

Documents pipeline architecture, business rules, and data logic for internal users. Collaborates with Dev Ops or infrastructure teams to implement automated data processing workflows. Maintains data access controls, validation rules, and retention policies. Translates business and analytics requirements into technical data specifications and pipeline designs. Participates in Agile planning, backlog grooming, and technical design sessions. Develops data flow diagrams, data models, and transformation logic.

Supports dataset design and delivery for dashboards, reports, or self-service analytics. Collaborates with application owners to understand source system structures and data changes. Contributes to solution architecture decisions related to ETL/ELT, storage, and data delivery. Assists in scoping and estimating new data initiatives and enhancement requests. Identifies reuse opportunities for data components, tools, or models. Builds in validation and error-handling logic into data pipelines to support reliability.

Performs root cause analysis for data inconsistencies and recommends preventive actions. Contributes to and follows testing procedures for data validation, performance, and integrity. Implements version control, data lineage, and reproducibility practices. Identifies performance bottlenecks and refactor inefficient data processes. Recommends improvements to schema design, data granularity, and source-system integration. Maintains awareness of industry standards for data governance, security, and accessibility.

Supports automation of routine data workflows and manual reporting processes. Works closely with analysts, data scientists, application developers, and stakeholders to deliver high-quality datasets. Coordinates with system owners and database administrators to manage source data access and schema changes. Supports QA and testing teams by validating expected outputs and data quality criteria. Participates in data design reviews, standups, retrospectives, and sprint demos.

Communicates technical limitations or trade-offs to business stakeholders in an understandable way. Partners with cybersecurity teams to ensure sensitive data is handled securely and in compliance with County policy. Engages with BI and reporting teams to ensure datasets meet visual and analytic needs. Assists in coordinating multi-team efforts involving shared data pipelines or platforms. Continues building technical proficiency in cloud platforms, big data tools, and data pipeline frameworks.

Pursues professional certifications (e.g., Azure Data Engineer, AWS Data Analytics, dbt, etc.). Stays current with trends in data engineering, streaming pipelines, and ML Ops practices. Contributes to internal wikis, playbooks, and best practices documentation. Mentors junior data engineers or interns on development and testing practices. Participates in knowledge-sharing sessions, communities of practice, or hackathons. Seeks opportunities for cross-training with related disciplines (e.g., analytics, Dev Ops).

Communicates progress, risks, and needs to project leads or data managers. Documents data sources, logic, and transformations in data dictionaries or metadata repositories. Support stakeholder training or onboarding on new datasets and data services. Assists in writing user guides, technical diagrams, and documentation for data pipelines. Participates in requirement gathering and feedback sessions with business users. Supports audit and compliance documentation as needed.

Provides timely responses to questions or data requests from supported teams. Coordinate deployment of data updates with impacted teams or systems. Performs other duties as assigned.

Education, Experience and Training:
Education and experience equivalent to a Bachelor's degree from an accredited college or university in Computer Science, Information Systems, Data Analytics, or in a job-related field of study. Four (4)…