Reporting Analyst / Data Analyst Job Description
Reporting Analyst / Data Analyst Duties & Responsibilities
To write an effective reporting analyst / data analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included reporting analyst / data analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Reporting Analyst / Data Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Reporting Analyst / Data Analyst
List any licenses or certifications required by the position: ITIL, V3, CRCM, PMP, NCCO, GARP, CFA, SSIS, SQL, AFHI
Education for Reporting Analyst / Data Analyst
Typically a job would require a certain level of education.
Employers hiring for the reporting analyst / data analyst job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Business, Statistics, Computer Science, Finance, Information Technology, Mathematics, Accounting, Education, Economics, Public Administration
Skills for Reporting Analyst / Data Analyst
Desired skills for reporting analyst / data analyst include:
Desired experience for reporting analyst / data analyst includes:
Reporting Analyst / Data Analyst Examples
Reporting Analyst / Data Analyst Job Description
- Function as an expert in understanding UW and UWC² data sources
- Maintain accurate input to acquisition reporting such as source codes and bonus codes
- Document and perform analysis on breaks or issues identified
- Ensure that Treasury meets our regulatory reporting requirements and deliverables
- Produce and validate Treasury MI/Regulatory Reports
- Assist the team in the creation and implementation of the team’s strategies
- Ensure high data quality and accuracy
- Improve reporting processes to eliminate waste and create more value for the clients/business users
- Manage and maintain data quality dashboards to demonstrate impact of issues
- Coordinate with the Liquidity Management team and IT
- At least 3 years of experience with BI applications (e.g., SQL, Visual Basic, Oracle)
- 5 years of BI/Analytics experience
- 5 years of experience with an application software Report Writer
- Strong business and industry acumen (retail preferred)
- Working knowledge with internet and web based data collection and reporting
- Data mining experience, information extraction or statistical modeling
Reporting Analyst / Data Analyst Job Description
- Ensure consistency and accuracy of information and reporting by identifying issues and fluctuations with core metrics/key performance indicators (KPIs), facilitate changes
- Contribute to ensuring that all changes to reporting, processes, and procedures are reflected, appropriately documented and that consistency is maintained for team
- Maintain effective communication with internal organizations, external vendors/partners, and internal staff
- Produce trimester summary reports encompassing weekly student life-cycle information, student demographics, and financial aid data
- Prepares presentations and recommendations based upon analysis of data for management (the leadership team)
- Creates accessible electronic database for effectively storing historical student-related data
- Design, implement, and administer analytic tools that pull data from the right sources to automate the creation of financial reports, dashboards, and visualizations
- Leverage analytic tools and the knowledge of financial analysts to automate profit & loss, budget vs actual, financial metrics, and key performance indicators
- Create and maintain procedural and best-practice documentation
- Train colleagues on the use of analytic tools to run reports in support of financial analysis
- Experience in constructing complex SQL queries
- Must have knowledge of SQL Server and Oracle databases
- Knowledge and experience with other reporting packages, relational databases, data warehousing, ETL is a plus
- At least bachelor degree from finance, economics or equivalent
- Good English knowledge (written and oral)
- Able to plan, execute and monitor workload
Reporting Analyst / Data Analyst Job Description
- Provide monthly reporting of US SCM On-Time Delivery Metrics
- Provide monitoring of progress payment line item receiving and open material updates
- Drive the updating, maintenance and issuance of weekly Material Status Updates
- Drive the updating, maintenance and issuance of all weekly Project Material Status Reports according to scheduled release times
- Develop reports to fulfill ad hoc requests by management as needed As needed, provide expediting support to supplement existing expeditor manpower
- Works with assigned divisions and ensures that necessary BOH data is gathered for financial management reporting purposes
- Analyzes and updates respective databases methodologies on a regular basis
- Analyze financial forecasts, budgets, financial statements, and resourcing data
- Evaluate and apply metrics to financial statements and budgets to assist in analysis and reporting of portfolios
- Calculate and analyze trends of margins, cash flows, and orders
- You are an expert in SQL and VBA
- Proficiency in extracting and manipulating data using relational databases such as Oracle, Teradata, SQL Server, or other RDBMS
- Advanced proficiency in Excel and intermediate with Power Point and Word
- Bachelor’s Degree in Finance, Economics, Accounting, Math or related field
- Experience working with large, multi-faceted data sets and ability to normalize and match data from various sources
- Ability to translate business problems to data extraction in order to obtain output, leading to recommendations
Reporting Analyst / Data Analyst Job Description
- Develop and maintain tracking tools (dashboards, reports) to ensure measurement of metrics on a regular basis (daily, weekly, and monthly)
- Work closely with Sales, Operations, Marketing and Finance to successfully facilitate change in alignment with strategy and direction
- Develop and implement Special Loans automation reporting, including database maintenance along with providing various ad-hoc reporting as needed
- Design and develop metrics, reports and analyses to drive key business decisions
- Work collaboratively with business units, department management, and team members in defining, designing, planning, and implementing reporting and business solutions to improve overall business function
- Proactively identify special initiatives and opportunities to maintain the portfolio
- Identify needs for the development and implementation of additional reporting solutions and complete required reporting and reconciliations functions as assigned
- Support reporting applications developed for Special Loans – answer questions, research anomalies
- Apply knowledge of key regulations and identify risk
- Assist management with exceptions and escalations as required
- Development experience using SQL Server Analysis Services
- University/Bachelor’s degree in Business Administration, Engineering, Supply Chain Management or equivalent
- Bachelors or Master’s degree in a financial discipline from a reputed university
- 2 to 4 years of relevant experience in financial industry
- Experience in maintaining data and management reporting
- Strong quantitative skills, knowledge of financial markets is a plus
Reporting Analyst / Data Analyst Job Description
- Define report and data file specifications
- Identify, research, validate and test applicable data stores for validity and usefulness for report and file creation
- Research, select and deliver appropriate method for report information to be consumed by end users
- Analyze, evaluate, integrate and re-write existing reports and specifications
- Effectively present (orally and in writing) research and report findings to various audiences
- Assists in defining goals and objectives for Reporting and Analytics Unit
- Communicates with outside vendors for materials, data, seminars
- Delivers routine daily/weekly/monthly HR reporting and responds to basic to intermediate ad hoc data requests
- Responsible for building executive-level dashboards that include a variety of HR metrics including attrition, span of control, diversity and other HR information by business unit
- Responsible for ensuring the accuracy of the information that is being provided by carefully and continually scrutinizing the data to ensure the right information is portrayed in the reports being delivered
- Experience with large database implementations (Oracle, SQL server, IBM)
- Must have strong interpersonal skills and the ability to establish, develop and maintain cross-functional business relationships, have excellent presentation and problem-solving skills
- Strong written and verbal communication skills Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Bachelor’s degree in Computer Science, Information Science, Data Science or related field or equivalent experience and two years of applicable work experience
- Understanding and experience implementing and using data analytics tools
- Ability to collaborate across various business units/levels to troubleshoot and identify opportunities for improvement