Data Analyst II

Perform complex analytical and statistical modeling on large data sets to support various business operations and organizational objectives. Define data requirements, perform data collection, processing, cleaning, analysis, modeling and visualization. Identify data patterns and trends to answer business questions and improve decision making. Identify opportunities to increase efficiency and automation of data analysis processes and procedures. Participate on complex, essential projects working under minimal supervision and with latitude for independent judgment. Accountable for completion of assigned projects and deliverables. Highly skilled and proficient in discipline with demonstrated achievement of results.

• Develop, maintain, and manage advanced reporting, dashboards, data models and analytical results
• Evaluate and define functional requirements for analytics and business intelligence (BI) solutions
• Retrieve, analyze and validate data and test accuracy of reported results
• Work directly with project leads to understand requirements and propose key analytics solutions to drive effective decision-making and influence business objectives
• Produce actionable reports that demonstrate key performance indicators, identify areas of improvement for current operations, and show root cause analysis of problems
• Analyze and summarize business operations, customer and/or economic data in order to improve business intelligence, optimize operating effectiveness and predict business outcomes
• Identify trends and patterns in business data; create data visualizations to support business decision making
• Build new and/or modify existing database/data warehouse/data mart and business intelligence solutions to meet business and system requirements
• Collaborate with business units and senior management to conduct needs assessment to support business unit objectives
• Support complex Data Science and Big Data projects
• Effectively communicate data outcomes to business stakeholders and leadership
• Mentor and guide less experienced staff Metadata Analyst Specific Responsibilities
• Work with business units to collect, review, and publish Metadata
• Maintain and enhance Data Catalog (e.g., Purview) and PowerBI Reports
• Evaluate and enhance the Data Governance & Metadata Collection Framework
• Perform other duties as assigned

• Significant experience in the application of statistical methods, mathematical techniques, forecasting, cost-benefit analysis, related analytical tools and programming languages
• Significant experience in problem resolution including determining root cause, scope and scale of issues
• Significant experience that demonstrates the ability to research, compile, and document data, business processes, and workflow
• Working knowledge of standard ETL tools and techniques
• Working knowledge of the process in sourcing raw data and cleansing techniques
• Working knowledge of data warehousing, data cleaning, and other analytical techniques required for data usage
• Advanced knowledge of and the ability to perform basic statistical analysis such as measures of central tendency, normal distribution, variance, standard deviation, basic tests, correlation, and regression techniques
• Working knowledge of data models, design tools, business/technical requirements, statistical programming languages, data queries
• Demonstrates a key understanding of multiple database concepts and data flows
• Working knowledge of various data structures and ability to extract data sources (e.g., PySpark, PowerBI)
• Working knowledge of mapping techniques and data pipelines
• Advanced skill interpreting, extrapolating and interpolating data for statistical research and modeling
• Advanced skill analyzing statistics and reports to determine business performance and trends
• Advanced skill identifying and analyzing business requirements and recommending solutions
• Effective skill presenting findings, conclusions, alternatives and information clearly and concisely
• Advanced skill in understanding and communicating data presented in models, charts, and tables and transforming it into a format that is useful to the business and aids effective decision making
• Advanced skill in the use of measurement and statistical practices to analyze current and historical data to make predictions, identify risks, and opportunities enabling better decisions on planned/future events
• Advanced skill in understanding and analyzing models that predict the probability of an outcome
• Advanced skill in collecting and manipulating data used in effective decision making
• Advanced SQL skills
• Advanced Microsoft Excel skills
• Bachelor's degree in Information Syst