Develop and modernize enterprise Power BI reports using PBIP, advanced DAX, certified semantic models, Live Connections, and DirectQuery. Reconcile new reports with legacy systems, validate calculations and KPIs, optimize performance, and support UAT and enterprise rollout. Collaborate with architects, engineers, analysts, QA teams, and stakeholders in Agile environments while following Git, Azure DevOps, source-control, governance, and release-management standards.
- 5+ years of hands-on experience developing enterprise Power BI solutions
- 3+ years working with Power BI Service, Semantic Models, and enterprise deployment practices
- Experience building reports using PBIP (Power BI Project) format and source-controlled development methodologies
- Experience developing complex DAX measures, KPIs, calculated tables, and advanced calculations
- Experience working with certified/shared semantic models using Live Connection and DirectQuery approaches
- Experience migrating and modernizing legacy BI platforms (SSRS, Cognos, Business Objects, Tableau, or legacy Power BI reports)
- Experience working in Agile delivery teams and collaborating with Data Architects, Data Engineers, and Business Analysts. Experience with Git-based version control and deployment processes
Experience supporting large-scale reporting programs from pilot through enterprise rollout
Required
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field
- 5+ years of Power BI development experience
- Strong understanding of Semantic Modeling concepts
- Advanced DAX development skills
- Experience with Power BI Service and Workspace administration
- Experience developing reports using PBIP / Power BI Projects
- Experience consuming Enterprise Semantic Models using Live Connections
Strong SQL skills for validation and reconciliation activities - Experience with Git repositories and source control workflows
- Microsoft Power BI Data Analyst Associate (PL-300)
- Experience with TMDL (Tabular Model Definition Language).
- Experience with XMLA endpoints and Tabular Editor
- Experience with SSRS/Paginated Reports (RDL)
- Experience with Fabric Semantic Models and Databricks
- Experience supporting Finance, ERP, or Enterprise Data Warehouse reporting solutions
- Experience working with Azure DevOps
- Power BI Development Power BI Desktop
- Power BI Service
- PBIP (Power BI Projects)
- Power Query (M)
- Report Optimization
- Dashboard Design
- Drill-through Reporting
- Bookmarks
- Tooltips
- Dynamic Visualizations
- Semantic Modeling
- Semantic Models
- Certified Datasets
- Shared Datasets
- Live Connections
- Composite Models
- Star Schema Concepts
- Relationship Management
- Calculation Groups
- TMDL
- XMLA Endpoints
- DAX & Analytics
- Advanced DAX Measures
- Filter Context
- Row Context
- Time Intelligence
- KPI Design
- Calculation Validation
- Data Reconciliation
- Reporting & Modernization
- Legacy Report Conversion
- Report Parity Validation
- Financial Reporting
- Operational Reporting
- Report Standardization
- Self-Service Analytics
- DevOps & Collaboration
- Git
- Azure DevOps
- Source Control
- Release Management
- Agile/Scrum
- Stakeholder Management
- This role will work closely with Data
- Architects, Data Engineers, Business Analysts, and business stakeholders throughout the lifecycle of a large-scale analytics modernization initiative
- The developer will build report deliverables on top of certified semantic models, support measure development, perform report reconciliation activities, and help deliver reporting capabilities across multiple business domains
- Key Responsibilities
- Report Development
- Design and develop Power BI reports and dashboards using PBIP project format
- Build interactive visualizations, drill-through functionality, bookmarks, and navigation experiences
- Deliver reporting solutions aligned with business requirements and enterprise standards
- Recreate and modernize legacy reports while preserving business logic and formatting consistency
- Semantic Model Consumption
- Consume shared and certified semantic models using Live Connections
- Collaborate with semantic model architects to identify reporting requirements
- Assist in creation and maintenance of measures under senior technical guidance
- Validate model usability and performance for reporting workload
- DAX Development
- Develop and optimize complex DAX calculations and KPIs
- Create reusable calculations and reporting standards
- Troubleshoot DAX performance issues
- Ensure accurate implementation of business calculation logic
- Validation & Reconciliation
- Perform detailed reconciliation between legacy reports and new Power BI deliverables
- Validate measures, calculations, totals, subtotals, and KPIs
- Work with business users to resolve discrepancies
- Support UAT and business signoff activities
- Follow version control, branching, and deployment standards
- Document development processes and report design decisions
- Support release management activities
Collaboration - Work closely with architects, engineers, QA analysts, and business stakeholders
- Participate in sprint planning, design reviews, and project governance meetings
- Provide technical guidance for reporting best practices and standards
- Success Metrics
- Delivery of high-quality Power BI reports on schedule
- 100% reconciliation accuracy against legacy reporting systems
- Reduced report maintenance through reusable measures and standardized design
- Adherence to governance, source-control, and deployment standards
- Successful rollout of domain reporting packages from pilot through enterprise deployment
Datavail’s Data Management Services:
Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.
Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead response and remediation for critical security incidents, coordinating global teams and executive communications. Develop and maintain incident command protocols, playbooks, and procedures; facilitate tabletop exercises; conduct investigations; track incident metrics; and support post-incident reviews and root cause analyses. The role also improves and automates major security incident processes while communicating risks, decisions, milestones, and blockers to technical and executive stakeholders.
Top Skills:
Ai-Powered ToolsMitre Att&CkServicenowWorkflow Automation
Cloud • Security • Software • Cybersecurity • Automation
Leads GitLab’s Department of War regional sales organization, managing, recruiting, and coaching Account Executives while driving new and expansion revenue. Responsibilities include forecasting, MEDDPICC-based deal inspection, complex federal procurement, executive negotiations, partner and distributor engagement, FedRAMP go-to-market strategy, and land-and-expand growth. The role collaborates cross-functionally with Renewals, Customer Success, Product, and Marketing in an all-remote environment and travels as needed for customer and team engagements.
Top Skills:
CRMDevsecopsFedrampGitlabMarketing AutomationSalesforce
Greentech • Real Estate • Social Impact • Energy • Industrial • Solar • Renewable Energy
Administer and optimize enterprise AVEVA PI environments supporting real-time power infrastructure and control center operations. Configure OT data collection and integrations from SCADA, DCS, RTUs, PLCs, and related systems. Lead architecture improvements, troubleshooting, infrastructure maintenance, modernization, automation, telemetry feeds, project onboarding, documentation, and stakeholder coordination. Develop solutions using Python, PowerShell, and .NET while mentoring junior team members and supporting Operations Engineering.
Top Skills:
.NetAspentech Osi MonarchAveva ConnectAveva Pi SystemDcsDnp3Ge WindscadaIgnitionAzureMicrosoft Hyper-VMicrosoft Sql ServerModbusMySQLOpcOrionlxPi AdaptersPi Asset FrameworkPi CollectivesPi ConnectorsPi Data ArchivePi InterfacesPi VisionPi Web ApiPlcsPostgresPowershellPythonRtusScadaSel RtacTcp/IpVMware
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
