GDOT - Power BI Sr. Developer

1. Semantic Modeling & Data Architecture

• Design, develop, and optimize Power BI semantic models using best practice dimensional modeling techniques (star schema, snowflake, dataflows, shared datasets).
• Build enterprise-grade datasets with proper relationships, hierarchies, calculation groups, and incremental refresh.
• Collaborate with data engineering teams to define data requirements, improve data quality, and ensure model scalability and maintainability.
• Implement data modeling standards that support self-service analytics and governed data access.

2. Advanced DAX Programming

• Develop complex DAX measures, calculated columns, and tables to support business logic, KPIs, and analytical insights.
• Optimize DAX for performance, readability, and maintainability across large datasets.
• Troubleshoot calculation issues and ensure accuracy and consistency across reports and dashboards.
• Implement row-level and object-level security (RLS/OLS) within the semantic model.

3. Visualization & Dashboard Development

• Build intuitive, visually compelling Power BI dashboards that communicate insights clearly and effectively.
• Apply data visualization best practices and data storytelling techniques to support decision-making.
• Create interactive features such as drill-throughs, bookmarks, custom visuals, and parameterized reports.
• Ensure dashboards meet accessibility, usability, and design standards.

4. SQL Development (Oracle & SQL Server)

• Write efficient, well-structured SQL queries, stored procedures, and views to support BI data pipelines.
• Perform data profiling, validation, and transformation using SQL in both Oracle and SQL Server environments.
• Collaborate with DBAs and data engineers to optimize query performance and ensure data integrity.

5. Power BI Administration & Governance

• Manage Power BI Service components including workspaces, datasets, data gateways, refresh schedules, and capacity utilization.
• Support governance initiatives such as dataset certification, naming conventions, documentation, and version control.
• Monitor performance, troubleshoot refresh failures, and optimize dataset size and gateway performance.
• Assist with tenant-level administration including user access, licensing, and compliance with organizational policies.

6. Collaboration & Stakeholder Engagement

• Work closely with business stakeholders to gather requirements and translate them into scalable BI solutions.
• Provide guidance and support to self-service BI users across the organization.
• Document data models, DAX logic, SQL scripts, and report specifications.
• Participate in Agile or project-based workflows to support continuous improvement of BI capabilities.

Required Qualifications

• 4-years Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.
• 5+ years of hands-on Power BI development experience.
• Strong expertise in:
  • Semantic modeling (star schema, dataflows, composite models)
  • Advanced DAX programming
  • Power Query (M language)
  • Power BI Desktop and Power BI Service
• Solid SQL development experience in both Oracle and SQL Server.
• Experience with Power BI administration, including gateways, RLS/OLS, workspace governance, and capacity management.
• Strong understanding of relational and dimensional modeling concepts.
• Ability to communicate complex technical concepts to non-technical audiences.

Preferred Skills

• Familiarity with Oracle Business Intelligence (OBIEE) Semantic model (RPD), interactive reports and dashboard.
• Knowledge of enterprise data governance frameworks.
• Experience working with large, complex data sets in a multi-system environment.