Business Intelligence Specialist Job in St. Louis 63141, Missouri US

VantageLinks is dedicated to Information Technology (IT) staffing through permanent placement, contract-to-hire, and contract services. We also offer Team Services and Information Systems Development Solutions. We specialize in finding Information Technology professionals ranging from help desk specialists to programmers including; systems analysts, designers, architects, database professionals, ERP specialists, and project managers. We support a wide range of environments including but not limited to .NET, Java, UNIX.

 

Position Summary

The Business Intelligence Specialist is responsible for designing, developing maintaining data

warehouse BI solutions using Microsoft BI Stack. This includes gathering requirements,

designing, and rolling out reporting solutions to end users. Responsibilities range from assisting in the modeling and building of reporting data structures, aggregating data from multiple disparate sources [ETL], to the development of self-serve reports, on-demand/dynamic dashboards, and automated email digests. The position is responsible for assisting to scale our reporting capabilities to match growth of internal and external customer need. Data accuracy and security are important components to all deliverables. The Business Specialist also serves as a champion of our data and reporting capabilities.

 

The Position

Essential Duties and Responsibilities

•      Design, develop, and implement BI solutions supporting end user business requirements

•      Design and develop metadata models; integrated reports, scorecards and dashboards

·         Work with and guide Data Mart and BI Developers to rapidly develop business intelligence assets

•      Database design and development for OLTP and OLAP systems

•      Design and implement ETL processes from various source systems

•      Identify and analyze performance trends, including drivers of performance and forecast impact on future results. Where applicable makes recommendations on use of information to improve results, including recommendations on changes to business processes

•      Provides research, audit and analysis of complex data needs.

•      Be familiar with and understand business processes and transactional systems

•      Assist in the creation of BI development standards and processes

·         Work autonomously and cooperatively within a fast-paced environment and balance priorities to best meet the demands of multiple projects and business priorities.

•      Coordinate and communicate as needed with key technology resources, including

·         Technology Director, Technology Integration Specialist, SQL Developer, Web

·         Development and Systems.

•      Assists in identifying bad data and creating standards and process for ensuring accuracy.

•      Serve as mentor for the Business Reporting Specialist and any members added to that team.

•      Serve as knowledgebase and development reference for other Technology staff members.

 

Education and/or Work Experience

•      Four-plus years’ experience in a business analysis role and a Bachelor’s degree in Computer Science/related field or Eight-plus years’ experience in a business analysis role with demonstrable technical experience.

•      3-5 years of experience designing, building and maintaining data warehouse and BI solutions using the Microsoft BI stack (SQL Server 2005/2008, SSIS, SSAS, SSRS, PerformancePoint, SharePoint)

•      3-5 years of experience with data transformation, data modeling, data mapping, structured and unstructured data and combining disparate data sources to provide an accurate consolidated source of record

•      Superior skills writing, reading, and turning Transact SQL.

•      Excellent analytical, problem solving, and collaborative skills

•      Ability to clearly present written and verbal information to executive management

•      Experience in requirements gathering and knowledge of standard system development lifecycle concept

•      Microsoft Business Intelligence and SQL Developer certifications a plus.

•      Knowledge of best practices re: report design and layout

•      Financial Services industry experience desired.

•      Ability to conceive creative solutions and processes to technology challenges

•      Maintain an overall positive attitude and work closely with other development staff

•      Strong attention to detail and numerical accuracy

 

At VantageLinks, we offer a competitive compensation package including, outstanding Medical Dental insurance, Long term Short term disability insurance, life insurance, paid time off (vacation, sick, holidays), 401(k) with company match, Flexible Spending Accounts (FSA), Health Reimbursement Account (HRA), Training Reimbursements, Direct Deposit, bonuses, and relaxed yet professional work environment. For additional information and complete list of openings, please visit our web site at www.vantagelinks.com