Previous Job
Data Analyst
Ref No.: 17-03439
Location: Chicago, Illinois
Position Type:Full Time
Pay Rate : $ 70,000.00 - 85,000.00 /Year
what you'll do
  • Extract, Transform, and Load (ETL) data from various sources
  • Design and manage data migration projects
  • Design database structure (relational and warehouse)
  • Design and implement reports supporting business decision-making process on various levels of the organization
  • Analyze data
  • Resolve and explain data discrepancies and issues
  • Maintain integrity of existing data
  • Document work, including updating and maintaining knowledgebase (Confluence, Intranet, etc.)
  • Meet quality, productivity, turnaround time and other expectations
  • Help ensure continuous improvement of processes and procedures
  • All other duties as assigned

what you'll bring to succeed
  • BS or BA degree in CS, Telecommunication or related field or equivalent subject or equivalent experience
  • 2+ years working in a similar position
  • Strong verbal and written communication skills 
  • Strong attention to detail and ability to troubleshoot complex problems independently required
  • Experience in the analysis of large data sets to find useful relationships
  • Knowledge of statistical software packages (e.g., R, SPSS, SAS) a plus
  • Some knowledge of databases and SQL
  • Strong application skills including Tableau, Access, Excel, Word, and PowerPoint required
  • Some knowledge and experience using social listening tools (Sysomos, Radian6, Crimson Hexagon, etc.) required
  • Experience using ad servers (DoubleClick, Sizmek, AdWords, Innovid, Vindico, etc) a plus
  • Experience using web analytics tools (Google Analytics, Omniture, WebTrends, etc) a plus
  • Knowledge of Relational Databases, Transaction Processing, Data Warehouse Designs, and Data Modeling
  • Strong background in T-SQL programming
  • Experience with Microsoft SQL Server Reporting Services
  • Knowledge of ETL and SQL Server Integration Services (SSIS)
  • Experience building data warehouses and data cubes using SQL Server Analysis Services (SSAS)
  • Present information in a clear, logical and effective manner
  • Effectively communicate issues with reporting and develop alternate reporting ideas
  • Remain honest and open about timeframes and deliverables
  • Demonstrate good judgement, problem-solving and decision-making skills
  • Exhibit good team and cross-functional relationships
  • Conduct self professionally and ethically
  • Experience developing reporting solutions using Microsoft Power BI
  • Experience in migrating and analyzing Microsoft CRM data
Third Party Applications Not Accepted