Data Analyst

Job Description

Job Description

Data Analyst

Job Summary

The Data Analyst will be responsible for learning the business process and data related to transactions and key performance indicators, the development of

compiling appropriate data to perform analysis and effective reports, visuals and dashboards. Identify and analyze data to determine trends, make meaningful observations and draw conclusions. Solve complex problems, research requests and derive solutions. Lead meetings to gather requirements and present findings, and drive resolution. The Data Analyst will act as a resource for colleagues with less experiences. Interface with multiple teams and departments across the organization and third parties.

JOB DUTIES & RESPONSIBILITIES

Lead assigned data related initiatives : including requirements gathering meetings, analysis of requirements and present findings in a clear and concise manner. Write advance queries (pulling from multiple tables, calculations, using sub queries, different systems, etc.) using SQL, MS Access, MS Excel, R, Python or other tools.

Research issues across multiple platforms to determine the root cause and identify solutions to overcome the issue. Establish relationships and partner with others to deliver as needed.

Develop effective analytical reports, charts, presentations, dashboards and timelines. Reporting could be used across the company, third-parties, and with all levels of management.

Analyzing data to identify trends, business landscape, predictive analytics, and make meaningful and clear observations.

Develop complex Power Bi Visuals and dashboards for both ad hoc reporting and ongoing use by management and other departments. Apply modeling software to create predictive analytics in support of department objectives.

Analyze and identify discrepancies within data sets / data lakes and identify solutions.

Ensure data qualify, accuracy and timely processing.

Maintain review and / or analyze data files, tables, and reports for inconsistencies. Perform detailed analysis on results and effectively summarize findings.

Present data and provide recommendations to department leadership for their use in making operational decisions, identifying process improvements, and developing policy development to support change initiatives.

Design, develop, and maintain statistical reports as needed on a daily, weekly, monthly, and ad hoc basis for all levels of management. Formulate, develop and implement changes to improve process efficiencies, including using automation tools.

Assist in the design, structure, data needs to build out data lakes and other data tools.

Utilize existing and new data in ways to better meet Home Office, the field and clients needs more effectively. Assist in building POCs. This would include providing the logic and / or working with IT to build necessary APIs. Assist in the design, structure, data needs to build out data lakes and other data tools

Mentor and guide other teammates by answering questions, offering guidance and direction, and training less experienced analysts.

EDUCATION, EXPERIENCE & CERTIFICATIONS

Bachelor's degree in Business, Data Analysis, Data Science, or related field preferred

Required Knowledge, Skills and Abilities

Database Management Software (WinSQL, WebQMF, dbeaver, or equivalent)

MS Office (Word, Excel, Power Point, Access) Confluence / SQL and Database experience Power BI

Preferred

Education, Experience, Certifications or Licenses, Knowledge, Skills and Abilities

Data Modeling Software (R or Python) Experience with Denodo and Impact+ Experience in the Financial Services industry

Extensive knowledge of the systems and processes of the department and business functions they support