Hybrid Role – Oaks PA || Data and Intelligence-AnalyticsPower BI || Locals Only

Hybrid  Role – Oaks PA

Role: Data and Intelligence-Analytics-BI Reporting-Power BI

Location: Oaks, PA (Hybrid-Local candidates only)

6+ months

Responsibilities:

Design scalable semantic data models using Power BI datasets and Azure/SQL-based data sources.
Develop complex DAX calculations, measures, and KPIs.
Implement Row-Level Security (RLS) and data access strategies.
Integrate Power BI with Azure Data Factory, Synapse, Databricks, Snowflake, or other enterprise platforms.
Optimize performance of large datasets and enterprise reports.
Translate business requirements into technical BI solutions.
Work closely with business stakeholders, product owners, and data engineers.
Provide effort estimations, solution architecture documentation, and technical proposals.
Present dashboards and analytics insights to executive leadership.

Strong & must have expertise in:
DAX (advanced calculations, time intelligence, optimization)
Power Query (M language)
Data modeling (star schema, snowflake schema)
SQL (advanced querying, performance tuning)
Experience with Azure Data Platform (ADF, Synapse, Azure SQL, ADLS).
Strong understanding of BI architecture, governance, and security models.
Microsoft Fabric Capacity Usage. 
Direct Lake Concept,
Managed Aggregations, 
XML point-based Refresh for Semantic Models,
AI Techniques and Visuals ex: De-Composition Tree, Q&A, Fore-caste etc,
Deneb Visuals,
Native Charts,
Persona Based Visuals,
SQL Query Optimisation,
Power BI Reports Code Integration,
Embedding Power Bi Reports to Application.
Experience leading technical teams (onshore/offshore model preferred).  

Qualifications
8+ years of experience in BI/Data Analytics.
5+ years of hands-on experience with Power BI development.
 
Day to Day job Duties: (what this person will do on a daily/weekly basis) 
Design scalable semantic data models using Power BI datasets and Azure/SQL-based data sources.
Develop complex DAX calculations, measures, and KPIs.
Implement Row-Level Security (RLS) and data access strategies.
Integrate Power BI with Azure Data Factory, Synapse, Databricks, Snowflake, or other enterprise platforms.
Optimize performance of large datasets and enterprise reports.
Translate business requirements into technical BI solutions.
Work closely with business stakeholders, product owners, and data engineers.
Provide effort estimations, solution architecture documentation, and technical proposals.
Present dashboards and analytics insights to executive leadership.
 
Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)
Bachelor’s degree in Computer Science, Information Systems, or related field.
8+ years of experience in BI/Data Analytics.
5+ years of hands-on experience with Power BI development.

Nice to Have; (But not a must)
Familiarity with Agile/Scrum methodologies. Domain experience in Healthcare, Banking, Manufacturing, or Retail.
Microsoft Power BI or Azure certifications