What are the responsibilities and job description for the Power BI Lead position at FreshDirect?
Brief Description
Job Title: Power BI Lead
Location: On-Site
Position Type: Full-Time
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.
Candidates with experience in low-code no-code development and workflow automation will be preferred.
Key Responsibilities:
Why choose FreshDirect?
We're a company that thrives on teamwork. Our evolution is driven by our passionate employees and investment in perfecting the technology that lets us deliver the highest-quality food. Our state-of-the-art facility creates an environment for innovation. We support our employees with on-the-job training for plant employees and drivers, team-building activities, workplace recognition opportunities, and by encouraging direct relationships with our suppliers in the field.
Great people deserve great perks. We offer comprehensive benefits, plus many workplace extras, including:
Learn more @FreshDirect on Twitter, Instagram, Facebook, YouTube!
Disclaimer: The above statements are intended to describe the general nature and level of work being performed by the Team member(s) assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of individuals in this position. Position Descriptions may be subject to change as the needs of the organization change.
As an EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER, FreshDirect does not discriminate against applicants or employees because of their race, color, citizenship status, national origin, ancestry, sex, gender, sexual orientation, age, religion, creed, marital status, veteran status, domestic violence victim status, familial status, or on any other basis prohibited by law. Furthermore, FreshDirect will not discriminate against any applicant or employee because they are disabled, a disabled veteran, or a veteran of the Vietnam era, provided they are qualified and meets the requirements established by FreshDirect for the job.
Job Title: Power BI Lead
Location: On-Site
Position Type: Full-Time
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.
Candidates with experience in low-code no-code development and workflow automation will be preferred.
Key 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.
- Troubleshoot Power BI performance and user issues.
- Power BI Expertise: Deep understanding of Power BI Desktop, Service, and Embedded.
- Data Modeling & Analytics: Solid understanding of data modeling, relational databases, and analytics principles. Ability to create meaningful insights through Power BI.
- Data Transformation: Strong expertise in DAX expressions, Power Query (M) and SQL for data transformation
- Database Knowledge: Strong knowledge using databases like Oracle, MSSQL, MySQL, Postgres. Familiarity with Cloud databases will be a plus.
- Power BI Data Gateway: Experience with on-premises and cloud data gateway setup and configuration.
- Embedded Analytics: Experience integrating Power BI into custom applications (Power BI Embedded, REST API, Power Automate, etc.).
- Governance & Security: Familiar with Power BI Admin Portal, security models, compliance, and monitoring tools.
- ETL & Data Integration: Understanding of ETL tools.
- CI/CD & Deployment: Experience deploying reports using DevOps pipelines, Power BI Deployment Pipelines.
- Project Management: Strong understanding of Agile methodologies, experience in an Agile environment, and the ability to manage project timelines and priorities.
- Communication Skills: Strong verbal and written communication skills, with the ability to effectively communicate technical concepts to non-technical stakeholders.
- Problem-Solving: Ability to think critically and creatively to solve complex business problems with Power Platform solutions.
- Experience with PowerApps and Power Automate for automation and low-code no-code solutions will be a plus.
- Minimum of 3-5 years of hands-on experience working with Microsoft Power BI.
- Proven experience in developing and deploying enterprise-grade solutions using Power BI.
- Experience working in a consulting, client-facing, or enterprise environment is a plus.
Why choose FreshDirect?
We're a company that thrives on teamwork. Our evolution is driven by our passionate employees and investment in perfecting the technology that lets us deliver the highest-quality food. Our state-of-the-art facility creates an environment for innovation. We support our employees with on-the-job training for plant employees and drivers, team-building activities, workplace recognition opportunities, and by encouraging direct relationships with our suppliers in the field.
Great people deserve great perks. We offer comprehensive benefits, plus many workplace extras, including:
- 10 PTO days
- Company paid holidays
- 401k (5% match after 60 days)
- 20% off at freshdirect.com and significant markdowns at our employee market
- 24-hour access to the FreshDirect shuttle between our Bronx headquarters and the subway
- Regular events and barbecues for employees
Learn more @FreshDirect on Twitter, Instagram, Facebook, YouTube!
Disclaimer: The above statements are intended to describe the general nature and level of work being performed by the Team member(s) assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of individuals in this position. Position Descriptions may be subject to change as the needs of the organization change.
As an EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER, FreshDirect does not discriminate against applicants or employees because of their race, color, citizenship status, national origin, ancestry, sex, gender, sexual orientation, age, religion, creed, marital status, veteran status, domestic violence victim status, familial status, or on any other basis prohibited by law. Furthermore, FreshDirect will not discriminate against any applicant or employee because they are disabled, a disabled veteran, or a veteran of the Vietnam era, provided they are qualified and meets the requirements established by FreshDirect for the job.
Salary : $105,800 - $129,908
