PowerBI Developer
Job Description
About the client: One of the leading Data Analytics and AI services MNC Company
\nJob Title: Lead Developer - Power BI and SQL
\nExperience: 5-10 years
Job Summary: \nWe are seeking an experienced and results-driven Lead Developer specializing in Power BI and SQL to spearhead our business intelligence initiatives. The ideal candidate will lead a team of developers, design robust data models, create insightful dashboards, and optimize database solutions to support data-driven decision-making across the organization.
\nLead and mentor a team of Power BI and SQL developers, ensuring timely delivery of high-quality solutions.
\nProvide guidance on best practices in data visualization, ETL processes, and SQL optimization.
\nCollaborate with stakeholders to gather requirements and prioritize tasks effectively.
Power BI Development: \nDesign, develop, and maintain complex Power BI dashboards, reports, and data visualizations that meet business needs.
\nImplement row-level security (RLS) and other access controls within Power BI to ensure data security.
\nCreate reusable templates and standards for Power BI reporting to streamline development efforts.
\nIntegrate Power BI with other tools and platforms, such as Excel, SharePoint, and third-party APIs.
\nTimely delivery of live database projects and Advanced power BI skills
SQL Development and Database Management: \nDevelop and optimize complex SQL queries, stored procedures, and functions to support reporting and data analysis.
\nDesign and implement efficient database structures, including tables, views, and indexes,stored procedures,triggers.
\nPerform database performance tuning, troubleshooting, and maintenance to ensure optimal performance.
\nEnsure data integrity and consistency across all systems and processes.
\nTo create and perform on SQL servers, handle large volumes of data.
ETL and Data Integration: \nDesign and implement robust ETL processes to extract, transform, and load data from various sources into the data warehouse.
\nCollaborate with data engineers to integrate multiple data sources into a unified reporting platform.
\nEnsure high data quality through validation, cleansing, and transformation processes.
Collaboration and Stakeholder Engagement: \nWork closely with business stakeholders to understand reporting and analytics requirements.
\nPresent insights and recommendations derived from dashboards and analytics to senior management.
\nProvide training and support to end-users to maximize the adoption of Power BI solutions.
\nAdvanced proficiency in Power BI, including DAX, Power Query, and data modeling.
\nStrong expertise in SQL programming and database design principles.
\nExperience with relational databases such as SQL Server, Oracle, or PostgreSQL.
\nFamiliarity with ETL tools (e.g., SSIS, Informatica, or Azure Data Factory).
\nKnowledge of data warehousing concepts and dimensional modeling.
\nExperience with cloud-based platforms like Azure or AWS is a plus.
\nExperience with big data technologies
Preferred Qualifications: \nExperience in Agile/Scrum methodologies for project management.
\nFamiliarity with scripting languages such as Python or R for data manipulation.
\nCertifications in Power BI, SQL Server, or cloud technologies (e.g., Azure Data Engineer, Microsoft Certified: Power BI Data Analyst).
\nBachelor s or Master s degree in Computer Science, Information Technology, Data Analytics, or a related field.
\nRelevant certifications in Power BI, SQL, or database management are highly desirable.
\n