Lead Data Analyst

RESOURCESOFT, INC.; Port Reading (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

Resourcesoft, Inc. is seeking a seasoned data analyst with 5–8 years of experience in data analysis and enterprise software development lifecycles. The role requires strong SQL skills (DB2, SQL Server), P&C insurance domain knowledge, and experience with Snowflake.

You will lead cross-functional teams across data mapping, transformations, testing, and reporting initiatives. The candidate will drive end-to-end data remediation for a new enterprise policy administration system, develop complex

Qualifications

• 5–8 years of experience in data analysis and enterprise software development lifecycles.
• Proficiency in SQL query development and relational databases including DB2 and SQL Server.
• Experience in P&C insurance and policy administration systems.
• Experience with cloud data warehousing technologies including Snowflake and defect tracking tools.
• Experience in enterprise data mapping, structured systems analysis, and data transformation specifications.
• Experience with executing comprehensive unit, integration, performance, and user acceptance testing.
• Excellent verbal and written communication skills to lead cross-functional technical teams.

Responsibilities

• Lead end-to-end implementation and data remediation for a new enterprise policy administration system.
• Develop complex SQL queries to extract data, troubleshoot defects, and support testing.
• Construct detailed functional specifications, system use cases, and transformation mapping documents.
• Orchestrate all phases of the SDLC to deliver data warehouse and compliance reporting projects.
• Formulate test plans and execute robust unit, integration, and performance testing.
• Administer defect tracking tools to log and drive data anomalies to resolution.
• Analyze business requirements to provide accurate technical work effort estimates to IT managers.

Skills

Data analysis

SQL development

P&C insurance domain

Data mapping

Data transformation

Testing (unit/integration/UA)

Cross-functional leadership

Tools

DB2

SQL Server

Snowflake

Defect tracking tools

Job description

Requirements

• 5 to 8 years of experience in data analysis and enterprise software development lifecycles.
• Proficiency in SQL query development and relational databases including DB2 and SQL Server.
• Experience in Property and Casualty (P&C) insurance and policy administration systems.
• Experience with cloud data warehousing technologies including Snowflake and defect tracking tools.
• Experience in enterprise data mapping, structured systems analysis, and data transformation specifications.
• Experience with executing comprehensive unit, integration, performance, and user acceptance testing.
• Excellent verbal and written communication skills to lead cross-functional technical teams.

Responsibilities

• Lead the end-to-end implementation and data remediation for a brand-new enterprise policy administration system.
• Develop complex SQL queries to extract data, troubleshoot defects, and support development testing efforts.
• Construct detailed functional specifications, system use cases, and transformation mapping documents.
• Orchestrate all phases of the SDLC to deliver critical data warehouse and compliance reporting projects.
• Formulate comprehensive test plans and execute robust unit, integration, and performance testing.
• Administer defect tracking tools to log, assign, and drive complex data anomalies to final resolution.
• Analyze business requirements to provide accurate technical work effort estimates to IT project managers.

Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.

Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

For more information about Resourcesoft and our services, please visit our website.