Entry Level Data Analyst

  • California St, San Francisco, CA, USA
  • Full-time

Company Description

KGS TECHNOLOGY GROUP, head quartered in Alpharetta, Georgia; is a e-verified multinational IT Consulting company that has successfully served the business community for over five years in onshore and over Ten years in Offshore, since its incorporation, KGS TECHNOLOGY GROUP has provided a wide variety of excellent customized IT solutions to its customers on time and on budget. KGS TECHNOLOGY GROUP has proven itself as an industry leading. We are in to software service, Customized Software development, Business consulting, Manpower staffing and outsourcing in various verticals like Banking, Business Services, Financial, Insurance, Manufacturing, Pharmaceuticals, Retail, Transportation, and Utilities including small-midsize ISV (Independent Software Vendors).

Job Description


Our growing technology firm is looking for a Data Analyst who is able to turn project requirements into custom-formatted data reports. The ideal candidate for this position is able to do complete life cycle data generation and outline critical information for each Project Manager. We also need someone who is able to analyze business procedures and recommend specific types of data that can be used to improve upon them.

Requirements:

  • Candidate having Analytical skills with core experience
  • Role involves developing queries from MySQL.
  • Knowledge of SQL, Excel or similar applications is mandatory.
  • Expertise in MySQL & related querying languages.
  • Expertise in Excel and advance excel skills
  • Should have experience in Reporting and business analytics.
  • Must have experience in MSBI (SSIS, SSRS, SSAS).
  • SQL server and Data Warehousing
  • Very strong experience in TSQL,
  • SQL Store procedures,
  • Data analysis
  • Extensive experience to perform Data Analysis Activities
  • Designs Data Architectures

Daily Tasks Performed:

  • Write efficient T-SQL. 
  • ETL using Bulk Insert, SSIS. 
  • Performance Tuning and Optimization using native monitoring and troubleshooting tools. 
  • Perform other duties as assigned.

Qualifications

Candidates having Bachelors or Master degree in any related subject. 

Looking for knowledge in SQL, MSBI, PowerBI, R, Tableau, Excel, Python, SAS etc.

Additional Information

Looking for Green Card, OPT, Full-time CPT and Citizens.

If candidate is fresher and do not have the right kind of skill set, KGS Technology Group can help with skill enhancement.

We provide project based skill enhancement support .

Highlights of the program-

Online skill enhancement through live sessions, Demo project to practice the skills, Interview preparations etc.