Data Analyst / SQL Specialist at CRAE GROUP

Capon Bridge, West Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

13 Sep, 26

Salary

70000.0

Posted On

15 Jun, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Analysis, Query Optimization, Relational Databases, MySQL, PostgreSQL, Data Validation, Business Analysis, Debugging, Technical Communication, Metabase, Power BI, Tableau, Looker, Laravel, PHP

Industry

IT System Custom Software Development

Description

We are looking for a strong Data Analyst / SQL Specialist to support our teams with one-off data reports, SQL query writing, and SQL query review across our internal platforms. This is a hands-on role for someone who is comfortable working directly with databases, understanding business questions, and turning them into accurate and reliable SQL outputs. We need someone pragmatic, detail-oriented, and able to work closely with technical, product, finance, CRM, and management stakeholders to provide clear and trustworthy data. Ownership is a key element of this role. We are not just looking for someone who can write queries on request, but for someone who can understand the context behind a report, challenge unclear requirements, validate the logic, identify risks in the data and help ensure that the numbers being used by the business are correct. What you will do • Create one-off reports using SQL based on business and operational requests • Translate reporting needs from management, product, finance, CRM, and operations into accurate data outputs • Write, review, and improve SQL queries used in reports, dashboards, exports, and internal tools • Analyze existing queries to identify issues such as incorrect joins, duplicate counting, wrong aggregations, missing filters, or inefficient logic • Review slow or heavy queries and suggest improvements to performance and structure • Help validate that reported numbers are accurate and aligned with business definitions • Recommend improvements to query structure, indexes, views, or reporting approaches where relevant • Document the logic behind important reports and recurring SQL queries • Collaborate with developers and stakeholders to clarify requirements and edge cases • Raise concerns early when data may be incomplete, misleading, or incorrectly interpreted What we are looking for • Strong SQL experience in production environments • Ability to write, review, and optimize complex SQL queries • Good understanding of joins, aggregations, subqueries, CTEs, indexes, and query execution logic • Experience working with relational databases such as MySQL, PostgreSQL, or similar • Ability to understand business requirements and convert them into reliable data outputs • Strong attention to detail and ability to identify inconsistencies in data • Good debugging and investigation skills when numbers do not match expectations • Ability to explain query logic and findings clearly to both technical and non-technical stakeholders • Practical mindset with the ability to improve existing queries without overengineering • Clear communication and a strong sense of ownership Nice to have • Experience with BI or reporting tools such as Metabase, Power BI, Tableau, Looker, or similar • Experience working with Laravel/PHP-based applications or product databases • Experience with finance, CRM, payments, user activity, gaming, or high-volume transactional data • Understanding of database performance analysis and execution plans • Ability to suggest improvements to reporting structures, not only individual queries • Experience working with dashboards, exports, and recurring business reports Who you are You are comfortable working with existing databases, understanding how data is structured, and turning business questions into practical SQL reports. You know how to balance speed with accuracy, and you care about producing outputs that people can trust. You communicate clearly, ask the right questions, raise issues early, and do not just assume that a query is correct because it returns a result. You take responsibility for the logic behind your work, think beyond the request itself, and care about the reliability of the final numbers. We are looking for someone who is dependable, analytical and comfortable being accountable for the quality of the final output. This role is a strong fit for someone who likes structure, cares about accuracy and wants to work with real business data rather than simply producing isolated queries. Salary range: €45,000 – €70,000 gross per year, depending on experience and seniority level.

Responsibilities

The role involves creating one-off reports and writing, reviewing, and optimizing complex SQL queries to support various business stakeholders. The specialist is responsible for ensuring data accuracy, validating logic, and documenting reporting processes.