Data Specialist

The Data Specialist is responsible for managing and maintaining business-critical data across various company databases, ensuring accuracy, consistency, and efficiency. This role involves creating and generating reports, validating and analyzing data, performing and monitoring backups, troubleshooting issues, and optimizing processes to support smooth business operations. Additionally, the Data Specialist will develop and maintain basic ETL processes using SSIS to automate data integration and streamline reporting. They will also collaborate with other teams to enhance data organization, ensure database integrity, and comply with security policies and industry standards.

Key Results or Performance Indicators:

1. Maintain high data accuracy across databases.

2. Ensure that data validation processes effectively detect and correct inconsistencies.

3. Develop and maintain reliable ETL processes that execute scheduled jobs with minimal failures.

4. Ensure data integration and report generation tasks complete within predefined SLAs

5. Deliver scheduled reports (daily, weekly, ad-hoc) on time and fulfill report requests within agreed turnaround times.

6. Ensure all scheduled database backups are completed successfully.

7. Regularly monitor and verify database backups, conducting successful restoration testing at least once per quarter.

8. Resolve database-related issues within the defined SLA.

9. Minimize recurring data issues through root cause analysis and process improvements.

10. Implement multiple process improvements, report optimizations, or automations per quarter to enhance data processing efficiency.

11. Ensure full compliance with security policies and data governance standards.

Duties and Responsibilities:

 1. Schedule and execute database backups to prevent data loss.

 2. Manage backup storage, restorations and transfers to the Data Warehouse/File Server.

 3. Ensure data consistency and synchronization across systems and applications.

 4. Validate and cleanse data to maintain accuracy and reliability.

 5. Assist the Data Administrator in managing user access controls and permissions.

 6. Monitor and report potential data security issues.

 7. Work with the Data Administrator to identify and resolve database issues.

 8. Analyze and suggest query optimizations for improved database performance.

 9. Extract and generate daily, weekly, monthly, and ad hoc reports.

 10. Develop and maintain basic ETL processes to automate report generation and streamline data integration.

 11. Assist teams in improving report efficiency, data workflows, and resolving data-related issues.

 12. Maintain database documentation, including entity relationship diagrams (ERDs), data dictionaries, and procedures.

13. Generate reports to monitor database performance and data quality.

Competencies / Skills Required:

1. Bachelor’s degree in Computer Science, Information Technology, or any data/technical-related field.

2. 0-2 years of experience in data analyst, data management, database administration, or a related field (fresh graduates are welcome to apply).

3. Experience with at least one of the following databases: SQL Server (MSSQL), Oracle, MySQL, PostgreSQL, or AccessDB.

4. Ability to understand and write complex queries, functions, views, and stored procedures.

5. Experience handling large databases and generating reports using tools like Microsoft Report Builder, SSRS, or Excel (Pivot Tables and Macros). Familiarity with Python, Power BI, or Tableau is a plus.

6. Knowledge of basic ETL processes, query tuning, indexing, backup strategies, and recovery processes.

7. Ability to translate business requirements into reports and data solutions.

8. Experience in creating and maintaining ERDs, data dictionaries, procedures, and process workflows.

9. Ability to explain technical concepts to non-technical users.

10. Strong attention to detail.

11. Proficiency in written and spoken English.

12. Effective communication and collaboration skills.

13. Driven and results oriented.