Power BI Developer, Specialty Consulting

Power BI Developer, Specialty Consulting

At Lockton, we’re passionate about helping our people achieve their ultimate potential. Our people are curious, action-oriented and always striving to make ourselves and those around us better. We’re active listeners working to ensure understanding and problem solvers developing innovative solutions. If you can see yourself delivering excellent service to clients, giving back to our communities and being a part of our caring culture, you belong here.

Secondary locations

Plano

Business unit

Lockton-Dunning Series

Schedule

Full-time

Job type

Standard

Workplace

Hybrid

Your Responsibilities

Due to our success and increased business opportunities, we are looking for a Power BI Developer to provide technical and analytical support within the Lockton Specialty Practices. The ideal candidate will demonstrate a high level of professionalism, possess the ability to work well in a fast-paced environment, the flexibility to easily adapt to changing priorities and desire to engage in new opportunities to learn.

• Analyze data and support operational activities to provide stakeholders information and insights essential for decision-making and solution development.
• 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 & scripts.
  • Create and run testing processes & 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 the evolving client needs.
• Continuous quality improvement on processes, policies, and reporting to improve efficiency and innovation.

Qualifications

• 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.

Equal Opportunity Statement

Lockton Companies is proud to provide everyone an equal opportunity to grow and advance. We are committed to an inclusive culture and environment where our people, clients and communities are treated with respect and dignity.

About Lockton

Lockton is the largest privately held independent insurance brokerage in the world. Since 1966, our independence has allowed us to serve our clients, take care of our people and give back to our communities. As such, our 10,000+ Associates doing business in over 100 countries are empowered to do what’s right every day.

At Lockton, we believe in the power of all people. You belong at Lockton.

How We Will Support You

At Lockton, we empower you to be true to yourself in all that you do. Your success is our success, and we provide opportunities to help you grow and create a rewarding career path, however you envision it.