Costquest Associates - Cincinnati, OH

posted 4 months ago

Full-time - Mid Level
Hybrid - Cincinnati, OH
11-50 employees
Telecommunications

About the position

We are seeking a skilled and analytical SQL Developer to join our team at CostQuest Associates, Inc. This role is ideal for a team-oriented individual who has a strong desire to learn and who enjoys the challenges of solving problems and creating solutions. If you are someone with SQL experience and who wants to learn new things and has a keen attention to detail, then this is the position for you. The SQL Developer will be responsible for developing and maintaining database systems, ensuring data integrity, and optimizing performance. You will work closely with other team members to design and implement data solutions that meet the needs of our clients, which include Fortune 100 companies and government departments. In this position, you will leverage your expertise in SQL and database management to extract, transform, and manipulate data. You will be expected to have a strong understanding of relational and dimensional database concepts, as well as experience with various database platforms such as Microsoft SQL Server, PostgreSQL, and others. Your role will also involve building data warehouses for analytics and performing spatial analysis in PostgreSQL. You will be responsible for writing stored procedures, views, triggers, and indexes using T-SQL, and you will have the opportunity to work with cloud database platforms like Azure and AWS. The SQL Developer will also be involved in project work, collaborating with other developers and stakeholders to deliver high-quality data solutions. You will be expected to demonstrate advanced knowledge of working with and optimizing large datasets, as well as a basic understanding of SSIS and SQL Server Reporting Services (SSRS). This position requires occasional travel to Seattle and other locations, and candidates must meet U.S. Government clearance requirements. If you are ready to take on new challenges and contribute to our mission of providing exceptional consulting services, we encourage you to apply.

Responsibilities

  • 3-5 years of development experience with Microsoft SQL Server 2012 or newer versions working with relational models to extract, transform and manipulate data
  • Experience using PostgreSQL
  • Strong understanding of relational and dimensional database concepts
  • Strong understanding of database architecture and design
  • Strong understanding of spatial analysis in PostgreSQL
  • Advanced knowledge working with and optimizing large datasets
  • Knowledge of building Data warehouses for analytics
  • Strong understanding of file management concepts, processes, and tools
  • Knowledge of stored procedures, views, triggers, and indexes using T-SQL
  • Basic knowledge of SSIS and SQL Server Reporting Services (SSRS)
  • Demonstrated SQL development and project work

Requirements

  • Experience programming and/or scripting using languages such as Python, Java, VB.NET
  • Experience working with PowerBI
  • Experience working with Cloud Databases Platforms (Azure, AWS, etc)
  • Experience with other databases (SQLite, BigQuery, MySQL, Snowflake)
  • Ability to pass a U.S. Public Trust background investigation for access to the client site and computing systems
  • Must have lived in the U.S. for the past three (3) years

Nice-to-haves

  • Experience with GIS (Geographic Information Systems) solutions
  • Familiarity with data visualization tools
  • Knowledge of data governance and data quality best practices

Benefits

  • Profit sharing
  • Health savings account
  • Disability insurance
  • Health insurance
  • Dental insurance
  • Parental leave
  • Employee assistance program
  • Vision insurance
  • 401(k) matching
  • Employee stock ownership plan
  • Professional development assistance
  • Flexible schedule
  • Vacation (10 days - increasing with years of service)
  • Sick leave (5 days)
  • 10 Paid Holidays
  • Tuition reimbursement
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service