Data Engineer

OneBlood•Orlando, FL

34d

About The Position

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.

Requirements

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.
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.

Nice To Haves

Database Certification (SQL Server and Oracle) preferred.

Responsibilities

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.