Power BI Developer, Specialty Consulting

Lockton Companies - Plano, TX

Full-time - Mid Level

Plano, TX

Insurance Carriers and Related Activities

About the position

As a Power BI Developer at Lockton, you will play a crucial role in providing technical and analytical support within the Lockton Specialty Practices. This position is designed for individuals who are not only skilled in data analytics but also possess a strong sense of professionalism and adaptability in a fast-paced environment. You will be expected to engage actively with various stakeholders, ensuring that their needs and objectives are met through effective data analysis and reporting. Your primary responsibility will be to analyze data and support operational activities, providing stakeholders with essential information and insights that facilitate decision-making and solution development. In this role, you will serve as the go-to Power BI expert for Lockton's specialty consulting teams. You will be tasked with building Power BI reports and dashboards based on specific business requirements, utilizing complex DAX formulas to create meaningful visualizations. Additionally, you will develop User Acceptance Testing (UAT) guidelines and scripts, create and run testing processes, and ensure sign-off for go-live deployments. Maintaining dashboard security and access will also be a critical part of your responsibilities. Collaboration is key in this position, as you will work closely with stakeholders to understand their needs and objectives. You will employ automation tools to extract, synthesize, and validate data from various sources, converting it into meaningful metrics. Your role will also involve reviewing and implementing standardized data practices, running ad hoc report queries, and integrating data from multiple sources into relevant client reports. Monitoring data quality, performing validation checks, and troubleshooting data-related issues will be essential to maintain data integrity. Furthermore, you will assist in designing enhanced reporting solutions to meet evolving client needs and contribute to continuous quality improvement in processes, policies, and reporting to drive efficiency and innovation.

Responsibilities

• Analyze data and support operational activities to provide stakeholders with essential information and insights for decision-making.
• Serve as a go-to Power BI expert for Lockton specialty consulting teams.
• Build Power BI reports and dashboards based on business requirements, utilizing complex DAX formulas.
• Develop UAT guidelines and scripts.
• Create and run testing processes and sign-off for go-live deployment.
• Maintain dashboard security and access.
• Collaborate closely with stakeholders to understand their needs, objectives, and requirements.
• Employ automation tools to extract, synthesize, and validate data from various sources, converting it into meaningful metrics.
• Review and implement standardized data practices and hand-offs from analysts and data engineering resources.
• Run ad hoc report queries including detailed analysis and insight.
• Integrate data from multiple data sources into relevant client reports.
• Monitor the quality of data, perform data validation checks on various data sets, troubleshoot data-related issues, and resolve them timely to maintain data integrity.
• Assist with designing enhanced reporting to meet evolving client needs.
• Continuous quality improvement on processes, policies, and reporting to improve efficiency and innovation.

Requirements

• Bachelor's degree in Business, Computer Science, Data Science, Mathematics, Statistics, Finance, Economics, or related field.
• Minimum of 2+ years of relevant experience with Power BI required (DAX measures/queries, data modeling, star schema, row level security).
• Minimum of 2+ years of experience with Power Query (M), Power Automate required.
• Minimum of 2+ years of experience with Excel required (VBA not required but helpful).
• Microsoft Power BI Data Analyst PL-300 Certification or equivalent knowledge highly preferred.
• Effective ETL and data manipulation skills.
• Alteryx Designer Core Certification strongly preferred.
• Experience with scripting and querying tools like Python, R or SQL, statistical methods, and data modeling a plus.
• Data analysis experience in a healthcare brokerage environment or insurance carrier.
• Strong attention to detail.
• Excellent analytical, organizational, and communication skills.
• Excellent computer skills including word processing and spreadsheet expertise.
• Proven critical thinking and problem-solving skills.
• Ability to work well in a fast-paced and team-based environment.
• Experience manipulating and analyzing large data sets.
• Handles confidential information in the best interest of both client and company.
• Legal right to work in the United States.

Nice-to-haves

• Experience with scripting and querying tools like Python, R or SQL.
• Statistical methods and data modeling experience.
• Alteryx Designer Core Certification.