SQL Data Analyst

Insight Global; Miami (FL); On-site; USD 90,000 - 120,000; Full time

Job summary

Insight Global in Miami seeks a data operations professional with strong SQL skills to manage operational datasets from multiple clients and platforms. You will write complex SQL queries and maintain centralized data repositories to ensure accuracy and timely reporting.

The role focuses on data reconciliation, quality, validation, and building recurring reports, collaborating with cross-functional teams to support audits and process improvements.

Qualifications

• Bachelor's or MBA in equivalent field.
• 2-5 years of SQL/data operations experience.
• Hands-on SQL Server / SSMS experience.
• Experience building/modifying stored procedures, SQL tables, views.
• Experience managing data from multiple source systems and maintaining data integrity.
• Experience developing SQL-driven operational reporting.
• Ability to troubleshoot data issues and perform root-cause analysis.

Responsibilities

• Manage operational datasets coming from multiple clients, platforms, and source systems.
• Build and maintain SQL tables and centralized data repositories.
• Write complex SQL queries to extract, transform, reconcile, and analyze data.
• Build and maintain stored procedures and SQL-driven processes.
• Reconcile data across servicing systems and other data sources.
• Research discrepancies and identify the root cause of data variances.
• Monitor and improve data integrity, quality, validation, and normalization.
• Build recurring operational reports based on business/data requirements.
• Support audit readiness and ensure underlying data can be accurately validated.
• Support process improvements by identifying inefficient data or operational workflows.

Skills

SQL Server / SSMS

Stored procedures & views

Data normalization & quality

Data reconciliation

Root-cause analysis

Operational reporting

Multi-source data handling

Education

Bachelor's degree or MBA in relevant field

Tools

SQL Server Management Studio (SSMS)

Job description

• Bachelors or MBA graduates in equivalent work field
• 2-5 years of relevant SQL/data operations experience
• Strong hands-on SQL Server / Microsoft SQL Server Management Studio (SSMS)
• Experience building or modifying stored procedures, SQL tables, views, and other database objects
• Experience managing data from multiple source systems and maintaining data integrity, quality, validation, and normalization
• Experience developing SQL-driven operational and recurring reporting, rather than primarily consuming prepared datasets for dashboards
• Ability to troubleshoot data issues and perform root-cause analysis

Nice to Haves:

• Strong data reconciliation experience, including comparing large datasets across multiple systems and investigating discrepancies

Day-to-Day

• Manage operational datasets coming from multiple clients, platforms, and source systems
• Build and maintain SQL tables and centralized data repositories
• Write complex SQL queries to extract, transform, reconcile, and analyze data
• Build and maintain stored procedures and SQL-driven processes
• Reconcile data across servicing systems and other data sources
• Research discrepancies and identify the root cause of data variances
• Monitor and improve data integrity, quality, validation, and normalization
• Build recurring operational reports based on business/data requirements
• Support audit readiness and ensure underlying data can be accurately validated
• Support process improvements by identifying inefficient data or operational workflows