Estimated Length: 24 months M-F 37.5 hrs per week, TBD

Requirements

The candidate must have a minimum of:

1. 5 years of experience in data analytics.
2. 5 years of experience in developing Tableau and Power BI dashboards.
3. Proof of eligibility to work in NYS.

Job Description and Required Services:

Duties include, but are not limited to, the following:

• Analyze and understand business requirements to design effective data models
• Connect BI tools to various data sources, including databases, Excel files, and web services

• Use business intelligence software (Tableau and Microsoft Power BI) to create dashboards and visualize data
• Develop dashboards and key Performance Indicators (KPI) with Power BI and Tableau.
• Design ETL packages dealing with different data transfers between different systems.

• Write, optimize queries and stored procedures
• Create multiple types of reports and packages from SSRS and SSIS
• Designs and prepares periodic reports as per requirements details in official Client policies

• Use technical expertise to automate manual processes and reporting
• Compile and compute data according to statistical formulas for use in data analysis and/or statistical studies
• Work as Data analyst, by interacting with the researchers and gathering requirement for data discovery  
• Work with complex data sets to understand problems and recommend procedures while using various analytical and statistical approaches

• Prepare business analytics and assist in preparing metrics and reporting
• Respond to ad hoc requests for data, aggregations, and visualizations
• Conduct research and analysis of data at Client, definitions and usage, system flows, challenges, and opportunities
• Collaborate with business users and business analysts to develop analytical strategies for development of various projects

• Develop documentation including data dictionaries, policies, and procedures
• Other duties as assigned

In addition, the candidate must possess the following abilities:

• Develop metrics and reports
• Data analysis
• Data visualization
• High-level competency in Excel (advanced formulas, macros, etc.)
• Expertise in relational database management systems, SQL, data modeling
• Ability to translate complex business requirements to technical specifications for IT
• Highly motivated and effective working autonomously and as part of cross-functional teams
• Ability to multi-task across projects, and be detail-oriented, and accurate

Notes:

*Telecommuting may be allowed at the discretion of the hiring manager

*The Department does not provide parking, but the office is accessible by mass transit.

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer