Senior BI & ETL Developer

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.

Responsibilities

• Manage and drive a team of Data Analysts and Sr. Data Analysts to provide logistics and supply chain solutions.
• Conduct meetings with Clients to gather the requirements and understand the scope.
• Conduct meetings with internal stake holders to walk them through the solution and handover the analysis.
• Define business problems, identify solutions, provide analysis and insights from the client's data.
• 5 Conduct scheduled progress reviews on all projects and interact with onsite team daily.
• Ensure solutions are delivered error free and submitted on time.
• Implement ETL processes using Pentaho Data Integration (Pentaho ETL)Design and implement data models in Hadoop.
• Provide end-user training and technical assistance to maximize utilization of tools.
• Deliver technical guidance to team, including hands-on development as necessary; oversee standards, change controls and documentation library for training and reuse.

Requirements

• Bachelor's degree in Engineering.
• 16+ years of experience in Supply Chain and logistics or related industry and Analytics experience.
• 3 years of experience in team handling(8+People) and interacting with the executive leadership teams.
• Strong project and time management skills with ability to multitask and prioritize workload.
• Solid expertise with MS Excel, SQL, any visualization tools like Tableau/Power BI, any ETL tools.
• Proficiency in Hadoop / Hive.
• Experience Pentaho ETL, Pentaho Visualization API, Tableau.
• Hands on experience of working with Big data sets (Data sets with millions of records).
• Strong technical and Management experience.

Desired Skills and Experience

• NET,ASP.NET

Responsibilities and Duties

Develop high-quality software design and architecture.

Achieve the timeline with quality delivery of assigned tasks.

Able to do technical analysis and code review.

Able to troubleshoot internal & production bugs.

Coordinate and support to project co-ordinator/project manager.

Development coding standards are achieved.

Work with internal teams to understand and analyse their needs and to ensure that proposed solution caters to same.

Adopt new technology in quick time.

Implement Unit tests and Functional tests to ascertain highest quality of deliverables.

Identify, prioritize and execute tasks in the software development life cycle.

Understand business needs and know how to implement needs in system to meet business needs.

Able to create the technical documents.

Able to leading team members and planning of team’s task.

Design, develop, modify, implement, and support software components anywhere in the software stack.

Work in close partnership with cross-functional teams and management.

Requirements

Having knowledge of ASP .Net / .net core, Web API, Micro Services, JavaScript, jQuery, Bootstrap, Flutter.

Having good Release management, Cloud Management & Data base management knowledge

Having fluency in Agile methodology

Having knowledge of Power BI / Tablue will be added advantage

Soft skills – Manager level skill

Critical thinker and creative mindset and the ability to approach a problem creatively.

Ability to provide in-depth evaluation and analysis of unique complex technological issues.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

As a Software Engineer at Quince, you'll be responsible for designing and building scalable infrastructure and build applications to solve some very interesting problems in the logistics and finance tech space.

Responsibilities:

• Design and architect solutions on the cloud for various business problems with workflow efficiency and scale in mind.
• Be on the forefront with the business team to learn, understand, identify and translate function requirements into technical opportunities.
• End-to-end ownership - from scoping the requirements to the final delivery of the solution with keen eye to details and quality.
• Build and improve logistics components for this innovative M2C supply-chain model.
• Build and maintain scalable ETL data pipelines.

Requirements:

• Bachelors/Masters/PhD in Computer Science or closely related subject.
• 1-5 years of experience in building software solutions.
• Good at data structures and their practical applications.
• Proficiency in Kotlin, Java, Python.
• Experience in deploying and maintaining applications on cloud platforms (Ex: AWS, Google cloud).
• Proficiency with SQL and databases - relational and/or nosql (Snowflakes, AWS RedShift, etc).
• Experience with messaging middleware such as Kafka is good to have.

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)