Data Analyst

Kamatics; Bloomfield (CT); On-site; USD 65,000 - 95,000; Full time

Job summary

Kamatics is seeking a Data Analyst to lead business intelligence reporting, dashboard development, and data migration efforts from existing reports to a new environment. The role partners with cross-functional teams to gather requirements, analyze data sources, and deliver interactive dashboards using Power BI, Tableau, Crystal Reports, and Opcenter Intelligence.

The ideal candidate has strong SQL and BI experience, exceptional analytical skills, and the ability to translate complex data into

Qualifications

• Bachelor’s degree in CS/IS/Business Administration or related field.
• 3+ years of experience as a Data Analyst or BI/Reporting Analyst.
• Experience with Power BI, Tableau, Crystal Reports, and data migration.

Responsibilities

• Analyze and document existing Crystal Reports, data sources, logic, calculations, and visuals.
• Capture reporting requirements from stakeholders and translate into dashboards and reports.
• Design and develop reports and dashboards using Power BI, Tableau, Crystal Reports, and Opcenter Intelligence.
• Support migration of reports and data to a new environment with data accuracy and integrity.
• Validate migrated reports and troubleshoot data discrepancies.
• Create and maintain documentation for reports, data sources, and processes.

Skills

SQL

Power BI

Tableau

Crystal Reports

ETL

Data migration

Data analysis

Stakeholder communication

Education

Bachelor's degree in CS/IS/Business Admin

Tools

Oracle

SQL Server

MySQL

Power BI

Tableau

Crystal Reports

Job description

Kamatics is seeking a Data Analyst who is responsible for business intelligence reporting, dashboard development, data migration, and reporting system implementation. This role partners closely with cross-functional teams to gather business requirements, analyze existing reports and data sources, and develop interactive dashboards and reporting solutions using tools such as Power BI, Tableau, Crystal Reports, and Opcenter Intelligence.

A key focus of this position is supporting the migration of existing reports to a new reporting environment while ensuring data accuracy, integrity, and consistency. The ideal candidate has strong SQL and business intelligence experience, excellent analytical and problem-solving skills, and the ability to translate complex data and business requirements into effective reporting solutions.

This is a full-time, on-site position based in Bloomfield, CT.

Responsibilities

• Analyze and document existing Crystal Reports, including data sources, business logic, calculations, and visualizations.
• Partner with business stakeholders to gather, document, and translate reporting requirements into effective dashboards and reporting solutions.
• Design and develop reports and interactive dashboards using Power BI, Tableau, Crystal Reports, Opcenter Intelligence, and other business intelligence tools.
• Support the migration of existing reports and data to a new reporting environment, accurately translating existing logic and data structures.
• Perform data extraction, transformation, loading, and validation activities as part of reporting and system migration initiatives.
• Validate and test migrated reports to ensure data accuracy, integrity, and alignment with business requirements.
• Identify, investigate, and resolve data discrepancies, reporting issues, and migration-related challenges.
• Create and maintain documentation for reports, dashboards, data sources, business logic, and reporting processes.
• Partner with IT and cross-functional teams to integrate reporting solutions with existing systems and data infrastructure.
• Provide training and ongoing support to end users on reporting tools, dashboards, and system capabilities.
• Continuously evaluate reporting processes and identify opportunities to improve efficiency, accuracy, and usability.
• Perform other duties as assigned.

Qualifications

Education & Experience

• Bachelor’s degree in Computer Science, Information Systems, Business Administration, or a related field.
• 3+ years of experience as a Data Analyst, Business Intelligence Analyst, Reporting Analyst, or similar role.

Technical Skills

• Demonstrated experience developing and analyzing reports using Crystal Reports.
• Strong SQL skills for data extraction, manipulation, querying, and analysis.
• Experience with data migration and ETL processes, including data extraction, transformation, loading, and validation.
• Experience with database technologies such as Oracle, SQL Server, or MySQL.
• Proficiency with business intelligence and reporting tools such as:
• Power BI
• Tableau
• Crystal Reports
• Ability to analyze complex datasets and translate business requirements into clear, accurate, and effective reporting solutions.
• Experience validating data and troubleshooting reporting or data discrepancies.
• Familiarity with project management methodologies is a plus.

Core Competencies

• Strong analytical and problem-solving skills.
• High attention to detail and commitment to data accuracy.
• Excellent written and verbal communication skills.
• Ability to communicate effectively with both technical and non-technical stakeholders.
• Strong organization and documentation skills.
• Ability to manage multiple priorities and work collaboratively across teams.
• Adaptable and comfortable learning new technologies, systems, and reporting tools.
• Continuous improvement mindset with a focus on reporting efficiency and effectiveness.

Physical Requirements

• Frequent sitting and computer workstation use.
• Frequent use of a keyboard and mouse.
• Occasional bending and twisting.

At Kamatics, we recognize how important your career and benefits are to you and your family. We offer a full suite of benefits, including medical, dental, vision, short and long-term disability coverage, accident insurance, critical illness insurance, basic and supplemental life insurance, employee assistance plan, retirement savings and matching, and other developmental opportunities. We are committed to supporting the way you live and work.

Kamatics is an Equal Opportunity Employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other legally protected status. Applicants requiring reasonable accommodation to complete the application process may contact Human Resources.

This position requires access to information subject to the International Traffic in Arms Regulations (ITAR). Employment is contingent upon the applicant being a “U.S. person” as defined by ITAR (22 CFR §120.15), which includes U.S. citizens, lawful permanent residents, refugees, or asylees, as required by U.S. export control laws.

(Actual placement within the salary range is dependent on multiple factors, including but not limited to skills, education, experience and location)