Data Warehouse Analyst

Artech Information System LLC; Town of Florida (NY); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading IT staffing firm in New York is seeking a Data Warehouse Analyst III for a 12+ month project. The candidate will interpret complex data, analyze results, and create reports using MS SQL and SSRS. The ideal applicant should possess a BS in a relevant field and proven experience in data analysis, with strong skills in communication, statistical techniques, and data modeling. This role offers an opportunity to work closely with business partners and contribute to valuable data projects.

Qualifications

• Proven working experience as a data analyst or business data analyst.
• Technical expertise regarding data models and database design development.
• Strong knowledge of reporting packages and databases.

Responsibilities

• Interpret data, analyze results using statistical techniques.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Work with internal business partners to refine reporting requests.

Skills

Data analysis

Statistical techniques

Data ingestion

Microsoft SQL Server Reporting Services (SSRS)

ETL programming (SSIS)

Attention to detail

Oral and written communication

Education

BS in Mathematics, Economics, Computer Science, Information Management or Statistics

Tools

Excel

Tableau

Job description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Job Description

Job Title : Data Warehouse Analyst III

Duration: 12+ Months

PRIMARY RESPONSIBILITIES:

• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Identify, analyze, and interpret trends or patterns in complex data sets
• Analyze potential data sources and develop data ingestion and integration plans.
• Locate and define new process improvement opportunities
• Work with internal business partners to refine incoming reporting and analysis requests and convert to specific actionable requirements.
• Convert business requirements into reports by creating MSSQL Stored procedures and reports using Microsoft SQL Server Reporting Services.

REQUIREMENTS:

• Proven working experience as a data analyst or business data analyst
• Technical expertise regarding data models, database design development, data mining and segmentation techniques
• Strong knowledge of and experience with reporting packages (SSRS etc), databases (SQL etc), ETL programming (SSIS).
• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SRSS, SSAS, Tableau, etc)
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Adept at queries, report writing and presenting findings
• BS in Mathematics, Economics, Computer Science, Information Management or Statistics
• Strong oral and written communication skills.