Data Analyst

Socket.dev; Moorefield (WV); On-site; USD 60,000 - 90,000; Full time

Job summary

Socket.dev is seeking a Data Analyst to develop, maintain, and deliver accurate reporting using IBM Cognos, SQL, and Python across the bank.

You will design and optimize reports, validate data, and collaborate with business units to support regulatory, audit, and executive reporting needs with a focus on data quality and documentation.

The role emphasizes automation, scalable reporting, and clear communication with stakeholders in a dynamic environment.

Qualifications

• Bachelor’s degree in data analytics, information systems, computer science, finance, accounting, or related field.
• Two or more years of experience in data reporting, business intelligence, data analysis, financial services, or related analytical role.
• Experience developing reports or dashboards in IBM Cognos or similar BI platform.

Responsibilities

• Design, develop, maintain, and enhance recurring and ad hoc reports, dashboards, data extracts, and analytical deliverables using IBM Cognos, SQL, Python, and other approved reporting tools.
• Partner with business units across all departments to understand reporting requirements and translate needs into data solutions.
• Write, optimize, and validate SQL queries to retrieve and analyze data from enterprise sources.
• Use Python to automate data preparation, validation, analysis, reconciliation, and reporting processes.
• Develop and maintain IBM Cognos reports and packages, ensuring accuracy and alignment with business requirements.
• Validate data outputs for accuracy and work with data owners to resolve data quality issues.
• Prepare concise reporting summaries and analyses to help management identify trends and make decisions.
• Maintain reporting documentation, data definitions, source-to-report mappings, and production schedules.
• Support regulatory, audit, compliance, finance, risk, and executive reporting needs.

Skills

IBM Cognos

SQL queries

Python analysis

Data validation

Data governance

Education

Bachelor’s degree in data analytics

Tools

IBM Cognos

SQL

Job description

JOB DESCRIPTION

CLASSIFICATION:Non-exempt

REPORTS TO:Data Analyst Manager

DATE:September 16, 2026

Summary/Objective

Responsible for developing, maintaining, and delivering accurate, timely, and actionable reporting and analytics in support of all departments and divisions of the Bank. This position uses IBM Cognos, SQL, Python, and related data tools to extract, validate, analyze, and present information that supports business performance, operational efficiency, regulatory awareness, and management decision-making across the organization.

Essential Functions

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Design, develop, maintain, and enhance recurring and ad hoc reports, dashboards, data extracts, and analytical deliverables using IBM Cognos, SQL, Python, and other approved reporting tools.


• Partner with business units across all departments and divisions of the Bank to understand reporting requirements, translate business needs into data solutions, and provide reliable reporting support.


• Write, optimize, and validate SQL queries to retrieve, join, and analyze data from enterprise data sources, data marts, and operational systems.


• Use Python, where appropriate, to automate data preparation, validation, analysis, reconciliation, and reporting processes.


• Develop and maintain IBM Cognos reports and packages, ensuring reports are accurate, efficient, well-documented, and aligned with business requirements.


• Validate data outputs for accuracy, completeness, consistency, and reasonableness; identify data quality issues and work with data owners, subject matter experts, and technology partners to resolve concerns.


• Prepare clear, concise reporting summaries and analyses that help management and business partners identify trends, monitor key metrics, and make informed decisions.


• Maintain reporting documentation, including report specifications, data definitions, source-to-report mapping, business rules, assumptions, and production schedules.


• Support regulatory, audit, compliance, finance, retail, commercial, operations, risk, and executive reporting needs as assigned.

Other Duties

• Performs other duties as assigned.

Skills/Abilities

• Strong analytical, problem-solving, and critical-thinking skills with the ability to translate business questions into accurate reporting solutions.


• Works with general direction from the Data Analyst Manager and exercises sound judgment in prioritizing reporting requests, validating results, and escalating issues when appropriate.


• Proficiency with IBM Cognos report development, SQL querying, relational databases, data validation, and Python-based analysis or automation. Familiarity with banking data, financial reporting, business intelligence concepts, and data governance practices is preferred.


• Demonstrates informal leadership by promoting reporting standards, sharing data knowledge, and helping business partners use information effectively; this role does not have direct staff management responsibilities.


• Communicates technical information clearly to non-technical audiences and prepares reporting explanations, summaries, and recommendations appropriate for business users, managers, and senior leaders.


• Maintains the confidentiality, integrity, and appropriate use of customer, employee, financial, operational, and proprietary Bank data.


• Builds effective working relationships with stakeholders across all departments and divisions of the Bank, including business lines, operations, finance, risk, compliance, technology, and executive support functions.

Supervisory Responsibility

This position does not have supervisory responsibilities and does not manage any staff.

Work Environment

This job operates in an office setting, the opportunity to telework is not available. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. Office environment with job duties conducted via telephone, face to face meetings, and on the computer.

Physical Demands

This position requires manual dexterity, the ability to lift files and open cabinets. This position requires bending, stooping, or standing, as necessary.

Travel

Limited local travel may be requiredfor this position.

Education and Experience

• Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Finance, Accounting, Business Administration, or a related field required; equivalent combination of education and relevant experience may be considered.


• Two or more years of experience in data reporting, business intelligence, data analysis, financial services, or a related analytical role preferred.


• Experience developing reports or dashboards in IBM Cognos or a comparable business intelligence platform preferred.

Equal Employment Opportunity/M/F/disability/protected veteran status.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.