Stakeholders Sql Skills Complex SQL Team Management HR Data Report Design Excel Ana   Requirement id 117172 Job title Analyst Job location in Atlanta, GA Skills required Conceptual Database Design, Problem Solving Skills, Stakeholders, Sql Skills Complex SQL Team Management H Open Date 04-Jun-2021 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Analyst: Conceptual Database Design, Problem Solving Skills, Stakeholders, Sql Skills Complex SQL Team Management H Start Date :06/28/2021 End Date :12/31/2021 Submission Deadline :06/09/2021 Client Info : GTRI-Enterprise Systems Department Note : * Agency Interview Type:Either Web Cam or In Person Description : Title: Business Analyst (Data Projects) ***Only US Citizens will be considered for this position*** Responsibilities: This position will focus heavily on reporting, data integrations, and other data-related projects. The Business Analyst will gather requirements both from stakeholders and from own analysis of existing reports to meet new needs and introduce improvements. They will identify data sources and criteria needed, document specs for developers, test the output, and ensure user acceptance. Extensive use of SQL is expected throughout this process. The Business Analyst will prioritize tasks and coordinate the work of the development team. • Collect and prioritize requests for reports, integrations, and other data needs • Work closely with stakeholders to understand the business process and turn vague one-liner requests into detailed, testable requirements that meet business needs • Identify and document data sources, criteria, and data mapping • Use SQL to explore, extract, and analyze data to support and test requirements • Write report and data feed specifications for BI and ETL Developers • Organize tasks for the development team and coordinate development, testing, and deploy • Communicate prioritization and progress on requests to stakeholders • Test reports and data feeds hands-on, as well as lead stakeholders through UAT • Design reports/dashboard layouts to present data in a clean, consumable, and insightful format • Audit existing reports and propose improvements for findability of data • Assist customers with ad-hoc reporting needs The ideal candidate has proven working experience taking a vaguely stated business question and unpacking it into specific requirements, data sources, and criteria. The skillset is a cross between a business analyst working with the customer on requirements discovery and a "data detective" identifying and interpreting data using strong SQL and analysis skills. Analytical /conceptual/ curious/ problem-solving mindset is an absolute must. Experience writing SQL against complex tables containing historical/future data is a must. Working knowledge of HR data and processes is strongly preferred. Interview Expectations: During the interview, the candidate will be expected to walk GTRI through his/her data gathering, analysis, and SQL experience in detail. The interviews will be very thorough and the candidate will be expected articulate answers for scenario based questions. .1st Interview: Phone, Second Interview: Virtual, Final Step: Extend Offer Education and Experience (required) • Bachelors degree in Business, Computer Science, or related field • 6-8 years of business analysis experience, including: • 4-5 years of experience performing data analysis • 3-4 years of experience writing complex SQL queries Qualifications (required) • Above average analytical and conceptual thinking; resourceful problem-solving • Quick grasp of new information and ability to lead stakeholders to articulate core hidden needs • Strong SQL skills; experience writing complex queries with multiple table joins, subqueries, and effective- dated data • Experience communicating with all levels of the organization in a clear and concise manner using non- technical language • Great organizational skills for own work and prioritization and coordination of team activities • Excellent documentation skills; attention to detail • Strong experience working with HR data and processes; process analysis s   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 117172 while calling.   Other jobs in GA: Alpharetta (12), Atlanta (37), Conyers (2), Downtown Atlanta (1), Dublin (1), Duluth (5), Dunwoody (4), Lawrenceville (2), Norcross (4),    Conceptual Database Design job openings in other states Jobs List NCDOT - SharePoint Product Specialist (664530) Create date: 06-Oct-2021 Start Date :9/30/2021 End Date :09/29/2022 Submission Deadline :10/11/2021 Client Info : NCDOT Noe : * Agency Interview Type: Webcam Interview Only Description : **The candidate must reside in the United States. **The candidate must be willing to.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, NC)) NCDOT - SharePoint Technical Specialist (643435) Create date: 11-Jan-2021 Start Date :01/11/2021 End Date :01/10/2022 Submission Deadline :01/15/2021 Client Info : NCDOT Note : * Agency Interview Type : Webcam Interview Only Description : ***The candidate will be allowed to work remotely until all staff return to site. At.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, NC)) 268184 - ME- IHOC Product Specialist 3 Create date: 26-Sep-2011 [Note : Start Date : 09/01/2011 End Date : 06/30/2013] Short Description: The IHOC product specialist position is responsible for set of tasks & techniques used to liaise among Health System stakeholders for data exchange of clinical data from EHR software back to a state repository Complete Descrip.... (This job is for - job Jobs in ME Augusta Specialist - (in Augusta, ME))     (Analyst: Conceptual Database Design, Problem Solving Skills, Stakeholders, Sql Skills Complex SQL Team Management H in Atlanta, GA)

Featured Jobs GitHub DB2 Developer (Jobs in Madison, Wisconsin) Microsoft Active Directory Hardware Consultant (Jobs in Madison, Wisconsi Frameworks Agile Analyst (Jobs in Lansing, Michigan) SQL T Analyst (Jobs in Richmond, Virginia) IIS Engineer (Jobs in Madison, Wisconsin) Cobol Oracle Consultant (Jobs in Blythewood, South Carolina) Help Consultant (Jobs in Columbia, South Carolina) Business Analyst Project Manager (Jobs in Madison, Wisconsin) MuleSoft ESB Consultant (Jobs in Colombus, Ohio) Architect (Jobs in Atlanta, Georgia)