Project Description

We are seeking a skilled BI Architect / Data Engineer to develop an end-to-end data solution for a finance and audit-related business. The role involves extracting data from APIs and Excel files, transforming it using Python-based ETL processes, and loading it into a structured SQL Server data warehouse. The candidate will be responsible for cleaning and standardizing financial data, designing efficient data models and ensuring data accuracy, integrity, and performance. The solution should support audit and financial reporting use cases such as transaction analysis, financial statements, compliance tracking, and variance analysis. In addition, the candidate will develop interactive dashboards in Power BI based on the data warehouse to provide clear insights for business stakeholders. Experience with building scalable ETL pipelines, handling multiple data sources, designing data warehouses, and creating dashboards is required. Attention to detail, data accuracy, and strong analytical/problem-solving skills are essential for this role.