Data Analyst - Banking & Finance (Hybrid: 2 Remote)

MassGenics, Inc.; Charlotte, Northern (NC, KY); Hybrid; USD 62,000 - 69,000; Full time

Benefits offered by this job

Medical & pharmacy coverage

Dental/vision insurance

401(k)

Health saving account (HSA)

Flexible spending account (FSA)

Life Insurance

Sick time

Employee Assistance Program (EAP)

Job summary

MassGenics, Inc. is seeking a Data Analyst to support enterprise data enablement and governance in Charlotte, NC. The role focuses on gathering requirements, analyzing data, and delivering scalable data solutions with MSSQL, Alteryx, and SSMS expertise.

Hybrid onsite/remote work is available. The ideal candidate will translate business needs into technical specifications, perform data profiling and cleansing, and collaborate with stakeholders to ensure data quality and reporting accuracy.

Qualifications

• Experience with MSSQL, including query development, optimization, and data analysis.
• Hands-on experience using Alteryx and SQL Server Management Studio (SSMS).
• Knowledge of data profiling, data validation, data cleansing, and transformation techniques.
• Experience defining data sourcing requirements, transformation logic, and database specifications.
• Understanding of metadata management, data lineage, and data governance practices.
• Ability to perform root cause analysis and resolve data quality issues.
• Experience translating business requirements into technical specifications and data solutions.
• Experience supporting data modelling and logical data design activities.

Responsibilities

• Partner with business stakeholders to gather, analyze, and document data use case requirements.
• Perform data analysis, profiling, validation, cleansing, and transformation activities.
• Design and maintain logical data models and data element relationships.
• Write, optimize, and troubleshoot MSSQL queries for data extraction and analysis.
• Define data sourcing logic, transformation requirements, and database specifications.
• Create and maintain documentation related to metadata management, data lineage, and data-sharing processes.
• Assess upstream system changes and evaluate potential impacts on data assets and reporting.
• Conduct root cause analysis for data quality issues and recommend corrective actions.
• Support database enhancement initiatives and logical data design efforts.
• Collaborate with technology, governance, and business teams to align data solutions with established standards and best practices.
• Manage multiple workstreams while delivering accurate and timely analytical solutions.

Skills

MSSQL

Alteryx

SSMS

Data profiling

Data cleansing

Data transformation

Data governance

Data modelling

Requirements translation

Data solutions

Tools

Alteryx

SSMS

Job description

MassGenics, Inc. is seeking a Data Analyst to support enterprise data enablement and governance in Charlotte, NC. The role focuses on gathering requirements, analyzing data, and delivering scalable data solutions with MSSQL, Alteryx, and SSMS expertise.

Hybrid onsite/remote work is available. The ideal candidate will translate business needs into technical specifications, perform data profiling and cleansing, and collaborate with stakeholders to ensure data quality and reporting accuracy.