I require an experienced database developer to build and maintain a Power BI reporting solution. The initial scope of work will be to take 10 existing data tables and design a relational database schema to consolidate this data. Microsoft SQL Server is the preferred database platform but not tied to it.
Once the database is built, the second task will be to connect it as a data source to Power BI Desktop and produce 3-5 basic reports visualizing key metrics. Example report types could include pivot tables, charts and dashboards. The reports should present the data in a clear and visually appealing format for business users.
Moving forward, the data will need to be updated on a weekly cadence to keep the reporting fresh. As such, part of the engagement is to establish an automated ETL (extract, transform, load) process to pull the new weekly data from its source location(s) and update the database. The ETL job should be built to run on a scheduled basis, likely overnight on Sundays.
The ideal candidate will have solid experience with SQL Server, relational database design, and connecting Power BI to SQL data sources. Proficiency with Power Query in Power BI for data transformation and an understanding of ETL processes is required. This is a part-time, ongoing engagement and remote work is acceptable. Please provide your hourly rate and relevant work experience.
