View All Jobs 158477

Data Engineer

Redesign and optimize PostgreSQL architecture to support scalable analytical models
Cincinnati, Ohio, United States
Senior
23 hours agoBe an early applicant
KY Staffing

KY Staffing

KY Staffing appears to be a government-associated entity focused on providing employment services within the state of Kentucky.

Data Engineer

We are looking for an experienced Data Engineer to take a leading role in optimizing and transforming our data architecture. This position will focus on enhancing performance, scalability, and analytical capabilities within our systems. The ideal candidate will have a strong technical background and the ability to mentor teams while delivering innovative solutions.

Responsibilities:

  • Redesign the existing PostgreSQL database architecture to support modern analytical models and improve overall system performance.
  • Optimize schemas by balancing normalization with denormalization techniques to achieve faster analytical reads.
  • Implement advanced strategies such as indexing, partitioning, caching, and replication to ensure high-throughput and low-latency data delivery.
  • Develop and maintain scalable data pipelines to guarantee accurate and timely data availability across distributed systems.
  • Collaborate with engineering teams to provide guidance on data modeling, query optimization, and architectural best practices.
  • Monitor and troubleshoot database performance issues, ensuring solutions are implemented effectively.
  • Lead efforts to enhance the reliability and scalability of data infrastructure to support future growth.
  • Serve as a technical mentor to team members, sharing expertise in database architecture and performance tuning.
  • Partner with stakeholders to understand data requirements and deliver solutions that meet business needs.
  • Requirements:

    • Minimum of 5 years of experience in senior-level data engineering or database architecture roles.
    • Expert-level proficiency in PostgreSQL, including schema design, optimization, and performance tuning.
    • Proven track record of transforming complex systems into efficient analytical data warehouses.
    • Advanced knowledge of database strategies such as indexing, partitioning, caching, and replication.
    • Hands-on experience designing and managing scalable data pipelines in cloud environments.
    • Strong skills in Amazon Web Services (AWS) and other modern data infrastructure tools.
    • Excellent communication skills, with the ability to convey technical concepts to non-technical stakeholders.
    • Ability to mentor and lead teams while driving technical innovation and best practices.
+ Show Original Job Post
























Data Engineer
Cincinnati, Ohio, United States
Engineering
About KY Staffing
KY Staffing appears to be a government-associated entity focused on providing employment services within the state of Kentucky.