Data Analytics and Automation Specialist (Mid-Level)

We are seeking a Data Analytics and Automation Specialist to develop reliable reports and analytical solutions, work with data from business systems, and improve repetitive processes through automation.

The role focuses on SQL, databases, data validation, and the design of clear, useful reports. The specialist will also contribute to workflow and RPA initiatives and explore practical uses of AI where they solve a defined business need. The position requires independent delivery of well-scoped tasks and close collaboration with business and technical teams.

Basic Requirements

• Ability to translate business questions and reporting requirements into datasets, metrics, reports, and clear acceptance criteria.
  
• Ability to write and troubleshoot SQL queries independently and understand relational data models, joins, aggregations, and data quality issues.
  
• Ability to investigate discrepancies between source records and report results and explain findings to stakeholders.
  
• Familiarity with structured delivery, documentation, version control, and collaboration across business and IT teams.
  
• Interest in process automation and responsible, practical use of AI tools.

Key Responsibilities

• Gather and clarify reporting needs, definitions, filters, refresh frequency, and expected outputs with business stakeholders.
  
• Design, build, maintain, and improve operational and management reports, dashboards, datasets, and analytical queries.
• Write and optimize SQL queries; work with relational databases to extract, combine, and analyze data from different sources.
  
• Validate report figures against source systems and agreed business rules; investigate and resolve data discrepancies.
  
• Document report logic, KPI definitions, data sources, dependencies, and usage instructions.
  
• Analyze trends and exceptions and present findings in a clear, actionable form.
  
• Map business workflows, identify repetitive steps suitable for automation, and contribute to RPA or workflow solutions.
  
• Develop or adjust scripts and automation components within the team’s standards; document and monitor the resulting processes.
  
• Explore AI-assisted solutions for specific analysis or workflow tasks, assess output quality and data sensitivity, and implement approved use cases with the team.
  
• Collaborate with business analysts, developers, and system owners to clarify requirements and resolve reporting or automation issues.

Required Skills & Qualifications

• At least 2 years of relevant experience in reporting, data analysis, business intelligence, or data-focused development.
  
• Solid practical SQL skills, including complex joins, common table expressions, aggregations, and query troubleshooting.
  
• Experience working with relational databases and understanding schemas, data types, keys, and data integrity.
  
• Hands-on experience creating reports or dashboards in a BI or reporting platform and validating business metrics.
  
• Ability to document technical logic and communicate clearly with both technical and business colleagues.
  
• Analytical thinking, attention to detail, and ability to prioritize and deliver tasks independently.

Preferred Qualifications

• Experience with Oracle or PostgreSQL, including PL/SQL or comparable procedural SQL.
  
• Experience with enterprise BI tools such as SAP BusinessObjects or comparable platforms.
  
• Practical knowledge of a scripting language such as Python for data processing or automation.
  
• Exposure to RPA platforms, workflow automation, APIs, or integrations between business applications.
  
• Familiarity with AI tools or APIs for analysis and automation, including evaluation of output and safe handling of company data.
  
• Experience using Jira, Git, or comparable collaboration and version control tools.

Additional Information

• Work environment: Collaborative and cross-functional, with a strong focus on data quality, reliable reporting, and practical solutions for business users.
  
• Location: Office-based or hybrid, depending on project and team needs.

Summary

The specialist will turn business needs and source data into trustworthy reports and useful analyses, while contributing to workflow and RPA initiatives. Success in this role means accurate results, understandable documentation, dependable delivery, and practical improvements to existing processes.