Data Analyst
Job Description
COCC is seeking a Business Intelligence Data Analyst to support reporting, analytics, and data-driven decision-making. This opportunity focuses on helping teams turn complex information into clear, reliable insights that support business and operational needs. The analyst will contribute to a Microsoft-based data and analytics environment and work with stakeholders across banking, finance, operations, risk, and compliance functions.
About The Role
In this hybrid role based in Camp Hill, Pennsylvania, you will analyze data, develop reporting solutions, and help strengthen the data assets used across the organization. You will partner with business stakeholders to understand their questions, clarify reporting requirements, and translate those needs into useful dashboards, scorecards, and metrics. The position combines hands-on SQL development and Power BI reporting with data validation, documentation, and collaboration across technical and nontechnical teams.
The ideal candidate is curious, detail-oriented, and comfortable working with complex datasets. You will help ensure that reports are accurate, understandable, and aligned with defined business rules. You will also look for opportunities to improve existing processes and create scalable analytical solutions that support ongoing and emerging reporting needs.
Qualifications
A bachelor’s degree in Data Analytics, Information Systems, Computer Science, Statistics, or a related field is preferred. Equivalent education, technical training, or directly related experience will also be considered. Candidates should bring three to five years of experience in data analytics, business intelligence, reporting, data validation, or a related analyst role.
Strong proficiency with SQL, Power BI, Excel, and Microsoft analytics tools is important. Experience with Microsoft SQL, large datasets, data warehousing, reporting layers, KPI development, and business stakeholder support is expected. Candidates should understand data quality and governance concepts and be able to manage multiple priorities while communicating clearly with technical and nontechnical audiences. Banking, financial services, or other regulated-industry experience is preferred. Familiarity with Microsoft Fabric, Azure-based data services, or modern analytics platforms is an advantage.
Responsibilities
Analyze banking, financial, and operational data to identify trends, risks, and opportunities. Work with stakeholders to gather reporting requirements, define key performance indicators, and establish clear business rules. Develop and maintain Power BI dashboards, scorecards, and executive reports that make information accessible and actionable.
Create, maintain, and optimize SQL queries, views, and stored procedures. Support data ingestion, transformation, and orchestration workflows within Microsoft data platforms, and contribute to the development and maintenance of the data warehouse and analytics environment. Validate data accuracy, investigate discrepancies, and support enterprise data quality initiatives.
Document data definitions, transformation logic, business rules, and reporting processes. Provide reliable data assets for regulatory, audit, risk, and compliance reporting needs. Identify opportunities to streamline workflows and recommend reporting approaches that are accurate, maintainable, and scalable.
Benefits
This is a hybrid position based in Camp Hill, PA, offering the opportunity to contribute to business intelligence and analytics work across multiple functions. The salary range is $80,000 to $109,000, depending on experience. Specific benefits and eligibility details can be discussed during the hiring process. COCC is unable to provide employment sponsorship now or in the future.
Equal Opportunity
COCC is committed to fair and equitable employment practices. Applicants will be considered based on their qualifications, experience, and ability to perform the role’s responsibilities, without discrimination in accordance with applicable laws.