SQL Engineer

The SQL Engineer designs, develops, and optimizes the organization’s data solutions with a primary focus on Microsoft SQL Server (including SSIS for ETL and SSRS for reporting). This role builds robust databases, data pipelines, and reports to support both operational applications and business intelligence needs, ensuring data from various sources (e.g. MySQL databases and external APIs) is integrated into a usable format. The SQL Engineer works closely with cross-functional teams (DevOps, Business Intelligence, etc.) to gather requirements and deliver data solutions that align with business objectives. Note : This position excludes general system / database administration tasks (e.g. server patching, user account management, business intelligence platforms administration), which are handled by other teams, allowing the developer to focus exclusively on data development and integration.

This position is hybrid and requires 3 days in the Raleigh, NC, or New York City office.

Primary Job Duties include

• 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.

Required Skills, Specialized Knowledge and Competency Requirements

The salary range for this position in New York City is $120,000-$145,000 / year; however salary offered may vary depending on skills, experience, job-related knowledge and location.