Role & responsibilities Data Analysis & Reporting: Collect, clean, and analyze large datasets to identify trends, patterns, and insights that support business objectives. Develop, maintain, and enhance interactive Power BI dashboards and reports that provide actionable insights to key stakeholders. Dashboard Development: Design and implement visually appealing and user-friendly dashboards using Power BI, ensuring consistency with organizational standards. Utilize advanced visualization techniques to clearly communicate complex data sets in a comprehensible manner. Data Transformation & Modeling: Write complex queries using T-SQL to extract and manipulate data from relational databases. Develop and optimize data models using Power Query, M-Query, and DAX to support robust reporting and analytics. Document Transformations Collaboration & Communication: Work closely with cross-functional teams, including business stakeholders, IT, and other analysts, to understand data requirements and deliver insights. Present findings and recommendations to management, translating technical details into clear, actionable business language. Continuous Improvement: Stay up-to-date with industry trends and best practices in data analytics and visualization. Identify opportunities to improve existing processes and tools, ensuring data quality and integrity. Preferred candidate profile Technical Proficiency: M-Query: Extensive experience in using M-Query for data transformation and Power Query. DAX: Proven expertise in writing and optimizing DAX expressions for complex data models. T-SQL: Strong proficiency in T-SQL for data extraction, manipulation, and reporting. Data Warehousing: Kimball data warehousing knowledge and Implementation. Power Query: Advanced knowledge in using Power Query to connect, combine, and refine data sources. Data Visualization: Exceptional skills in designing and implementing effective data visualizations and dashboards using Power BI. Power BI Expertise: Demonstrated experience in creating interactive and comprehensive Power BI dashboards. Certifications: Power BI Data Analyst Associate certification is highly desirable. Experience: A minimum of 6+ years of experience in data analysis, business intelligence, or a related field. Proven track record of successfully delivering end-to-end data analytics solutions. Soft Skills: Excellent analytical and problem-solving skills. Strong communication and presentation skills. Ability to work independently and collaboratively in a fast-paced environment. Detail-oriented with a focus on data quality and accuracy. Interested candidates, kindly email your resume to tanveer.ansari@clickflow.co.uk with your updated resume.

Role & responsibilities Clickflow is seeking a meticulous and technically proficient Data Tester to join our growing data analytics team. The ideal candidate will be responsible for ensuring the quality, accuracy, and integrity of our data solutions, with a strong focus on ETL processes, data warehousing, and Power BI reports built on the Microsoft Azure platform. In this role, you will be a critical player in our data governance and quality assurance framework. You will collaborate closely with data engineers, data analysts, and business stakeholders to validate data pipelines and ensure that our data-driven insights are reliable and accurate. If you have a passion for data, a keen eye for detail, and a strong background in Azure technologies, we encourage you to apply. Key responsibilities ETL and Data Pipeline Testing: Design, develop, and execute comprehensive test plans, test cases, and test scripts for ETL processes. Validate data extraction, transformation, and loading logic to ensure data accuracy, completeness, and consistency from source to target systems. Data Solution Validation: Perform end-to-end testing of data warehousing solutions and data models. Verify data integrity and quality across various data stores within the Azure ecosystem. Power BI Report Testing: Meticulously test Power BI reports and dashboards for data accuracy, functionality, performance, and visual representation. Validate calculations, filters, and slicers to ensure they meet business requirements. Azure Technology Expertise: Leverage your knowledge of the Azure data stack, including Azure Data Factory (ADF), Azure Synapse Analytics, Azure Databricks, and Azure SQL Database, to perform thorough testing. SQL Proficiency: Write and execute complex SQL queries for data validation, reconciliation, and to identify data anomalies. Defect Management: Identify, document, and track defects in a clear and concise manner using defect tracking tools. Work closely with the development team to facilitate the resolution of identified issues. Test Automation: Contribute to the development and maintenance of automated testing frameworks to improve the efficiency and coverage of data testing. Collaboration and Communication: Actively participate in agile ceremonies and effectively communicate testing progress, results, and risks to project stakeholders. Preferred candidate profile Proven Experience: 5 years of experience in a Data Tester, ETL Tester, or similar quality assurance role. ETL Testing Expertise: Strong understanding of ETL concepts and hands-on experience in testing ETL pipelines and data transformations. Microsoft Azure Proficiency: Demonstrable experience with Azure data services such as: Azure Data Factory (ADF) Azure Synapse Analytics Azure Databricks Azure SQL Database/Managed Instance Azure Data Lake Storage (ADLS) Power BI Knowledge: Experience in testing Power BI reports and dashboards, with a good understanding of DAX. Advanced SQL Skills: The ability to write complex SQL queries to query and validate large datasets is essential. Analytical and Problem-Solving Skills: A sharp analytical mind with the ability to troubleshoot complex data issues. Attention to Detail: A meticulous approach to testing to ensure the highest level of data quality. Communication Skills: Excellent verbal and written communication skills, with the ability to articulate technical issues to both technical and non-technical audiences. Experience with test management tools (e.g., Azure DevOps, Jira). Knowledge of data warehousing concepts (e.g., dimensional modeling). Familiarity with scripting languages such as Python for test automation. Relevant Microsoft Azure certifications (e.g., Azure Data Engineer Associate, Azure Fundamentals).