FAQs
What is the main responsibility of a Business Intelligence Analyst at Lockton Companies?
The main responsibility of a Business Intelligence Analyst at Lockton Companies is to assist management and other stakeholders in understanding the data collected by developing accurate and timely reports, managing corporate data, and consulting with users on reporting needs.
What tools should candidates be familiar with for this position?
Candidates should be familiar with Microsoft Business Intelligence tools such as SQL, SSAS, SSIS, SSRS, Azure Data products, Excel, Power BI, and DAX.
What are the expected qualifications for a Business Intelligence Analyst?
The expected qualifications include a Bachelor’s degree, preferably in Computer Science, 1-3 years of experience in a Business Intelligence Analysis role, strong analytical and research skills, knowledge of Visual Basic, and proficiency in MS Excel and Microsoft’s Power BI Suite.
Is insurance experience necessary for this role?
No, insurance experience is helpful but not required for this role.
What type of communication skills are required for this position?
Strong written and oral communication skills are required to effectively communicate with both technical and non-technical stakeholders.
What is the importance of data quality for this role?
Data quality is crucial as the Business Intelligence Analyst must proactively identify data quality issues and recommend integrity checks, ensuring that the reports and analytics provided meet the business requirements accurately.
What should candidates expect regarding collaboration in this role?
Candidates should expect to proactively collaborate with stakeholders at all levels of the company to gather requirements and document needs for business intelligence solutions.
Is experience in writing SQL queries necessary?
Yes, the ability to read and write SQL query statements is necessary for this role as it involves validating new features and troubleshooting data issues.
What kinds of support will the Business Intelligence Analyst provide post-release of BI solutions?
The Business Intelligence Analyst will provide ongoing analytical support for BI solutions released to the business and assist in communicating new features and upgrades to users.
What level of detail is expected in data analysis for this position?
The Business Intelligence Analyst is expected to perform detailed data analysis to determine the structure, content, and quality of data through examination of source system data and data samples.