Report/Power BI Developer

Atyeti; Princeton (NJ); On-site; USD 110,000 - 170,000; Full time

Job summary

Atyeti is seeking a Power BI Expert to design, develop, implement and govern scalable Power BI solutions for clients. You will apply expertise in data modeling, governance, and embedded analytics to build reliable dashboards and reports that meet business needs.

Responsibilities include configuring gateways, defining workspace policies, implementing row level security, optimizing data loads, and collaborating with data engineers and stakeholders to drive data quality and adoption.

Qualifications

• Strong Power BI architecture and governance experience.
• Proficient in data modeling, DAX, and SQL performance tuning.
• Experience with Power BI gateways, workspace policies, and security.
• Familiarity with Power BI Embedded and REST APIs.
• Ability to collaborate with cross-functional teams and translate business needs.

Responsibilities

• Design, develop, and deploy Power BI reports and dashboards.
• Create efficient data models to optimize performance and scalability.
• Develop complex DAX expressions for business logic and calculations.
• Configure and manage Power BI Data Gateways and enforce security policies.
• Define governance framework and monitor user access and usage analytics.
• Integrate Power BI with external apps and automate workflows via REST APIs.

Skills

Power BI

DAX

SQL

Data governance

ETL

PowerApps

Power Automate

REST APIs

Security

Tools

Power BI Gateway

Job description

JOB SUMMARY

Role Overview: We are seeking a highly skilled Power BI Expert to design, develop, implement and governance of Power BI solutions. Ideal candidate will have in-depth knowledge of Power BI architecture, data modeling, governance, embedded analytics and database management. The role requires expertise Power BI Data Gateways, report deployment, and governance frameworks ensuring scalable and secure data solutions.

PRIMARY RESPONSIBILITIES

• Power BI Lead & Implementation:
• Design, develop, and deploy interactive Power BI reports and dashboards.
• Create efficient data models to optimize performance and scalability.
• Develop complex DAX expressions for business logic and calculations.
• Optimize report performance by using best practices in Power BI and SQL
• Power BI Architecture & Configuration:
• Configure and manage Power BI Data Gateways for secure and seamless data access
• Define and enforce Power BI workspace, dataset, and security policies.
• Implement row-level security (RLS) and data governance best practices.
• Establish data refresh schedules and ensure efficient data ingestion pipelines.
• Maintain and enhance Power BI Premium and Embedded solutions.
• Embedded Analytics & Integration:
• Integrate Power BI reports with external applications using Power BI Embedded.
• Work with Power BI REST APIs to automate workflows.
• Integrate Power BI with Oracle, SQL Server, MySQL, Microsoft Share point, Excel, Cloud data source etc.,
• Database & Performance Optimization:
• Write optimized SQL queries and stored procedures for report development.
• Ensure high-performance data refreshes and query execution.
• Work with ETL team to improve data integration with PowerBI
• Governance & Security:
• Define Power BI governance framework and best practices for standardization.
• Monitor user access, performance, and usage analytics to drive efficiency.
• Manage user roles, access controls, and data security.
• PowerApps & Power Automate (Nice to Have):
• Build PowerApps applications to extend Power BI functionality and create interactive business solutions
• Automate data flows and reporting updates using Power Automate (Flows, Triggers, Approvals, Notifications, etc.).
• Integrate Power BI, PowerApps, and Power Automate to create end-to-end business process automation.
• Stakeholder Collaboration & Training:
• Work closely with business users, data engineers, and leadership teams to understand and document reporting requirements.
• Provide training and best practice guidance to Power BI users across the organization.
• Develop self-service Power BI frameworks to empower business teams for reporting.