Lead Data Analyst

Job Overview An organization is seeking a Senior Data Analyst to lead end-to-end data warehouse initiatives within a complex, enterprise data environment. This role is critical in driving data solutions across core business domains, ensuring high-quality data delivery from initial analysis through post-implementation support. Candidates who demonstrate deep expertise in data warehousing, strong domain knowledge, and the ability to independently lead large-scale projects will be prioritized. Must Haves 10+ years of experience in data analysis, data warehousing, or related technical roles Strong expertise in SQL and relational databases (e.g., DB2, SQL Server, Oracle, Snowflake) Proven experience working within structured SDLC frameworks, including estimation and planning Advanced data modeling and data mapping experience Hands‑on experience with ETL processes and tools such as Informatica or similar platforms Solid understanding of cloud‑based data environments, particularly AWS Deep knowledge of Property & Casualty (P&C) insurance domains, including policy and claims lifecycle Strong testing experience across unit, integration, and user acceptance phases Demonstrated ability to manage projects independently from analysis through delivery What the Client Needs You to Do You will serve as a senior technical leader responsible for delivering high‑impact data warehouse solutions that support critical business functions. This includes translating business needs into technical specifications, guiding development efforts, and ensuring data accuracy and reliability across systems. You will collaborate closely with both technical teams and business stakeholders while also mentoring peers and driving continuous improvement across data processes. Key Responsibilities Lead full lifecycle delivery of data warehouse initiatives, from requirements analysis through production support Analyze and refine business requirements to ensure clear, actionable technical direction Develop detailed system and technical specification documents, including data transformation logic Design and maintain robust data models aligned with enterprise data architecture standards Coordinate with development teams to ensure proper implementation of data solutions Execute and support comprehensive testing efforts, including unit, integration, and performance testing Monitor production data environments, troubleshoot issues, and ensure data integrity Provide ongoing support to downstream applications and business users relying on data warehouse outputs Optimize system performance through tuning and process improvements Build strong partnerships with stakeholders across business and IT teams Mentor junior team members and provide guidance on best practices in data analysis and warehousing Proactively identify gaps, inefficiencies, and opportunities for enhancement within data systems Manage multiple priorities effectively while maintaining high-quality deliverables W2 employees of Overture Partners who work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), 401(k) starting on day one, a variety of voluntary benefits including life and disability insurance, and sick time if required by law in the worked‑in state/locality. #J-18808-Ljbffr