South Dakota Jobs

South Dakota Department of Labor & Regulation mobile logo

Job Information

Great Western Bank Business Intelligence Analyst in Sioux Falls, South Dakota


General Description and Essential Functions

Designs, develops, implements, and maintains reporting solutions using SQL Server, SSAS, SSRS, and other reporting tools. Assess business requirements as well as writes and maintains stored procedures, functions, and queries meant to assist the organization in accessing and analyzing business data. Develops standard and custom reports using SSRS and SSAS. Assists in the development and implementation of ETL functions and processes for incoming and outgoing data transfers. Documents workflows, enhancements, and QA processes.

  • SQL Server 2016, SSAS, SSRS, OLAP/MDX.

  • Relational database design and normalization

  • Development of warehouse databases, ETL processes, OLAP, reports and dashboards

  • Create reports and enable client reporting tools (MS Office)

  • Processing of cubes programmatically and incrementally and drill thru Reporting via Cubes or SSRS

  • Assist with projects and assignments within the bank


  • 1-3 years of analytics experience and/or Bachelor’s degree in Computer Science, Data Science, MIS, Statistics, Mathematics, or related field

  • Strong skills in MS Office Products Including Excel, Word, PowerPoint

  • Strong analytical skills

  • Individual must be self-starter, good communicator and able to work within a large team.

Job Expectations

• Respond to and resolve customer service requests according to Great Western policies in a prompt, efficient and courteous manner at all times.

• Perform other job-related duties or special projects as assigned.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)