American Kennel Club · 4 hours ago
SQL Engineer
Raleigh, North Carolina, United States
Full-time
Hybrid
Mid Level
$120K/yr - $145K/yrAmerican Kennel Club is seeking a SQL Engineer to design, develop, and optimize data solutions with a focus on Microsoft SQL Server. The role involves building databases, data pipelines, and reports while collaborating with cross-functional teams to ensure data integration and quality.
AssociationCommunitiesEducationEventsGovernmentNon ProfitSports
Responsibilities
Design, develop, and maintain MS SQL Server databases – Create and update database objects (tables, views, stored procedures, functions) and write efficient T-SQL queries, ensuring proper schema design and indexing for performance
Develop ETL workflows using SSIS – Build and manage SQL Server Integration Services packages to extract, transform, and load data from various internal/external sources into data warehouses and databases
Integrate data via RESTful APIs – Create solutions to import and sync data from third-party systems using APIs; parse JSON/XML data into SQL tables and automate regular data pulls, monitoring for completeness and failures
Create reports and support BI using SSRS – Develop and maintain SQL Server Reporting Services reports; provide aggregated datasets or views for analytics, ensuring data presented to end-users is accurate and timely (while BI platform administration is handled by a separate team)
Perform MySQL database development – Write and optimize MySQL queries and assist in migrating or transforming data between MySQL and MS SQL environments as needed (MySQL server administration is handled elsewhere)
Ensure data quality and troubleshoot issues – Validate data in pipelines and databases, and investigate anomalies or errors in ETL processes; identify root causes of data issues and implement fixes to maintain data integrity
Optimize database performance – Monitor database and query performance; tune T-SQL code and indexes for efficiency; collaborate with infrastructure DBAs on any server-level optimizations or configurations needed
Collaborate and document – Work with developers, analysts, and system admins to understand requirements and implement data solutions; document database schemas, ETL processes, and integration workflows to ensure team knowledge sharing and continuity
Performs other related duties as assigned to meet organizational needs
Qualification
Required
Advanced T-SQL development and relational database design (MS SQL Server)
Strong experience in ETL development using SSIS or similar tools
Strong experience in Report development using SSRS or comparable BI platforms
Experience in MySQL query development and cross-platform SQL proficiency
RESTful API integration and data transformation
Query optimization and performance tuning
Data validation and troubleshooting of ETL/data issues
Strong collaboration, documentation, and communication skills
Company
American Kennel Club
The AKC is a not-for-profit organization and a purebred dog registry that supports and enriches the lives of purebred and mixed-breed dogs.
Founded in 1884
201-500 employees
H1B Sponsorship
American Kennel Club has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (2)
Funding
Current Stage
Growth StageLeadership Team
Ted Phillips
Chief Financial Officer
Jerry Klein
Chief Veterinary Officer
Recent News
2026-01-16
2025-12-18
Company data provided by crunchbase