Associate Project Manager

Job Role - Power BI Lead

9 to 12 Years Experience Required. 

Location - Pune Baner/ Vimaan Nagar 

Work Model - Hybrid (Wednesday and Thursday WFO) 12 PM to 9 PM 

Experience with Banking or GRC Domain is preferred. 

• 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.
•  Troubleshoot Power BI performance and user issues.

Job Role :

o Experience in Front-end web development using JavaScript jQuery,Angular, HTML5, CSS

o Responsible for handling end to end design & execution of all product web interfaces

o Develop new user-facing features & build reusable code and libraries for future use Work closely on UI/UX designs and back end engineers to implement versatile front-end solutions to web development problems

o Design, development, integration, delivery of different UI side modules of the product

o Develop and enhance modular, multilingual, cross-browser front-end applications using Angular, HTML, CSS, JavaScript, XML, JSON, etc.

o Experience in making responsive layouts

o Experience developing in Agile development processes

o Work closely with product management, customer support and SQA to continuously evolve and innovate the product.

o Involvement in the full development life cycle of projects. Working as a part of a team as well as on your own initiative

o Facilitate in the decision-making processes with team members both in terms of new system development and enhancement to current systems

o Experience of full software development life cycle and Agile Strong verbal & written skills required to interact with global teams. Highly motivated, analytical thinking individual

o Since this role involves working closely with users, the ideal candidate would have Knowledge of Relational database/SQL

o Ability to multi-task and work against deadlines/priorities

o Sense of ownership and desire to take on an expanded role over time. Eager to work with new technologies and apply them towards enterprise-level data solutions

o Capable of working with a global team and thriving in a team development environment. Advanced problem-solving skills and the ability to deal with real world business issues

• Come up with UI and UX strategies based on our target goals.
• Create and maintain digital assets, such as interface design files, wireframes, and interactive mockups using ( design and prototyping tools: e.g., Sketch and InVision).
• Design, build and maintain highly reusable JavaScript, HTML, and CSS code.

Responsibilities:

• Must be able to write quality code and build secure, highly available systems.
• Assemble large, complex datasets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing datadelivery, re-designing infrastructure for greater scalability, etc with the guidance.
• Create datatools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Monitoring performance and advising any necessary infrastructure changes.
• Defining dataretention policies.
• Implementing the ETL process and optimal data pipeline architecture
• Build analytics tools that utilize the datapipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Create design documents that describe the functionality, capacity, architecture, and process.
• Develop, test, and implement datasolutions based on finalized design documents.
• Work with dataand analytics experts to strive for greater functionality in our data
• Proactively identify potential production issues and recommend and implement solutions

Skillsets:

• Good understanding of optimal extraction, transformation, and loading of datafrom a wide variety of data sources using SQL and AWS ‘big data’ technologies.
• Proficient understanding of distributed computing principles
• Experience in working with batch processing/ real-time systems using various open-source technologies like NoSQL, Spark, Pig, Hive, Apache Airflow.
• Implemented complex projects dealing with the considerable datasize (PB).
• Optimization techniques (performance, scalability, monitoring, etc.)
• Experience with integration of datafrom multiple data sources
• Experience with NoSQL databases, such as HBase, Cassandra, MongoDB, etc.,
• Knowledge of various ETL techniques and frameworks, such as Flume
• Experience with various messaging systems, such as Kafka or RabbitMQ
• Good understanding of Lambda Architecture, along with its advantages and drawbacks
• Creation of DAGs for dataengineering
• Expert at Python /Scala programming, especially for dataengineering/ ETL purposes