Data Engineer

Designs, builds, and maintains scalable data pipelines and platforms that support analytics, reporting, and data science. Designs, implements and oversees the physical design and operation of the organization's databases in order to maintain security and integrity controls. Ensures reliable data ingestion, transformation, and availability across the organization while enforcing data quality, security, and performance standards.

The list of essential functions, as outlined herein, is intended to be representative of the duties and responsibilities performed within this classification. It is not necessarily descriptive of any one position in the class. The omission of an essential function does not preclude management from assigning duties not listed herein if such functions are a logical assignment to the position.

Develops advanced data sets using SQL queries
• Performs data mapping and migrations
• Oversees daily production operations, non-production and redundant database environments
• Designs, develops, and maintains robust ETL/ELT pipelines for structured and unstructured data
• Builds and optimizes data models for analytics, dashboards, and downstream applications
• Manages data ingestion from APIs, databases, flat files, and streaming sources
• Ensures data reliability through monitoring, validation, and error handling
• Collaborates with analysts, data scientists, and application teams to define data requirements
• Formulates policies, procedures, and standards relating to database management and maintains security and integrity controls, monitoring transaction activity and utilization
• Reviews database design and integration of systems and makes recommendations regarding enhancements and/or improvements
• Develops, manages and tests back-up and recovery plans ensuring that all procedures are functioning properly
• Advises organization leaders on database concepts and functional capabilities and recommend system changes to programming staff.

To perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

EDUCATION AND/OR EXPERIENCE:

Bachelor's degree in a computer related field from an accredited college or university and six (6) years of experience in related field; or an equivalent combination of education, certification, training, and/or experience.

CERTIFICATES, LICENSES, REGISTRATIONS AND DESIGNATIONS:

Database Certification (SQL Server and Oracle) preferred.

KNOWLEDGE, SKILLS AND ABILITIES:

• Ability to organize work for timely completion
• Ability to speak, write, read, and understand English
• Ability to follow complex oral and written instructions
• Ability to communicate effectively orally and in writing
• Ability to establish and maintain effective and cooperative working relationships with those contacted in the course of work
• Strong proficiency in SQL, Python and SSIS.
• Experience building data pipelines using tools such as Airflow, DBT, or similar
• Experience doing large scale data migrations using TSQL and PLSQL
• Experience with cloud data platforms such as AWS, Azure, or GCP
• Experience with data warehouses such as Snowflake, BigQuery, or Redshift
• Familiarity with version control systems (Git)
• Experience with real-time or streaming data (Kafka, Kinesis, Pub/Sub)
• Knowledge of CI/CD for data pipelines
• Skill in Microsoft Office applications
• Ability to travel up to 10% of the time
• Ability to commute with personal transportation.

PHYSICAL REQUIREMENTS:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Ability to exert light physical effort in sedentary to light work, which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight (up to 20 pounds).

ENVIRONMENTAL REQUIREMENTS:

The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this job.

Functions are regularly performed inside without potential for exposure to adverse conditions, such as inclement weather, atmospheric elements and pathogenic substances. The noise level in the work environment is usually moderate.