JOB OVERVIEW

Responsibilities:

• Data Collection and Integration: Gather and consolidate data from various sources, including databases, spreadsheets, and external systems. Develop and maintain data pipelines to ensure data accuracy and consistency.
• Data Analysis: Perform data analysis to identify trends, anomalies, and insights that can help the organization make informed decisions. Use tools like SQL, Excel, or data visualization software to create reports and dashboards.
• Reporting and Dashboard Development: Create and maintain reports and dashboards that provide key performance indicators (KPIs) and insights to different stakeholders. Utilize reporting tools like Tableau, Power BI, or custom-built solutions.
• Data Quality Assurance: Implement data quality checks and validation processes to ensure data integrity. Troubleshoot and resolve data-related issues.
• Data Transformation and ETL (Extract, Transform, Load): Design and implement data transformation processes to convert raw data into usable formats. Automate data extraction, transformation, and loading tasks as necessary.
• Data Governance and Compliance: Ensure data privacy and security compliance, especially in organizations subject to data protection regulations. Define and enforce data governance policies.
• Collaboration: Collaborate with various departments to understand their data and reporting needs. Provide guidance and support for non-technical stakeholders in using data and reports effectively.
• Documentation: Maintain documentation of data sources, data models, and reporting processes. Create and update documentation for data-related procedures and best practices.
• Database Management: Work with database administrators to optimize and maintain data storage solutions. Monitor and tune database performance.
• Continuous Improvement: Stay up-to-date with industry best practices and emerging technologies. Identify opportunities to enhance data reporting processes and recommend improvements.
• Training and Support: Provide training and support to end-users on how to access and utilize data and reports. Assist in troubleshooting issues and providing technical guidance.
• Project Management: Manage data and reporting projects, including planning, coordination, and execution.
• Data Visualization: Create visually appealing and informative data visualizations to convey insights effectively.
• Performance Monitoring: Monitor system performance related to data and reporting, identifying and addressing bottlenecks or issues.

Requirements:

The candidate should be skilled in building reports, writing SQL server queries & stored procedures, Visual Basic for Applications, Crystal Reports and Data Analysis tools.