ETL, SSIS with P&C Developer
Key Responsibilities
Serve as a data strategy advisor and technical lead for the clients data initiatives
Establish and enforce best practices in data engineering data quality, and data governance
Lead the design and development of enterprise data pipelines using SSIS and other ETL tools
Collaborate with business stakeholders to understand requirements and translate them into scalable data solutions.
Architect and implement data models that support analytical, operational, and reporting needs.
Perform advanced SQL development and data analysis to uncover actionable insights.
Develop and guide the creation of impactful Power BI dashboards and reports.
Conduct data reviews, audits, and performance tuning of databases and pipelines.
Mentor junior data professionals and contribute to upskilling internal teams.
Stay current with data engineering trends and identify opportunities for innovation.
Required Qualifications
7-10 years of experience in data engineering, business intelligence, or data consulting roles.
Expertise in SSIS, SQL Server, and enterprise ETL development.
Strong experience in data modeling, data warehousing, and performance tuning.
Hands-on skills in Power BI, including DAX, Power Query, and visual storytelling.
Familiarity with Store Props or similar insurance data structures.
Deep understanding of P&C insurance business processes and data flows.
Proven ability to advise, influence, and lead clients in data strategy and implementation.
Excellent communication and stakeholder management skills.
Must be local to Davenport, Iowa, or willing to relocate and work on site