Job Summary

We are looking for an experienced Data Analyst / Reporting Analyst to support our business operations, projects, and leadership teams with high-quality reports, dashboards, and data-driven insights. This role involves gathering business requirements, building and optimizing queries, automating workflows, and ensuring data security across all reporting pipelines. You will play a critical role in providing timely and actionable analytics that drive decision-making and operational efficiency.

Job Responsibilities

• Ability to gather business requirements and translate the requirements to reports and dashboards
• Create simple yet effective dashboards, reports, etc. as needed by the business in support of projects and operational requirements
• Provide actionable insights by performing data analysis and data mining
• Perform complex ad hoc data queries and provide data extracts as needed by the business
• Create and update documentation and help maintain the team document portal
• Build complex queries on large volumes of data using SQL
• Act as primary Analyst for urgent data and reporting requirements as required by the Leadership team
• Act as L1/L2 Analyst for urgent operational data requirements
• Ability to provide requirements, updates, and resolve known issues in timely manner
• Support Delivery team in the distribution of reports, data files, etc. via email and sftp, and maintenance of distribution list
• Create and update operations support documentation, and maintain tech and operations support document portal
• Ensure data security practices in the deployed pipelines
• Standardize different queries and optimize them to speed up query times
• Build automation workflows and ensures job uptime and performance
• Attend escalated support calls during business hours and outside business hours (e.g. weekdays after 6 PM, during weekends and holidays, etc.)
• Identify automation opportunities and implement workflows
• Maintain uptime for different automation tasks

Job Requirements

• Experience working with SQL required
• Experience in Google Data Studio, Google Sheets, Excel required
• Experience in Google BigQuery, Tableau, Power BI, Metabase, DaaS preferred
• Experience in Hadoop or Big Data technologies preferred
• Experience working with MySQL preferred
• Experience working with Python/Scala preferred
• Experience in JIRA and Confluence preferred
• 3-5 years of experience in software development or QA roles.

About CLPS RiDiK

RiDiK is a global technology solutions provider and a subsidiary of CLPS Incorporation (NASDAQ: CLPS), delivering cutting-edge end-to-end services across banking, wealth management, and e-commerce. With deep expertise in AI, cloud, big data, and blockchain, we support clients across Asia, North America, and the Middle East in driving digital transformation and achieving sustainable growth. Operating from regional hubs in 10 countries and backed by a global delivery network, we combine local insight with technical excellence to deliver real, measurable impact. Join RiDiK and be part of an innovative, fast-growing team shaping the future of technology across industries.

Please refer to job description.