Hamilton Company

Business Intelligence Analyst

Hamilton Company

full-time

Posted on:

Location Type: Hybrid

Location: London • United Kingdom

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzureSQL

About the role

  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLADFAzure Analysis Servicesdata processing automationdata qualitydata warehousingdata governancedata visualizationDAXdata modeling
Soft Skills
problem-solvingcommunicationcollaborationworkload management
Certifications
Microsoft Certified: Azure Database Administrator Associate