Business Data Analyst

We are looking for a Business Data Analyst who supports operations and conducts data analytics projects to provide information and insights to stakeholders for decision-making or solution development . The ideal candidate will be motivated, results-driven, flexible, detail-oriented, and collaborative. Our fast-paced environment has a supportive culture which values autonomy, initiative, and personal accountability. The Business Data Analyst will have opportunities to expand their skills and become a critical member of the Global Analytics Data & Reporting team.

Position Responsibilities

• Review, analyze, and evaluate data systems and business needs to create system solutions which support overall business strategies.
• Collaborate with stakeholders to understand their needs, objectives, and requirements.
• Develop business requirements for multiple business functions, understand how those functions interact, and what the enterprise solution(s) could do to support those business needs.
• Utilize scripting and querying tools like SQL, Python, or R, data visualization/BI tools, data modeling to produce reports, data files, and dashboards.
• Interact with project team and management to identify and document benefits, costs, and risks associated with solution alternatives.
• Help to ensure proper communication, process flow, data quality, reliability, integrity, and security for automated systems as needed.
• Organize formal presentations to Lockton decision-makers.
• Work with transactional and policy datasets to aggregate data at various levels.
• Participate and own internal definitions applied to data by using logic and code.
• Become a subject matter expert on data transformations and lineage.
• Implement data standards and deploy automation tools to extract, synthesize, and validate data from different sources and transform data into usable metrics.
• Construct data sets, monitor data quality, troubleshoot and resolve database issues to ensure data integrity.

Position Qualifications

• Bachelor's or related degree is required with a preference for majors in Mathematics, Statistics, Finance, Computer Science, or Information Systems.
• Typically requires 4-7 years of related experience.
• 5+ years of experience of SQL programming language.
• Familiar with relational database and distributed application concepts.
• Strong analytical skills.
• Experience with Azure's services is preferred (Data Factory, ADLS, Databricks, Synapse, etc.).
• Some experience using R and/or Python.
• Understand data sources, processes, formulas, and output.
• Ability to understand data integrity and correctness.
• Proven ability to manage multiple projects simultaneously.
• Actively seeks solutions to problems without supervision.
• Aptitude to develop unique, creative, and efficient work products.
• Excellent written and oral communication skills.
• Assumes ownership for individual projects.
• Beneficial knowledge: BI analytics/reporting tools, dashboard design/configuration, data mining, data quality, data visualization, forecasting, predictive analytics and modeling, scripting languages, statistical analysis, trend analysis, data standards, statistical software, and general data analysis software.
• Work is generally independent and collaborative in nature.
• Contribute to moderately complex aspects of a project.
• Experience in articulating and documenting user requirements.
• Experience within the insurance and brokerage industry is a plus.
• Experience with accounting/billing systems is a plus.
• Ability to express complex technical concepts effectively, both verbally and written.
• Ability to complete continuing education requirements as needed.