1. Semantic Modeling & Data Architecture
- Design develop and optimizePower BI semantic modelsusing bestpractice 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 complexDAX measures calculated columns and tablesto 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 compellingPower BI dashboardsthat 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 bothOracleandSQL Serverenvironments.
- 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 Bachelors 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 experienceinboth 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.
| | Required / Desired | | |
| Bachelors degree in Computer Science Information Systems Data Analytics or related field. | Required | | |
| Solid SQL development experience in both Oracle and SQL Server. | Required | | |
| IT development experience | Required | | |
| Experience with Power BI administration including gateways RLS/OLS workspace governance and capacity management | Required | | |
| experience as an Oracle BI development using OBIEE Semantic model (RPD) interactive reports and dashboard | Required | | |
| Experience working with large complex data sets in a multi-system environment | Required | | |
1. Semantic Modeling & Data Architecture Design develop and optimizePower BI semantic modelsusing bestpractice dimensional modeling techniques (star schema snowflake dataflows shared datasets). Build enterprise-grade datasets with proper relationships hierarchies calculation groups and incremental ...
1. Semantic Modeling & Data Architecture
- Design develop and optimizePower BI semantic modelsusing bestpractice 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 complexDAX measures calculated columns and tablesto 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 compellingPower BI dashboardsthat 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 bothOracleandSQL Serverenvironments.
- 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 Bachelors 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 experienceinboth 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.
| | Required / Desired | | |
| Bachelors degree in Computer Science Information Systems Data Analytics or related field. | Required | | |
| Solid SQL development experience in both Oracle and SQL Server. | Required | | |
| IT development experience | Required | | |
| Experience with Power BI administration including gateways RLS/OLS workspace governance and capacity management | Required | | |
| experience as an Oracle BI development using OBIEE Semantic model (RPD) interactive reports and dashboard | Required | | |
| Experience working with large complex data sets in a multi-system environment | Required | | |
View more
View less