What are the responsibilities and job description for the Data Procurement Specialist position at MAPFRE Insurance?
Data Procurement Specialist
Location: Webster MA | Full-Time | Data Strategy & Growth
Data Procurement Specialist
As a Data Procurement Specialist, you will play a key role in supporting automated reporting and analytics by preparing curated data for reporting. This will include creating and maintaining tables with optimized code, validating data quality, and ensuring dashboards and reporting solutions are accurate, scalable, and aligned with business needs.
This role requires strong technical expertise in SQL and Snowflake, along with familiarity with automation tools such as Bitbucket, Jenkins, and Airflow. You’ll collaborate with internal stakeholders to understand data requirements, communicate complex data results in a clear, actionable way, and help design scalable reporting frameworks that enable consistency across the organization.
Key Responsibilities
- Build and maintain intermediate tables in Snowflake to support dashboards and automated reporting.
- Develop and optimize SQL queries for data transformation, validation, and performance tuning.
- Ensure data consistency, accuracy, and compliance with governance standards.
- Collaborate with the data visualization specialists and business stakeholders to align data structures with reporting needs.
- Communicate complex data results in a simple, actionable manner to both technical and non-technical audiences.
- Contribute to the design and implementation of scalable data reporting frameworks and BI tools that enable consistency and scalability.
- Support automation of validation and monitoring processes using Bitbucket, Jenkins, and Airflow.
- Document data models and transformation logic for transparency and maintainability.
What You Bring
You’re a curious, collaborative, and technically skilled professional who thrives at the intersection of data and strategy.
Must-haves:
- 4-6 years of experience in Power BI, analytics
- Bachelor’s degree in Business, Data Analytics, or related field (MBA a plus).
- Proficiency in business intelligence tools (e.g.,Power BI, Excel).
- Working knowledge of SQL and Python for data querying, analysis, visualization and automation.
- Skilled in developing automated workflows and scripts to streamline data processing and reporting.
- Experience with cloud platforms and data warehouse technologies.
- Strong communication, presentation, and stakeholder management skills.
- Ability to work independently and collaboratively in a fast-paced environment.
Bonus points for:
- Experience in insurance, underwriting, claims, or actuarial domains.
- Strategic planning and market intelligence expertise.
- A track record of developing automated reporting and analytics solutions.
Why You’ll Love It Here
- Be a strategic influencer in a data-first organization.
- Work on high-impact projects that shape business growth and innovation.
- Thrive in a culture that values collaboration, transparency, and continuous learning.
- Clear career path to BI Advisor and leadership role
Pay Philosophy: The typical starting salary range for this role is determined by several factors including skills, experience, education, certifications, and location. Some roles at MAPFRE are eligible for commission and/or bonus earnings, in addition to salary, calculated based upon factors set forth in the compensation plan for the role.
Salary Range $87k - $130k
Thank you for considering MAPFRE Insurance as part of your career journey.
We're proud to be rated "A" (Excellent) by A.M. Best Company. We offer property and casualty insurance, working with over 3,000 independent agents and brokers in 11 states.
If you require an accommodation for a disability so that you may participate in the selection process, you are encouraged to contact the MAPFRE Insurance Talent Acquisition team at talentacquisition@mapfreusa.com.
We are proud to be an equal opportunity employer.
Salary : $87,000 - $130,000