Data Analyst - SQL

Georgia  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

Seeking a Data Analyst for the discovery, analytics and system integrations requirements. You will identifying data sources and criteria needed, documenting specs for developers, testing the output, and ensuring user acceptance. Cient can only use.

Skills needed: Advanced SQL, report building and data marts. Knowledge of Datae Warehouse and ETL only.

This position will work directly with internal customers, business process owners, leadership, Business Analysts, and BI, ETL, and Webservices Developers.

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

Work with stakeholders and Business Analysts to understand business processes (preferably HR) and detailed requirements for reports and data feeds

Identify and document data sources, criteria, and data mapping

Use SQL to identify, extract, and analyze data

Assess data quality 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

Required/Desired Skills

3-4 years performing data analysis

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

Required

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

Strong analytical and conceptual thinking; resourceful problem-solver Required

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

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

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

Advanced Excel skills (formulas, charts, pivot tables) Required

Benefits

  • Low stress work environment
  • Promote from within
  • Flexible start times
  • Health, Dental, Vision, 401K

ABOUT ESG CONSULTING:

ESG Consulting is an award-winning national provider of diversified information technology consulting services to Fortune 1000, public sector entities, and emerging growth firms nationwide.

Founded in 1986, ESG offers more than 32 years of experience in the IT staffing, Engineering and consulting industry. While local to Atlanta we are headquartered in Santa Clara.

ESG is an equal opportunity company. Our flexible management culture believes in creating a business environment that fosters personal and professional growth and achievement. We make ESG a place where people are treated not as employees but as "partners".

Start date
ASAP
Duration
7mths + renewals
(extension possible)
From
ESG Consulting
Published at
22.11.2020
Project ID:
2003159
Contract type
Freelance
To apply to this project you must log in.
Register