Statistical Assistant

M-F 37.5 hours a week
*Telecommuting may be allowed at the discretion of the hiring manager
No Parking Provided
No Travel required
May work overtime or on a holiday.

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.

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 DFS 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 DFS, 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

New Wave People is an Equal Opportunity Employer (EEO).

#OTIND123