BI Reporting & Data Migration Analyst

Kamatics Corporation; Bloomfield (CT); On-site; USD 73,000 - 121,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) with matching

Life insurance

Employee assistance program

Job summary

Kamatics Corporation in Bloomfield, CT, is hiring a Data Analyst to support BI reporting, dashboard development, data migration, and reporting system implementations. The role partners with cross‑functional teams to translate business requirements into interactive dashboards using Power BI, Tableau, Crystal Reports, and Opcenter Intelligence.

The ideal candidate has strong SQL skills, data migration experience, and a proven ability to translate complex data into clear reports.

Qualifications

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

Responsibilities

• Analyze and document existing Crystal Reports, including data sources, business logic, calculations, and visualizations.
• Partner with stakeholders to gather, document, and translate reporting requirements into dashboards and reporting solutions.
• Design and develop reports and interactive dashboards using Power BI, Tableau, Crystal Reports, Opcenter Intelligence, and other BI tools.
• Support migration of reports and data to a new reporting environment with accurate logic and data structures.
• Perform data extraction, transformation, loading, and validation for reporting and migration projects.
• Validate migrated reports to ensure data accuracy and alignment with requirements.
• Identify, investigate, and resolve data discrepancies and migration challenges.
• Create and maintain documentation for reports, data sources, and logic.
• Provide training and ongoing support to end users of reporting tools.
• Continuously improve reporting efficiency and usability.

Skills

Data analysis

Dashboard development

BI reporting

Analytical thinking

Communication

Education

Bachelor’s degree in Computer Science/Information Systems/Business Administration or related field

Tools

Power BI

Tableau

Crystal Reports

Opcenter Intelligence

Oracle

SQL Server

MySQL

Job description

Kamatics Corporation in Bloomfield, CT, is hiring a Data Analyst to support BI reporting, dashboard development, data migration, and reporting system implementations. The role partners with cross‑functional teams to translate business requirements into interactive dashboards using Power BI, Tableau, Crystal Reports, and Opcenter Intelligence.

The ideal candidate has strong SQL skills, data migration experience, and a proven ability to translate complex data into clear reports.