BI Analyst executing and managing projects to ensure data gathering, validation, and actionable insights. Skillful in BI tools and advanced Excel with a focus on data - driven decision - making.
About the role
- Business Intelligence Analyst at Hamilton involved in designing and maintaining business intelligence solutions. Collaborating with data engineering to support strategic planning and performance monitoring.
Responsibilities
- Involved in designing, developing and maintaining business intelligence solutions (dashboards, reports)
- Gather business requirements from users
- Work closely with the Group technical data engineering team
- Translate business needs into technical specs
- Support building data warehouses
- Optimize queries, ensuring completeness of data
- Collaborate with analysts, data engineers, and stakeholders
- Develop, test, and document complex pipelines
- Design and implement database structures
- Develop, test, and deploy SQL queries and stored procedures
- Optimize and tune SQL queries for performance
- Use data models to represent business processes
- Ensure the security model based on privacy requirements
- Participate in reviews of work to ensure developments are standardised, reliable, and maintainable
- Run / participate in Business Intelligence monthly working group for data users
- Communicate well with stakeholders at all levels
- Efficiently manage workload priorities based on the needs of multiple business units
Requirements
- Experience in SQL, ADF and Azure Analysis Services
- Experience in using all Microsoft applications
- Familiarity with software management tools such as DevOps, Azure, and JIRA for project maintenance and user story documentation
- Experience with three or more of the following: data processing automation, data quality, data warehousing, data governance, business intelligence, data visualization, data privacy
- Experience of full cycle development, designing, coding, testing, and correcting complex SQL models and scripts
- Knowledge of data analysis, data modelling and quality assurance techniques
- Knowledge of version control systems (e.g., Git)
- Certifications in relevant database technologies (e.g., Microsoft Certified: Azure Database Administrator Associate)
- Previous experience of working in an insurance environment
- Strong Power BI experience to create custom dashboards and visualisations
- Strong experience with DAX to develop complex measures
- Strong experience working with Semantic models
- Excellent problem-solving and communication skills.
Benefits
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Business Development Analyst utilizing data analytics to drive strategic initiatives for MAPFRE. Conducting market research, analysis, and supporting business strategy development.
Sr. Business Intelligence Analyst responsible for analytics and performance insights driving McKesson’s CXO Digital Transformation. Collaborating across teams to enhance operational excellence and customer experience.
Data Analyst working with Growth Managers and Business Operations team at adjoe. Focused on data analysis, reporting migration, and optimizing data processing pipelines.
Staff Engineer focused on Finance Data BI solutions at GEICO, partnering with Finance and Technology teams to enhance data management. Experienced in ERP, Finance Systems, and data warehousing.
Senior BI Consultant focusing on both technical and business challenges at TechSeed. Responsible for delivering end - to - end solutions within connected systems and technologies.
Senior BI Consultant tackling technical and business challenges at TechSeed. Responsible for developing end - to - end connected solutions in data - driven environments.
Senior BI Engineer at TMA Systems building analytics and data visualization solutions. Collaborating with teams to create dashboards, reports, and data models for customer insights.
Senior BI Engineer building scalable analytics and data visualization solutions for TMA Systems. Collaborating with teams to create dashboards, reports, and drive insights for customers.
Business Intelligence Analyst developing and maintaining reporting solutions using Power BI and SQL for effective business decision - making. Partnering with Data Solutions Architect to implement standardized data models and reporting frameworks.