What are the responsibilities and job description for the Senior BI Developer position at Lockton?
Your Responsibilities
Product Development & Enhancement: Lead the end-to-end development of advanced BI products using Power BI. Go beyond standard dashboards to create professional, user-friendly applications with robust features. This includes integrating new data sources, creating complex UI/UX designs, and building interactive, data-driven solutions.
Performance Optimization & Efficiency: Proactively identify and resolve performance bottlenecks in existing and new data models and reports. Utilize DAX, M, and other Power BI tools to optimize model efficiency and ensure quick load times, providing users with a fast and seamless experience.
Operational Support & Incident Management: Serve as the primary technical contact for all operational issues related to our BI products. Triage incoming requests for report or application failures, identify the root cause, and coordinate with the appropriate teams (e.g., data engineering, IT, or business stakeholders) to ensure timely resolution.
Technical Troubleshooting: Diagnose and resolve technical issues within our BI ecosystem. This includes troubleshooting data refresh failures, gateway errors, user access problems, and connectivity issues.
Power BI Governance & Administration: Manage and maintain the security and access of our Power BI environment. Implement and enforce governance best practices, manage user permissions, and ensure the integrity and security of our data products.
Advanced Integration: Design and develop solutions that integrate Power BI with other platforms, such as Databricks. This includes working with the engineering team to build custom applications that allow users to interact with Databricks Genie and Power BI together, trigger notebook runs, or refresh data from within a Power BI report.
Mentorship & Collaboration: Work closely with the existing BI team, providing technical guidance and sharing best practices in product development and operational support. Collaborate with business analysts to understand requirements and translate them into robust technical solutions.
Qualifications
Product Development & Enhancement: Lead the end-to-end development of advanced BI products using Power BI. Go beyond standard dashboards to create professional, user-friendly applications with robust features. This includes integrating new data sources, creating complex UI/UX designs, and building interactive, data-driven solutions.
Performance Optimization & Efficiency: Proactively identify and resolve performance bottlenecks in existing and new data models and reports. Utilize DAX, M, and other Power BI tools to optimize model efficiency and ensure quick load times, providing users with a fast and seamless experience.
Operational Support & Incident Management: Serve as the primary technical contact for all operational issues related to our BI products. Triage incoming requests for report or application failures, identify the root cause, and coordinate with the appropriate teams (e.g., data engineering, IT, or business stakeholders) to ensure timely resolution.
Technical Troubleshooting: Diagnose and resolve technical issues within our BI ecosystem. This includes troubleshooting data refresh failures, gateway errors, user access problems, and connectivity issues.
Power BI Governance & Administration: Manage and maintain the security and access of our Power BI environment. Implement and enforce governance best practices, manage user permissions, and ensure the integrity and security of our data products.
Advanced Integration: Design and develop solutions that integrate Power BI with other platforms, such as Databricks. This includes working with the engineering team to build custom applications that allow users to interact with Databricks Genie and Power BI together, trigger notebook runs, or refresh data from within a Power BI report.
Mentorship & Collaboration: Work closely with the existing BI team, providing technical guidance and sharing best practices in product development and operational support. Collaborate with business analysts to understand requirements and translate them into robust technical solutions.
Qualifications
- Proven experience as a BI Developer with a focus on building production-level data products, not just one-off dashboards.
- Deep expertise in Power BI Desktop, Power BI Service, and Power BI Administration.
- Strong proficiency in DAX and Power Query (M) for data modeling and optimization.
- Strong data modeling skills, with a deep understanding of dimensional modeling (star and snowflake schemas) and their practical application in a BI environment.
- Experience with Power BI APIs and tools for automation and integration (e.g., Power Automate).
- Demonstrated ability to troubleshoot and resolve complex technical issues in a BI environment.
- Strong proficiency in SQL.
- Familiarity with data governance and security best practices.
- 5 years of BI development experience.
- Bachelor's degree in a relevant field.
- Experience with Databricks and its integration with Power BI.
- Demonstrated interest or experience in leveraging AI tools for self-service analytics, empowering business users to query data using natural language.
- Experience with other BI tools or platforms is a plus.
