IT Power BI Sr. Developer (GA796126)
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.