SQL Developer

Kentro LLC
Woodlawn, United States of America
22 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 110K

Job location

Woodlawn, United States of America

Tech stack

Data analysis
Business Logic
JIRA
Big Data
Databases
Data Files
Data Integration
ETL
Data Systems
Database Storage Structures
Microsoft SQL Server
Operational Data Store
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Tableau
Technical Data Management Systems
T-SQL
Amazon Connect
Data Processing
Custom Reports

Job description

  • Query Development & Optimization: Design, write, and optimize complex T-SQL queries, stored procedures, and scripts within SQL Server to extract large volumes of data related to contact center performance and field office operations.
  • Management Information (MI) & BI Reporting: Transform raw operational data into structured, accurate datasets. Develop and maintain impactful visual dashboards in Tableau, as well as paginated operational reports using SQL Server Reporting Services (SSRS).
  • Contact Center Data Analysis: Extract and integrate key operational metrics, including agent performance, call routing efficiency, handle times, and workforce management (WFM) scheduling data.
  • Field Office Support Metrics: Develop queries that track field office workflows, support ticketing trends, and regional operational efficiency to provide a holistic view of agency performance.
  • Collaboration & Agile Delivery: Work closely with technical directors, stakeholders, and business analysts to translate federal agency requirements into technical data solutions. Manage and document development tasks using Jira., * Willing and able to obtain and maintain Public Trust Clearance
  • Must meet updated ID requirements: https://www.gsa.gov/technology/it-contract-vehicles-and-purchasing-programs/federal-credentialing-services/get-appointment-help/bring-required-documents
  • If you do not currently meet the ID requirements outlined, you must be willing and able to update your current forms of ID in a timely manner to complete the suitability process successfully.

Requirements

The ideal candidate has a deep understanding of operational metrics, CCaaS environments, and the Microsoft SQL Server ecosystem, with the ability to build end-to-end data solutions from extraction to visualization., * Experience: 3-5+ years of dedicated experience in SQL Server development (T-SQL) with a strong focus on data manipulation and ETL processes.

  • Database & Reporting Stack: Proven hands-on experience with the Microsoft BI Stack, specifically SSIS for data integration and SSRS for report generation.
  • Domain Expertise: Experience working with contact center data sets (e.g., ACD, IVR, WFM, and quality management metrics) and operational performance data.
  • Analytical Skills: Strong ability to understand complex business logic and translate federal operational requirements into precise data outputs.

Preferred Qualifications:

  • Workforce Management Platforms: Experience with custom report development and database structures for the Verint Workforce Management platform is highly desired.
  • Federal Experience: Prior experience supporting federal or public sector clients.
  • CCaaS: Familiarity with modern enterprise CCaaS platforms (such as Amazon Connect) and their data outputs

Benefits & conditions

Salary Range: $100,000-110,000/annually. Factors influencing pay within this range include geography, market demand, skills, education, experience, and other qualifications of the successful candidate., We offer competitive benefits package including paid time off, healthcare benefits, supplemental benefits, 401k including an employer match, discount perks, rewards, and more. We invest in our employees - Every employee is eligible for education reimbursement for certifications, degrees, or professional development. Reimbursement amounts may fluctuate due to IRS limitations. We want you to grow as an expert and a leader and offer flexibility for you to take a course, complete a certification, or other professional growth and networking. We are committed to supporting your curiosity and sustaining a culture that prioritizes commitment to continuous professional development.

About the company

By joining our supportive community, you will find that Kentro is dedicated to your personal and professional development. Together, we can drive meaningful change, spark innovation, and achieve extraordinary milestones., We believe in generating success collaboratively, enabling long-term mission success, and building trust for the next challenge. With you as our partner, let's solve challenges, think innovatively, and maximize impact. As a valued member of our team, you have the unique opportunity to work in a diverse range of technology and business career paths, all while supporting our nation and delivering innovative technology solutions. We are a close community of experts that pride ourselves on creating an environment defined by teamwork, dedication, and excellence. We hold three ISO certifications (27001:2013, 20000-1:2011, 9001:2015), two CMMI ML 3 ratings (DEV and SVC) and CMMC Level 2 Certification. Industry Recognition Growth | Inc 5000's Fastest Growing Private Companies, DC Metro List Fastest Growing; Washington Business Journal: Fastest Growing Companies, Top Performing Small Technology Companies in Greater D.C. Culture | Northern Virginia Technology Council Tech 100 Honoree; Virginia Best Place to Work; Washington Business Journal: Best Places to Work, Corporate Diversity Index Winner - Mid-Size Companies, Companies Owned by People of Color; Department of Labor's HireVets for our work helping veterans transition; SECAF Award of Excellence finalist; Victory Military Friendly Brand; Virginia Values Veterans (V3); Cystic Fibrosis Foundation Corporate Breath Award, We work hard; we play hard. Kentro is committed to incorporating fun into every day. We dedicate funds for activities - virtual and in-person - e.g., we host happy hours, holiday events, fitness & wellness events, and annual celebrations. In alignment with our commitment to our communities, we also host and attend charity galas/events. We believe in appreciating your commitment and building a positive workspace for you to be creative, innovative, and happy. Commitment Equal Opportunity Employment & VEVRAA Kentro is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state or local law. Kentro is strongly committed to compliance with VEVRAA and other applicable federal, state, and local laws governing equal employment opportunity. We have developed comprehensive policies and procedures to ensure our hiring practices align with these requirements. As part of our VEVRAA compliance efforts, Kentro has established an equal opportunity plan outlining our commitment to recruiting, hiring, and advancing protected veterans. This plan is regularly reviewed and updated to ensure its effectiveness.

Apply for this position