Lead Developer - SQL/Power BI (5-10 yrs)

Job Description :

Key Responsibilities :

Leadership and Team Management :

- Lead and mentor a team of Power BI and SQL developers, ensuring timely delivery of high-quality solutions.

- Provide guidance on best practices in data visualization, ETL processes, and SQL optimization.

- Collaborate with stakeholders to gather requirements and prioritize tasks effectively.

Power BI Development :

- Design, develop, and maintain complex Power BI dashboards, reports, and data visualizations that meet business needs.

- Implement row-level security (RLS) and other access controls within Power BI to ensure data security.

- Create reusable templates and standards for Power BI reporting to streamline development efforts.

- Integrate Power BI with other tools and platforms, such as Excel, SharePoint, and third-party APIs.

- Timely delivery of live database projects and Advanced power BI skills

SQL Development and Database Management :

- Develop and optimize complex SQL queries, stored procedures, and functions to support reporting and data analysis.

- Design and implement efficient database structures, including tables, views, and indexes,stored procedures, triggers.

- Perform database performance tuning, troubleshooting, and maintenance to ensure optimal performance.

- Ensure data integrity and consistency across all systems and processes.

- To create and perform on SQL servers, handle large volumes of data.

ETL and Data Integration :

- Design and implement robust ETL processes to extract, transform, and load data from various sources into the data warehouse.

- Collaborate with data engineers to integrate multiple data sources into a unified reporting platform.

- Ensure high data quality through validation, cleansing, and transformation processes.

Collaboration and Stakeholder Engagement :

- Work closely with business stakeholders to understand reporting and analytics requirements.

- Present insights and recommendations derived from dashboards and analytics to senior management.

- Provide training and support to end-users to maximize the adoption of Power BI solutions.

Requirements :

Technical Skills :

- Advanced proficiency in Power BI, including DAX, Power Query, and data modeling.

- Strong expertise in SQL programming and database design principles.

- Experience with relational databases such as SQL Server, Oracle, or PostgreSQL.

- Familiarity with ETL tools (e.g., SSIS, Informatica, or Azure Data Factory).

- Knowledge of data warehousing concepts and dimensional modeling.

- Experience with cloud-based platforms like Azure or AWS is a plus.

- Experience with big data technologies

Qualifications :

- Experience in Agile/Scrum methodologies for project management.

- Familiarity with scripting languages such as Python or R for data manipulation.

- Certifications in Power BI, SQL Server, or cloud technologies (e.g., Azure Data Engineer, Microsoft Certified: Power BI Data Analyst).