Skip to Main Content
← Back to Jobs

Business Analyst Requirements Specialist

GTN Technical Staffing Albany, NY
  • Expired: over a month ago. Applications are no longer accepted.

Business Analyst Requirements Specialist

HIGHLIGHTS
Location: Albany, NY
Position Type: 18 Month Contract
Hourly / Salary: BOE
Residency Status: US Citizen, Green Card Holder, H1' s
ONSITE ONLY

Job Description:
  • Gather and validate of BI and reporting requirements
  • Document requirements & solutions
  • Perform Data profiling on the source systems
  • Design and review star schema dimensional model to support data warehouse and data marts
  • Perform Source to Target Mapping between source system database and data warehouse target database
  • Develop ETL transformations using the ETL tool SQL Server Integration Services (SSIS)
  • Develop analytics and reports using Tableau and SQL Server Reporting Services (SSRS)
  • Develop complex queries using Transact-SQL leveraging analytic functions

Requirements:
  • 3-5 years IT Specialist - Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer
  • Candidate is able to work independently, without assistance
  • 3 years experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using SQL Server Integration Services (SSIS) or other similar ETL tool

Requested Skills:
  • 3 years experience in analytics and operational reporting using Tableau and SQL Server Reporting Services (SSRS)
  • 3 years experience in Star Schema / Dimensional Modeling to support data warehouse environments as well as OLTP environments
  • 4 years experience developing and tuning complex SQL and PL/SQL against Oracle (11g or newer) or SQL Server
  • 3 years experience in complex SQL development leveraging analytics functions
  • Bachelors’ degree (or higher) in Computer Science, Software Engineering, Computer Information Systems, or some related field

GTN Technical Staffing

Address

Albany, NY
USA