|
While the intent may be a long-term tenure, this position is subject to annual budget restrictions. The initial contract is through the end of this fiscal year and is anticipated to be renewed July 1st, 2026.
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.
|
