SQL Engineer

Raleigh, WV - USA

Yearly Salary: $ 120000 - 145000

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

The SQL Engineer designs develops and optimizes the organizations 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

- 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