SQL & Power BI Analytics Developer

I’m ready to overhaul the way our team looks at data and need a developer who can take ownership of the full MS SQL-to-Power BI pipeline. The end goal is clear: deliver rock–solid data analytics that put timely, actionable Sales insights in front of our stakeholders.

You’ll start by refining and expanding our MS SQL Server environment—creating or tuning tables, views, stored procedures, and functions so queries run quickly even on very large fact tables. From there, design a star or snowflake model that makes sense for reporting, then build the ETL logic to keep it populated and up to date. Our source of truth is MS SQL Server, and the semantic layer will live in Power BI; if you’re comfortable incorporating other sources such as flat files or APIs later, that flexibility will be a plus.

Once the data model is solid, craft interactive Power BI dashboards that spotlight Sales performance—pipeline health, revenue trends, win-loss ratios, and regional drill-downs. I expect polished visual standards, sensible DAX, and refresh cycles that won’t keep users waiting.

Deliverables I need to sign off on:
• SQL scripts for all new or modified database objects and the dimensional model
• Automated ETL process (T-SQL, SSIS, or your preferred approach) with clear scheduling and logging
• A Power BI dataset plus at least one fully-built Sales dashboard published to the Power BI Service
• A brief performance and maintenance guide so the team can keep things running smoothly

Acceptance criteria include sub-5-second dashboard load times on common filters and refresh jobs that consistently finish in the allotted window. If this sounds like a challenge you can meet, let’s talk next steps.