Overview

Data Analytics and Programming Associate Analyst (Analyst, Business Intelligence) savvy professional to join our Audit & Business Consultation team in Melville, NY. We’re looking to study our internal data sources to drive insight & value through analytics/visualization & improve efficiencies through process automation. In this role, you will be expected to understand business objectives and deliver clear and meaningful insights, thoughts, & action plans to management.

The Analyst will be responsible for creating pipelines for importing, transforming, validating or modelling data with the purpose of understanding the data, drawing conclusions, and/or detecting unusual activity. The Data Analyst will then work with other department members and business partners to develop and implement business solutions, continuous auditing/monitoring, or investigate unusual activity.

Adaptability and creative thinking are critical as you will work on a variety of business challenges. You should feel comfortable presenting your findings to both smaller and larger audiences. Experience of working in a team environment and demonstrated teamwork capabilities are required. The ideal candidate is creative, motivated, and a strong communicator.

RESPONSIBILITIES:

Identifies and acquires necessary data from multiple sources and extracts, cleans, transforms, and loads data sources to enhance data quality as part of analytics analysis to analyze complex business problems and issues using data from internal and external sources to provide insight to decision-makers

Clean data as part of analysis and then identifyand interpret trends and patterns in datasets to locate influences

Create scripts to enhance automation (RPA) within ETL processes, routine testing, or other business processes – through SQL or Python or leveraging Tableau/Tableau Prep, or other tools to creatively and efficiently tackle process challenges

Design visualization with Tableau to make interactive dashboards and toolkits for internal risk monitoring and business unit insights

Provide consultation to users and lead cross-functional teams to address business issues

Researches, plans and tests the effectiveness of controls in support of the external auditors – good opportunity to learn all aspects of the business

Support the effective usage of Analytics for existing day-to-day business analytic tools and the development of other tools/analytics for new business areas and opportunities

Ongoing collaboration with various business units to support advanced analytics for audit strategies

Identify new advanced analytic requests and new data sources for further evaluation

Partner with business partners to compile requirements for audit analytic solution expansion

Document and communicate status of projects and initiatives to senior team members

Acts as liaison with IT business partners to ensure full understanding of data flow, data integrity and system security. Assesses information technology control elements to mitigate IT risks regarding the confidentiality, integrity and availability of business information

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

QUALIFICATIONS:

Bachelor’s degree in a relevant field or equivalent experience required, and 3+ years of related experience

Master’s Degree preferred or a + (BS in Mathematics, Economics, Computer Science, Information Management, Statistics or other STEM field)

Familiarity with object oriented programming principles

Proficiency with at least one modern programming language (SQL & Python preferred)

Familiarity with some of the following python libraries/frameworks:

Pandas

NumPy

Selenium

SciPy

Scikit-learn

Matplotlib

Knowledge of Tableau, SQL and Oracle is preferred

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy and ability to drive to completion

Ability to work independently, pursuing new business development and opportunities, reviewing and collaborating with senior leadership

Excellent verbal and written communication skills and the ability to interact and engage with a diverse group (executives, managers, and subject matter experts)

Organizational skills

Positive attitude

Ability to work with others & build relationships

Familiarity with predictive analytics techniques is a plus

The company will not pursue or support visa sponsorship for this position.