Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Data Analyst with BA, SQL (133 views)

Atlanta,GA
November 9, 2020

***** Direct Client Requirement*****                     

Title                        : Data Analyst with BA, SQL

Location                 Atlanta, GA

Rate                       : DOE /If your experience and skills match call us immediately for submission

Duration                : 6 Months

Interview Type     : Skype only

Work Status         : ‘U.S. Citizens, Green Card Holders, and those authorized to work in the U.S. for any employer will be considered’. 

Job Type               :  C2C,C2H,W2

Experience          : 5+ YEARS

Prefer W2           : U S C/ G C /H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted

Description 

Requirements:

***Only US Citizens will be considered for this position. Local candidates strongly preferred***

 

The Data Analyst will be responsible for discovering analytics and system integrations requirements,

identifying data sources and criteria needed, documenting specs for developers, testing the output, and

ensuring user acceptance. This position will work directly with Georgia Tech Research Institute’s (GTRI) internal customers, business process owners, leadership, Business Analysts, and BI, ETL, and Webservices Developers.

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 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 (esp. PeopleSoft HCM data) is strongly preferred. Selected candidates will be expected to walk through their data gathering, analysis, and SQL experience in detail.

Job Responsibilities:

  • Analyze large volumes of complex data that requires consideration of multiple factors to interpret the

  information

  • Work closely with stakeholders to understand the business process and turn vague one-liner requests into

  detailed, testable requirements that meet the business needs

  • Propose and implement analytics solutions to support business needs and data-driven decisions
  • Support new system implementation projects, including data feeds, data design, and mapping
  • Identify and document data sources, criteria, and data mapping
  • Develop subject matter expertise and understand dependencies between source systems
  • Use SQL to explore, extract, and analyze data, including historical data
  • Assess data quality and completeness and implement solutions to ensure accurate reporting
  • Propose solutions to collect new data points to support metrics and identify trends
  • Design reports/dashboard layouts to present data in a clean, consumable, and insightful format
  • Write report and data feed specifications for BI, ETL, and Webservices Developers
  • Receive and prioritize requests for reports
  • Assist customers with ad-hoc reporting needs
  • Audit existing reports and propose improvements for findability of data
  • Serve as a resource to Business Analysts and Developers for data-related needs
  • Support development of other team members’ data analysis skills though knowledge share

Education and Experience (required)

  • Bachelor’s degree in Computer Science, Statistics, Business, Finance, or related field
  • 3-4 years performing data analysis
  • 3-4 years as a business analyst (working with stakeholders on requirements and business process)
  • 2-3 years of experience writing complex SQL queries

Qualifications (required)

  • Above average analytical and conceptual thinking; resourceful problem-solving
  • Fascination with data, desire to learn new concepts, finds business process and data analysis rewarding
  • Expert level SQL skills; experience writing complex queries with multiple table joins, subqueries, and

  historical data

  • Basic knowledge of database design principles, deep understanding of relational databases
  • Familiarity with data warehouse, data mart, ETL, and webservices concepts
  • Exposure to reporting tools and some hands-on experience building reports
  • Advanced Excel skills (formulas, charts, pivot tables)
  • Strong interpersonal skills
  • Experience communicating with all levels in the organization in a clear and concise manner using non-

  technical language

  • Excellent documentation skills
  • Attention to detail and accuracy
  • Strong experience working with HR data and processes
  • Process analysis skills
  • Ability to lead others to articulate requirements and uncover hidden needs
  • Familiarity with SDLC
  • Experience managing multiple requests and projects
  • Adaptability to changing requests and priorities

Additional Qualifications (preferred)

  • Experience with PeopleSoft HCM data
  • Eye for aesthetics and usability in report design
  • Data visualization experience, such as dashboards
  • Familiarity with statistical methods
  • Predictive analytics/forecasting experience
  • 1-2 years of BI experience working with Cognos, Tableau, or similar BI suites
  • Strong presentation skills

Required / Desired Skills                            

3-4 years performing data analysis   

Required         3          Years

3-4 years as a business analyst (working with stakeholders on requirements and business process)        

Required         3          Years

2-3 years of experience writing complex SQL queries; • Expert level SQL skills; experience writing complex queries with multiple table joins       

Required         3          Years

Strong analytical and conceptual thinking; resourceful problem-solver     

Required                     Years

Basic knowledge of database design principles, deep understanding of relational databases

Required         2          Years

Familiarity with data warehouse, data mart, ETL, and webservices concepts        

Required         2          Years

Exposure to reporting tools and some hands-on experience building reports        

Required         2          Years

BI experience working with Cognos, Tableau, or similar BI suites  

Required         2          Years

Bachelor’s degree in Computer Science, Statistics, Business, Finance, or related field        

Required         4          Years

******Referral Bonus Available: Refer your friends or colleagues, get referral bonus****** 

Position Keywords: SQL,BI, ETL, and Webservices,

Pay Rate: DOE/If your experience and skills match call us immediately for submission

Job Duration: 6 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 2494

Work Authorization: ‘U.S. Citizens, Green Card Holders, and those authorized to work in the U.S. for any employer will be considered’. 

Don't have time now?
Get a reminder in your inbox