Technical Sr. Data Analyst

TechDigital Group; Providence (RI); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology solutions company in Rhode Island is seeking an experienced Technical Data Sr. Analyst with deep expertise in Snowflake, Matillion, and DataStage. The role involves analyzing existing data processes, preparing data mapping documents, and collaborating with data architects to implement data integration solutions. The ideal candidate should have 12+ years of experience, particularly in the insurance domain, and a strong understanding of HIPAA compliance. This position offers a chance to mentor junior analysts and stay updated on emerging technologies.

Qualifications

• 12+ years of experience as a Technical Data Sr. Analyst.
• 3-5 years in insurance domain required.
• Deep expertise in SQL/data analysis.

Responsibilities

• Analyze existing DataStage jobs and create mapping documents.
• Utilize Snowflake, Matillion, and DataStage for data processing.
• Collaborate with Data Architects to design data integration pipelines.

Skills

Snowflake

Matillion

DataStage

SQL

Data analysis

HIPAA compliance

Communication skills

Documentation skills

Job description

Mandatory Skills

• Snowflake, Matillion, and DataStage with 3-5 years of experience working in insurance domain

Required Skills

• Overall, 12+ years of experience as Technical Data Sr. Analyst with least 3-5 years of experience working in insurance domain.
• Excellent understanding and creation of mapping sheets for data integration pipelines.
• Proficiency in Snowflake, Matillion, and DataStage for data processing and integration.
• Ability to work with Data Architects and Leads to support the design and implementation of data processes.
• Deep expertise SQL/data analysis and ensuring data integrity, data security and data quality.
• Ability to prepare technical impact analysis or design work based on requirement and business SMEs input
• Strong understanding of HIPAA compliance requirements for healthcare data security, privacy, and regulatory standards.
• Strong analytical, documentation, and communication skills.

Responsibilities

• As a Technical Data Sr. Analyst, he/she will analyze existing DataStage jobs, work with business SME to create target mapping document as per standard guidelines within healthcare payor domain.
• Utilize Snowflake, Matillion, and DataStage for efficient data processing and integration tasks.
• Prepare technical impact analysis or design work based on requirement and business SMEs input
• Review and validate mapping sheets to align with project requirements and specifications.
• Analyze data to extract insights and support decision-making processes.
• Document data analysis, and transformation processes.
• Collaborate with Data Architects/Data Leads to support the design and implementation of data integration pipelines.
• Build and execute ELT processes for transforming and loading data into target systems.
• Assist in troubleshooting data related issues and ensuring data quality.
• Mentor junior analysts and provide guidance on technical aspects of data analysis.
• Stay updated with emerging technologies and industry trends in data analytics and healthcare informatics.