Why This Role Stands Out
This hybrid role offers significant career growth by leveraging your advanced SQL expertise to drive data integrity and translate complex business needs into actionable insights. If you are a seasoned analyst who thrives on detailed data validation and impactful problem-solving, this is an excellent opportunity to contribute to a reputable company and further develop your skills.
Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Detroit, MI, United States
Posted
22 hours ago
ScrumAgileBusiness AnalysisJiraRequirements Gathering
Job Description
- 12+ years of experience in Business Analysis, Data Analysis, QA/Data Testing, or related roles with strong hands-on SQL expertise.
- Analyze business requirements and translate functional requirements into SQL queries for data retrieval, validation, reconciliation, and analysis.
- Develop complex SQL queries using joins, subqueries, CTEs, aggregations, window functions, and data transformation techniques.
- Work closely with business stakeholders to understand requirements, identify data needs, and translate business logic into clear technical/data specifications.
- Perform data validation and analysis to ensure data accuracy, completeness, consistency, and integrity across enterprise systems.
- Create and maintain detailed business requirements, functional specifications, data mapping, use cases, and acceptance criteria.
- Develop and execute test scenarios and test cases based on business requirements, with a strong focus on data and SQL validation.
- Utilize QTest for test case management, test execution, defect tracking, and testing documentation.
- Use Jira to manage requirements, user stories, tasks, defects, sprint activities, and Agile delivery processes.
- Collaborate with Business, Product, Development, QA, and Data teams to investigate issues, perform root-cause analysis, and deliver accurate data-driven solutions.
- Participate in UAT, functional testing, regression testing, data validation, and defect resolution, ensuring requirements are successfully delivered.
- Communicate SQL analysis, data findings, defects, and business impacts clearly to both technical and non-technical stakeholders.
Must-Have Skills
- Strong SQL Mandatory
- Business Requirements SQL Mandatory
- QTest
- Jira
- Data Analysis / Data Validation
- Business Requirements Gathering
- UAT / Functional Testing
- Agile/Scrum
Similar jobs
- SI
FP&A Systems Business Analyst
NewStratEdge It consulting INC
Sunnyvale, CA🇺🇸$47/hrOn-site22 hours agoFP&AGeneral LedgerBudgeting+1Finance - SI
Oracle Business Analyst
NewStratEdge It consulting INC
Sunnyvale, CA🇺🇸$50/hrOn-site22 hours agoProcurementOperations & Project Management - BS
Business Analyst, SAP – Credit
NewBayOne Solutions
Eagle Mountain, UT🇺🇸$75 - $79/hrOn-site22 hours agoSAPTechnology - WI
Business Analyst - Contract To Hire
NewWissen Infotech
Pittsburgh, PA🇺🇸On-site22 hours agoScrumAgileBusiness Analysis+4Operations & Project Management - SA
Sr Business Analyst ( Life Insurance )
NewSATCON Inc
Erie, PA🇺🇸On-site22 hours agoScrumAgileConfluence+2Operations & Project Management - ER
IT Business Analyst - Denver,CO - Must be Current resident of Colorado & Visa Independent Consultant - 12 Months C2C
NewERPA
Denver, CO🇺🇸On-site22 hours agoOperations & Project Management