Data Engineer (SQL Server & PostgreSQL)

Costquest Associates - Cincinnati, OH

Full-time - Mid Level

Cincinnati, OH

Telecommunications

About the position

CostQuest Associates is seeking a skilled Data Engineer specializing in SQL Server and PostgreSQL to join their team in Cincinnati, Ohio. This hybrid position is ideal for a team-oriented individual with a strong desire to learn and solve complex problems. The role involves designing, developing, and maintaining database infrastructure while ensuring data quality and consistency across various data-driven initiatives.

Responsibilities

• Designing, developing and maintaining database infrastructure
• Creating and managing data pipelines, ensuring data quality and consistency
• Collaborating with various teams to support data-driven initiatives
• Integrating data from various sources into SQL Server and PostgreSQL databases
• Creating stored procedures that analyze, automate, and transform data
• Building and optimizing workflows to support analytics, reporting and operational processes
• Designing and managing database schemas, tables, indexes and other data objects in SQL Server and PostgreSQL
• Developing and enforcing data governance policies and best practices
• Monitoring and optimizing database performance, including query tuning, indexing strategies, and resource utilization
• Working closely with data analysts, data scientists, and application developers to understand data requirements and deliver appropriate solutions
• Providing technical support and troubleshooting for data-related issues
• Documenting data workflows, database structures and ETL processes
• Preparing, maintaining and developing documentation methods and best practices for data processes

Requirements

• 3-5 years of data engineering experience using SQL Server and PostgreSQL
• Proficiency in SQL Server and PostgreSQL, including database design, query optimization and performance tuning
• Strong proficiency in SQL and scripting languages such as Python, Java, VB.NET or PowerShell
• Familiarity with data modeling, data warehousing concepts and PowerBI
• Excellent problem-solving and analytical skills
• Strong communication skills with the ability to collaborate across teams
• Attention to detail and a commitment to delivering high-quality data solutions

Nice-to-haves

• Experience with cloud platforms (e.g., AWS, Azure, etc) and their data services
• Knowledge of data security and compliance requirements
• Familiarity with version control systems (e.g., Git)

Benefits

• Competitive Salary and Benefits
• Bonus Pay and Profit Sharing
• Employee Stock Ownership Plan (ESOP)
• 401(k) matching
• Health insurance
• Company paid Dental, Vision, Life, and LTD insurance
• Employee assistance program
• Flexible schedule
• Health savings account
• Vacation (10 days - increasing with years of service)
• Sick (5 days)
• 10 Paid Holidays
• Parental leave
• Professional development assistance
• Tuition reimbursement