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.
Show the full description
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.
#25472
