SQL Data Engineer & Power BI Developer – Bike-Share Business Intelligence Dashboard

What We Need Our data lives in two separate yearly tables (bike_share_yr_0 and bike_share_yr_1) alongside a cost table. We need someone who can architect the SQL layer correctly before any visualization work begins. Specifically, the analyst should be able to write CTEs to union multi-year datasets into a single, consistent source, join ridership data with pricing and cost-of-goods tables to derive revenue and profit at the rider level, calculate profit margin percentages across fiscal years, build a rolling 3-hour moving average for riders using SQL window functions (AVG() OVER), flag operational stress periods where the moving average exceeds a defined rider threshold (our capacity ceiling is around 500 riders per hour), and segment riders by type (registered vs. casual) and compute retention rates as a percentage of total ridership per year. Dashboard Requirements (Power BI) The final deliverable is a two-page interactive dashboard. Page 1 covers the Business Overview: top-line KPIs including total riders, total revenue, total profit, and profit margin; a KPI trend line across months with 2021 and 2022 side by side; revenue breakdown by season; rider demographic split between registered and casual users; and an hourly revenue table by weekday showing peak earning windows. Page 2 covers Performance and Fiscal Analysis: an hourly demand vs. capacity chart with a threshold line marking staff-trigger points; registered vs. casual rider volume comparison across years; year-over-year revenue vs. profit bar charts; and a monthly hourly demand heatmap for operational planning. Ideal Candidate You are comfortable with T-SQL (CTEs, window functions, aggregate calculations), have production experience with Power BI, and understand how to connect business questions, when are we most profitable, when do we need more staff, to data design decisions. This is not a beginner task. We expect clean query structure, well-labeled visuals, and a dashboard that a non-technical operations manager can navigate without guidance. Deliverables A commented, production-ready .sql file with all analytical queries. A two-page Power BI .pbix dashboard file. A brief write-up explaining key findings per visual, which can be included within the dashboard itself.