Jobs in America

Reporting and BI Analyst

Posted: December 1, 2023 Expired: February 16, 2024
America
FULL TIME
3 Year

Position Overview:


The IT Reporting Analyst will bring their expertise in data reporting and analysis. While maintaining existing reporting requirements, the ideal candidate will also drive solutions and change how WSS reports and visualizes data.


ESSENTIAL DUTIES AND RESPONSIBILITIES:


  • Design, create, maintain, deploy, and manage SSIS packages
  • Develop, test, manage and implement SSIS Packages from development server to production server using package configuration
  • Work on maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
  • Ability to automate the execution of SSIS packages using SQL Server Agent Jobs
  • Formulate and document ETL process design based on business requirements and system specification including source to target mapping and transformations
  • Diagnose and resolve incident tickets and errors
  • Develop ETL specifications, data mapping and other documentation requiredfor ETL development
  • Use SQL, data models, data element dictionary and schema to perform data and business analysis
  • Understand business data and perform quality assurance testing to ensure the data presented is correct
  • Collaborate with IT staff, and business stakeholders to create, maintain, and support ETL packages in a compliant, regulated environment
  • Proactively engage in continuous improvement efforts in current systems as well as new reporting platforms

EDUCATION and/or EXPERIENCE:


  • Minimum Associates Degree, Bachelors Preferred
  • 3+ years experience in SQL SERVER, Solid SQL / T-SQL development: stored procedures, database triggers, views, and other database manipulation languages/methods is REQUIRED
  • Experience using Microsoft SQL Server BI Suite and SSIS/SSRS, MS SQL scripting, and SQL Server version 2014 or higher is REQUIRED
  • Experience in C#.net, PowerShell scripts, Batch Script
  • Experience in developing and maintaining Power BI
This job was expired