Position: Data Analyst

Location: Chicago IL 60611

6 month contract to hire





Smartsource is seeking a data analyst who has extensive experience working with SQL to aid our effort in the areas of business intelligence and data quality for our globally distributed applications environment. This person must be an extremely detail oriented self-starter and have the skills necessary to drive our data quality tasks. The ideal candidate is a results-oriented individual who likes and understands how to work with data in transactional and data warehouse environments.



Requirements

Mandatory Working Experience

· Three years of Microsoft SQL Server or equivalent

· Experience working with business users



Mandatory Qualifications

· Advanced fluency in SQL

· Thorough understanding of database concepts

· Knowledge of data warehouse concepts

· Complete understanding of relational data models

· Strong data / problem analysis skills

· Ability to multi-task

· Demonstrated ability to communicate effectively with both technical and business audiences

· Ability to multi-task and function well independently

· Strong analytical skills and attention to detail

· Strong communication and organizational skills

· Strong problem solving and research skills

· Willingness to work mainly on back-end technologies (SQL Server, Analysis Services)

· Willingness to be accountable for our set of business information

· Strong enthusiasm for working with computers and the performance of high quality work



Desirable Qualifications

· A working knowledge of data architecture design principles and standards, including meta data management

· Knowledge of basic accounting principles

· Experience with any modern software development tool

· Experience with Microsoft Analysis Services and MDX

· Familiarity with dimensional data models and analysis tools (e.g., Excel pivot tables)

· Data Mining Experience

· Experience with PVCS Tracker or other System Change Management tracking software



Responsibilities

· Ensure that data contained in firm-wide enterprise applications is accurate and used consistently

· Perform SQL-based analysis on existing data, identifying root causes for data inaccuracies, through the use of database query tools

· Perform data analysis on non-SQL-based third party data sources such as Microsoft Business Solutions Navision and Geac MPC using Excel or other tools

· Assign criticality of discovered inaccuracies

· Implement auditing/control and notification processes to proactively identify and resolve data quality issues

· Respond to potential data errors and drive them to a resolution

· Perform assignments without the need to have a lot of guidance

· Recognize when assistance is needed and seek it out

· Develop recommendations on how the business can constantly improve its data quality

· Collaborate with the application development team, the QA team, and the data quality group during testing and rollout cycles

· Review regular data warehouse loads for accuracy

· Thoroughly understand all data models of our application environment

· Understand our network and database server infrastructure

· Perform ad-hoc queries upon request

· Commit to quality and completeness



To apply please email your resume in word and include your hourly / salary requirement and references



To Apply to this job go to http://www.GadBall.com or click here