Vacancy expired!
Under general supervision, analyzes customer business needs and participates in the planning, design and implementation of new or enhanced systems.
Title: Business Analyst (Data Projects)
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/ curio 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)
Bachelor's 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 skills
Additional Qualifications (preferred)
Experience with PeopleSoft HCM data
Eye for aesthetics and usability in report design
Strong Excel skills (formulas, charts, pivot tables)
Strong presentation skills
This role is expected to extend into 2022.
Required/Desired Skills Skill Required /Desired Amount of Experience Above average analytical and conceptual thinking; resourceful problem-solving Required 4 Years Quick grasp of new information and ability to lead stakeholders to articulate core hidden needs Required 4 Years Strong SQL skills; experience writing complex queries with multiple table joins, subqueries, and effective-dated data Required 4 Years Experience communicating with all levels of the organization in a clear and concise manner using non-technical language Required 4 Years Great organizational skills for own work and prioritization and coordination of team activities Required 4 Years Excellent documentation skills; attention to detail Required 4 Years Strong experience working with HR data and processes Required 4 Years PeopleSoft HCM data Highly desired 4 Years Eye for aesthetics and usability in report design Required 4 Years Strong Excel skills (formulas, charts, pivot tables) Required 4 Years Questions No. Question Question1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? Question2 Please list candidate's email address. Question3 Candidate must be paid AT LEAST NA if selected for engagement. Candidate can be paid more; however, the SRP rate cannot exceed NA. Do you accept this requirement? Question4 The maximum mark-up for this engagement's SRP rate is 35%. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%? Question5 This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement? Question6 The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client's selection date. Do you accept this requirement?
