11 Nov
|
Anderson Global
|
Ahmedabad
11 Nov
Anderson Global
Ahmedabad
Job Purpose
To design, develop, and maintain enterprise-level business intelligence (BI) solutions that leverage Power BI, SQL, and Azure. This role includes integrating Salesforce data, optimizing performance, and providing actionable insights to drive data-driven decision-making.
Responsibilities
Dashboard and Report Development
Design and develop advanced Power BI dashboards, DAX calculations, reports, and data models.
Ensure reports provide critical business insights and meet user requirements.
SQL and Data Optimization
Write and optimize complex SQL queries, stored procedures, and views for data extraction and transformation.
Implement performance tuning to enhance query efficiency.
Azure Data Services
Utilize Azure Data Services (Azure SQL, Azure Data Factory) to build and maintain cloud-based BI solutions.
Automate data refresh schedules and ETL pipelines using Azure tools and Power BI Service.
Salesforce Integration
Integrate Salesforce data and reports into Power BI for comprehensive analytics.
Ensure data consistency and accuracy when merging multiple data sources.
Security and Governance
Develop and implement row-level security (RLS), governance frameworks, and performance optimization in Power BI.
Maintain data security and enforce best practices for data governance.
Collaboration and Business Requirements
Collaborate with cross-functional teams to gather business requirements and translate them into scalable BI solutions.
Provide technical leadership, mentorship, and guidance to junior developers and business users.
Continuous Improvement
Stay up to date with the latest Power BI, Azure, and analytics trends.
Continuously enhance reporting solutions by incorporating best practices and new technologies.
Competencies
Integrity
Acts as a role model for ethical behavior
Resolves complex ethical dilemmas.
Provides guidance on ethical issues to colleagues.
Accountability
Oversees team projects and ensures accountability at all levels.
Takes responsibility for team performance and outcomes.
Coaches others in taking responsibility for their work.
Customer Focused
Builds and maintains strong relationships with key customers.
Anticipates customer needs and offers proactive solutions.
Leads initiatives to improve customer service practices.
Time Management / Organization
Plans and organizes team projects and resources.
Implements effective time management strategies for the team.
Anticipates and addresses potential scheduling conflicts.
Communication
Communicates complex ideas clearly and persuasively.
Manages difficult conversations with tact and diplomacy.
Coaches others on effective communication techniques.
Teamwork
Leads team projects and fosters a collaborative workplace.
Mentors and supports team members to enhance performance.
Manages significant team conflicts effectively.
Self-Motivated
Inspires and motivates others to achieve high performance
Takes on challenging projects and drives them to completion.
Leads initiatives to improve team or department performance.
Requirements
Required Qualifications:
- 4+ years of experience in Power BI development
- Strong hands-on experience with:
- Power BI Desktop & Service
- Advanced DAX and performance tuning
- Data modeling (star schema, relationships)
- Experience working with Salesforce data:
- Standard & custom objects
- Reports and data extraction
- Strong SQL skills (joins, views, stored procedures)
- Experience with Azure data platform:
- Azure Data Factory (ETL pipelines)
- Azure SQL / Synapse
- Experience building end-to-end BI solutions from source to visualization
- Troubleshoot and resolve data and reporting issues.
Preferred Qualifications
- Experience integrating multiple data sources (e.g., Salesforce, Excel, APIs, third-party tools)
- Familiarity with Microsoft Fabric or modern data platforms
- Experience with Power Platform (Power Apps, Power Automate)
- Basic knowledge of Python / PySpark
📌 Power BI Developer - ABA (Ahmedabad)
🏢 Anderson Global
📍 Ahmedabad