Senior Data Modeler

About Us: AmpsTek – a global technology leader since 2013 – is transforming how businesses approach technology and staffing solutions. Founded by seasoned technology leaders across the UK, Europe, APAC, North America, and LATAM, and with registered offices in 30+ countries, we deliver exceptional service, scalable solutions, and measurable impact. With a portfolio of 200+ clients and millions of users across web and mobile platforms, we empower businesses to innovate, grow, and succeed. Join our team and be part of a dynamic, growth-oriented organization that values talent, creativity, and results. Role Title: Senior Data Modeler Location : London, UK (Hybrid 3 days onsite/week) Contract (InsideIR35) Minimum years of experience: 8-10 years Mandatory Skills: • 5+ years of experience in data modeling and database design. • Strong expertise in SQL Server and Snowflake data modeling. • Proficiency in SQL for data analysis and validation. • Experience in data architecture principles and data governance. • Solid understanding of Insurance domain concepts (Specialized Insurance, London Market, Regulatory Data). • Excellent communication and stakeholder management skills. Desired Skills: • Experience with ETL tools and data integration processes. • Familiarity with data warehousing concepts and cloud data platforms. • Exposure to Fivetran, SSIS, or Snowflake advanced features. Job Description: • Experienced Data Modeler who can analyze and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. • Work closely with multiple Business Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards. • Responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. You will analyze existing data models built on SQL Server and guide the development of optimized structures on Snowflake, ensuring alignment with business requirements and enterprise standards. • Collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. • Contribute to architecture reviews, mentor junior data modelers, and support data governance initiatives. • documentation, knowledge sharing, and capability building across the data modelling practice.