> Markdown version of [/jobs/ext/1902369-power-bi-automation-developer](https://www.wearedevelopers.com/jobs/ext/1902369-power-bi-automation-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Power BI & Automation Developer - **Company:** Randstad - **Location:** Washington, DC, United States - **Experience:** Experienced - **Salary:** $124,800.0 - $145,600.0 - **Contract:** Permanent contract - **Skills:** Data Dictionary, Power BI, Microsoft Power Automate, Powerquery - **Published:** July 31, 2026 - **Apply:** https://www.dice.com/job-detail/ac19df1a-a7a6-454e-a3a9-f8d375788d47 ## About the Role 4+ years of hands-on experience developing enterprise Power BI dashboards and semantic models. Advanced knowledge of DAX, Power Query (M), data modeling, and visualization best practices. Practical experience building automated data workflows using Microsoft Power Automate. Strong technical writing skills with a focus on data dictionary creation and dashboard documentation. Background in marketing analytics, digital sales performance, or e-commerce reporting is strongly preferred. ## Description The Power BI & Automation Developer will design, build, document, and deploy production-ready reporting dashboards that consolidate marketing, digital sales, and ancillary performance metrics into a single platform. Working directly from briefs provided by the Amtrak analytics team, this role focuses on creating clean visualizations, writing field-level data documentation, and setting up lightweight automated workflows using Microsoft Power Platform tools. The developer will also lead maintenance handoffs to empower Amtrak's internal team to manage dashboards post-launch., Design, build, and optimize production-ready Power BI dashboards adhering to Amtrak design briefs and iterative feedback. Connect Power BI to enterprise data sources, configure access controls, and establish automated refresh schedules. Implement simple automated workflows leveraging Microsoft tooling (e.g., CSV to Power Automate to Power BI). Write comprehensive field-level documentation for each dashboard covering data sources, refresh cadences, DAX metric definitions, and known limitations. Conduct technical handoff sessions for Amtrak team members detailing dashboard architecture and ongoing maintenance procedures. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Blazing Fast Page Navigation with Speculation Rules](https://www.wearedevelopers.com/videos/1570-blazing-fast-page-navigation-with-speculation-rules) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)