Previous Job
Business Systems Analyst
Ref No.: 17-03378
Location: St. Paul, Minnesota
Position Type:Contract to Hire
Business Systems Analyst
Contract to Hire
St. Paul, MN

Position Overview:
  • Design, develop, and document complex technical solutions in a Microsoft business intelligence environment (SSAS, SQL Server, and SSRS).
  • Provide ongoing performance monitoring and tuning, and automation of production activities related to Data Warehouse/Mart, ETL and BI environment.
  • Work in conjunction with compensation analysts and other users acting as a liaison between technical and business departments in developing SSAS cubes, dashboards and other BI related solutions.
  • Extract complex data from multiple sources into usable and meaningful reports and analyses
  • Design, develop and test high-quality Extract, Transformation and Load (ETL) processes, programs and scripts with Informatic or SSIS, and use an automation tool such as UC4;
  • Create and maintain detailed documentation for the development and production teams
  • Support user community on data analytics when needed
  • Develops guidelines and standards as directed
Position Requirements:
  • Bachelor's degree in computer science or MIS
  • 3+ years of experience in Microsoft BI stack: SSIS, SSAS (Tabular) and SSRS;
  • 3+ years of business intelligence experience as well as data warehousing concepts, data modelling, design and implementation of data warehousing solutions.
  • 2+ years of experience in design and implementation of ETL processes to support data warehouse and data integrations.
  • 2+ years of experience developing Microsoft Access (including VBA) and Excel (Pivot, ODBC);
  • 1+ years of experience with other coding with languages and preferable C#.
  • Experience with compensation systems
  • Previous experience with DB2 database
  • Hands-on performance tuning and troubleshooting experience involving data loads, stored procedures and data related issues – It would be nice to cross SQL Server and DB2.
Third Party Applications Not Accepted