Centralized AI-Powered Business Reporting System
Employer not named by the sourceRemote
AI/MLVibe CodingFull StackFreelance and contract gigs
Frontier is not the employer and does not collect applications.
About this role
Python, Data Processing, SQL, Data Analytics, Data Integration, Power BI, Data Management, Pandas · AI-Powered Sales & Operations Reporting System with Automated ETL Pipeline and
Power BI Dashboard
We are looking for an experienced Data Analytics & Automation Developer to build a fully automated reporting solution that consolidates business data from multiple sources into a centralized Power BI dashboard. Project Overview:
Our company currently relies on several disconnected systems including Excel reports, SQL databases, CRM exports, and online APIs. Reporting is manual, time-consuming, and prone to errors. We require an automated data pipeline that extracts, cleans, validates, and combines data into a single reporting database while providing executive-level Power BI dashboards with real-time KPIs. The selected freelancer will be responsible for designing and implementing an end-to-end automated analytics solution, including:
We are using the following databases - Microsoft Excel files (multiple folders) - SQL Server / MySQL database - REST APIs (CRM and ERP) - CSV exports - SharePoint / OneDrive (optional) You are expected to develop Python scripts that automatically: - Import new files - Clean and validate data - Remove duplicates - Standardize formats - Merge dataset