Data Analyst

Job Title: Data Analyst (Contractual) Location: Smithfield, RI Contract Length: 12 + Month

Position Overview:

We are seeking a skilled and highly motivated Data Analyst for a contractual role based in Smithfield, RI. This is an excellent opportunity for professionals who are passionate about working in a fast-paced environment while leveraging strong SQL skills and using Informatica Power Center to help drive key business decisions. The ideal candidate will have experience working in a collaborative team, supporting project managers, benefits consultants, and actuaries. They will also be prepared for a technical interview involving SQL scenarios, so solid expertise is required.

Key Responsibilities:

• Develop, manage, and optimize SQL queries, stored procedures, and functions to extract, transform, and load (ETL) data effectively.
• Use Informatica Power Center to design, build, and maintain ETL workflows and processes.
• Work closely with project managers, benefits consultants, and actuaries to understand business needs and data requirements.
• Collaborate with cross-functional teams to ensure data accuracy, consistency, and integrity throughout all systems and processes.
• Create reports, dashboards, and other data visualizations to support decision-making.
• Analyze complex datasets to identify trends, patterns, and anomalies that support business decisions.
• Document data sources, processes, and SQL queries for transparency and audit purposes.
• Provide clear, concise communication of technical details to non-technical stakeholders.
• Troubleshoot, debug, and optimize SQL queries and ETL processes to ensure efficiency and performance.
• Participate in code reviews and assist in the development of best practices for data management.

Must-Have Skills & Qualifications:

• Strong SQL expertise: Extensive experience writing and optimizing SQL queries, including stored procedures and functions.
• Proven experience with Informatica Power Center for ETL development and data integration.
• Excellent communication skills: Ability to effectively communicate complex technical information to project managers, benefits consultants, and actuaries in a clear and concise manner.
• Comfortable working with large datasets, and familiar with data governance best practices.
• Strong analytical and problem-solving skills.
• Experience with data profiling, validation, and data mapping.
• Ability to thrive in a collaborative team-oriented environment.

Preferred Qualifications:

• Familiarity with other ETL tools or data integration platforms is a plus.
• Knowledge of cloud platforms (AWS, Azure, etc.) and experience working with cloud-based data storage is a plus.
• Experience in a Financial or Banking industry would be advantageous.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Job Title: Data Analyst (Contractual) Location: Smithfield, RI Contract Length: 12 + Month

Position Overview:

We are seeking a skilled and highly motivated Data Analyst for a contractual role based in Smithfield, RI. This is an excellent opportunity for professionals who are passionate about working in a fast-paced environment while leveraging strong SQL skills and using Informatica Power Center to help drive key business decisions. The ideal candidate will have experience working in a collaborative team, supporting project managers, benefits consultants, and actuaries. They will also be prepared for a technical interview involving SQL scenarios, so solid expertise is required.

Key Responsibilities:

• Develop, manage, and optimize SQL queries, stored procedures, and functions to extract, transform, and load (ETL) data effectively.
• Use Informatica Power Center to design, build, and maintain ETL workflows and processes.
• Work closely with project managers, benefits consultants, and actuaries to understand business needs and data requirements.
• Collaborate with cross-functional teams to ensure data accuracy, consistency, and integrity throughout all systems and processes.
• Create reports, dashboards, and other data visualizations to support decision-making.
• Analyze complex datasets to identify trends, patterns, and anomalies that support business decisions.
• Document data sources, processes, and SQL queries for transparency and audit purposes.
• Provide clear, concise communication of technical details to non-technical stakeholders.
• Troubleshoot, debug, and optimize SQL queries and ETL processes to ensure efficiency and performance.
• Participate in code reviews and assist in the development of best practices for data management.

Must-Have Skills & Qualifications:

• Strong SQL expertise: Extensive experience writing and optimizing SQL queries, including stored procedures and functions.
• Proven experience with Informatica Power Center for ETL development and data integration.
• Excellent communication skills: Ability to effectively communicate complex technical information to project managers, benefits consultants, and actuaries in a clear and concise manner.
• Comfortable working with large datasets, and familiar with data governance best practices.
• Strong analytical and problem-solving skills.
• Experience with data profiling, validation, and data mapping.
• Ability to thrive in a collaborative team-oriented environment.

Preferred Qualifications:

• Familiarity with other ETL tools or data integration platforms is a plus.
• Knowledge of cloud platforms (AWS, Azure, etc.) and experience working with cloud-based data storage is a plus.
• Experience in a Financial or Banking industry would be advantageous.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.