Data Analyst amp Engineer - Lockton Inc

At Lockton were 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. Were 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.

As a data analyst and data engineer you will work closely with the Head of Digital to develop and implement data strategy for the region. You will be responsible for creating and managing data pipelines developing data visualization setting up and managing data infrastructure and data flow. You will collaborate with multiple stakeholders including function owners & business to support the organizations decisionmaking process by presenting datadriven insights.

Your Responsibilities

Data Analysis:

• Data Collection and Analysis: Gather data from various sources process and analyze it to extract actionable insights.
• Data Cleaning: Ensure data accuracy and integrity by cleaning and preparing datasets for analysis.
• Collaboration: Work closely with crossfunctional teams including marketing sales and business to understand data requirements and deliver insights for internal and external stakeholders.
• Communication: Present findings and insights to stakeholders translating complex data into understandable and impactful business terms

Data Visualization & BI Tools:

• Design and Development: Develop and deploy Tableau & BI tools and reporting systems ensuring they meet user needs.
• Data Integration: Develop and manage ETL (Extract Transform Load) processes to ensure data is collected accurately and efficiently from various sources.
• Performance Optimization: Troubleshoot and optimize BI tools and systems to enhance their performance and scalability.
• Collaboration: Work closely with stakeholders business & technology to integrate system improve data flow & understand business needs.

Data Engineering:

• Database Management: Perform database design development performance tuning and maintenance to ensure efficient data storage and retrieval processes.
• Data Integration: Integrate data from various source systems into the data warehouse ensuring accuracy consistency and quality of data.
• ETL Development: Develop test and maintain ETL scripts and processes using ETL tools to ensure data is accurately collected transformed and loaded into data warehouse systems.
• Data Infrastructure Management: Develop and manage the data infrastructure including data lakes data warehouses and data processing systems to support analytics and business intelligence needs.
• Data Security and Compliance: Implement data security measures and ensure compliance with data governance and privacy regulations.

Technical Skills

• Analytical Tools Proficiency: Strong skills in analytical tools such as Excel SQL Python or R for data manipulation and analysis.
• Data Visualization/ BI Tool: Experience with data visualization tools like Tableau or Power BI to create insightful visualizations.
• Database Proficiency: Proficiency in SQL and experience with database management systems for querying and managing data.
• Programming Languages: Strong proficiency in programming languages such as Python Java or Scala for data processing and integration
• ETL Tools: Experience with ETL tools such as Informatica Talend SSIS or similar for data integration processes.
• Cloud Platforms: Familiarity with cloud platforms such as AWS Azure or Google Cloud for deploying and managing data solutions.

Experience & Preferred Qualifications

• Proven experience as a data analyst and engineer or similar role for 10 years.
• Exposure to insurance and the reinsurance industry is a plus.
• Minimum of an undergrad degree in Data science Computer Science Engineering or a related field.
• Familiarity with UX/UI design principles.

Soft Skills:

• Excellent communication and interpersonal skills capable of building strong relationships with stakeholders and team members.
• Strong problemsolving and analytical skills.
• High attention to detail and the ability to manage multiple tasks simultaneously.
• Ability to work under pressure and adapt to changing priorities.

#LIAB67