Data Analyst

Full-time

Responsible for loading client provided data and creating custom client reporting. Serves as the secondary technical contact and works in conjunction with the Web Developers and QAs to ensure that all database-related tasks are completed in an accurate and timely manner.

Essential Functions:

  • Meet with clients to discuss reporting and data needs.
  • Database design and development within the structure and guidelines of a model database.
  • Provide Custom Reports, ad hoc reports through queries, stored procedures and SSRS.
  • Database SQL job setup, data manipulation, ETL and Export.
  • Provide automated data transfer with SSIS.
  • Provide on-call support when assigned events are on-site.
  • Provide technical support and training to internal employees and external clients.

Required Skills:

  • ETL and report writing experience and the ability to communicate well and professionally with internal staff and clients.
  • Must possess both an adeptness to translate end-user requests into technical specifications and the ability to explain intricate technical processes in non-technical terms.
  • Excellent organizational, analytical, data troubleshooting and detailed precision skills.
  • Must have the ability to handle challenging situations, multi-task, and perform within tight time constraints.
  • Must be committed to learning new skills and adapting to changing technologies.

Required Technical Skills:

  • Microsoft SQL Server, Transact-SQL development and/or Database Administration.
  • Exposure to ETL concepts and platforms, such as SSIS.
  • Experience utilizing report writing software, such as SSRS, or BI tools such as Sisense, Qlik, or Tableau.
  • Data concepts, such as use of joins, structure of tables and indexes, stored procedures and functions.
  • Ability to use expressions to calculate, group, filter, parameterize, optimize and format custom reports.
  • Strong background in Microsoft Excel.

Education:
Bachelor’s degree desired; equivalent related work experience required.

For more information and to apply online, click here.

Speak Your Mind

*