Job
Description
Control Risks is seeking a highly technical, detail-oriented Data Analyst to join our Data & Technology Consulting (DTC) team. This role is deeply embedded in data analytics, scripting, ETL workflows, and reporting. The candidate is required to have strong skills in Python, SQL, Power BI, Microsoft Fabric, and PowerApps. The successful candidate will play a critical role in developing and implementing data solutions that power our consulting engagements. This is not a generic data analyst role, we're looking for a problem-solver who thrives in complex, fast-paced environments, is confident writing production-level code, and can develop intuitive, scalable reporting solutions. Tasks & responsibilities: • Interrogate, clean, and assess structured and unstructured data for integrity, completeness, and business relevance. • Build and optimize robust ETL pipelines to normalize disparate datasets and enable downstream analysis. • Write efficient SQL and Python scripts to support custom data transformations, enrichment, and automations. • Design, build, and maintain interactive Power BI dashboards and PowerApps solutions aligned to client and internal requirements. • Interpret and analyse complex financial, operational, and transactional datasets to surface insights and support investigative work. • Document methodologies, code logic, data assumptions, and business context throughout the project lifecycle. • Collaborate across multi-disciplinary teams to ensure timely delivery of work products and reporting solutions. Requirements • Minimum 3 years of hands-on experience with: • Writing production-level SQL and Python for data transformation and automation. • Building and maintaining ETL pipelines for large, messy, and complex datasets. • Designing and deploying workflows and reports using Power BI, PowerApps, and Microsoft Fabric. • Advanced proficiency in Excel (pivoting, modelling, formulas, data wrangling). • Demonstrated experience working with relational databases and open-source tools. • Strong understanding of data structures, normalization, and query optimization. • Proven ability to manage multiple priorities in a deadline-driven environment. • Self-motivated, methodical, and committed to high-quality outcomes. • Excellent written and verbal communication in English. Preferred Skills • Experience in consulting, compliance, or risk advisory environments. • Comfort navigating ambiguity and changing priorities. • Exposure to version control systems (e.g., Git), cloud data tools, or APIs is a plus. Education • Bachelor's Degree in Computer Science, Data Science, Information Systems, or a relevant quantitative field. Show more Show less
