Data Analyst

  • NY-211, Middletown, NY, USA
  • Full-time

Company Description

Core BTS is a business transformation company, providing organizations comprehensive IT solutions from application development to virtualization. Core BTS is a leader in following technology and business trends with equal enthusiasm to bring the two worlds together like no one else.  We watch our customer’s organizations thrive and grow by finding new ways to leverage IT in their businesses.

Job Description

The Data Analyst will analyze, document, design, develop and maintain all supported applications and databases. This includes, but is not limited to student information system (Infinite Campus). The incumbent will work closely with business users and staff to gather and document complex report requirements and validate the reports deliver accurate data. They will also assist in design and documentation of database structure in relation to reporting structures.

• Maintain SQL Server Reporting Services (SSRS) subscriptions and update existing reports; including optimizing existing reports to provide complete autonomy

• Perform data integrity checks in Infinite Campus and data schema manipulation

• Scrub reports and data to ensure data integrity

• Design and maintain data warehouse databases via SQL Server and cluster data for Admins and IT support

• Design Tableau data visualizations to help Administrators forecast trends

• Provide Ad-Hoc reporting via Microsoft Office and Google Suites merging multi-layered data

Qualifications

Minimum of an Associate’s Degree in field of Computer Science, Mathematics or Business. Two years of related experience preferred, specifically in: report writing, data extractions using tools such as SSRS, Access, Microsoft Excel, and SQL.

A combination of education and experience will be considered

Qualifications

Qualifications

Minimum of an Associate’s Degree in field of Computer Science, Mathematics or Business. Bachelor's preferred. 2-5 years of related experience preferred, specifically in: report writing, data extractions using tools such as SSRS, Access, Microsoft Excel, and SQL.

A combination of education and experience will be considered

Additional Information

 

EOE/AA

 

No Agencies Please!!