SQL BI Developer

Job Descriptions:
GreenSky is one of the fastest growing Financial Technology companies in America. We make it easy for businesses of all sizes to offer credit to their customers with a fast and paperless solution. With billions of dollars in loans and hundreds of thousands of satisfied customers, GreenSky is quickly changing the consumer credit marketplace. We have a great team, are growing quickly, and are backed by some of the leading investors in the world.

Our corporate headquarters is located in the financial technology hub of Atlanta, GA.

Looking for great talent to help us continue our rapid growth!”

Execute MS SQL Server queries for data extraction and reporting, performing data conversions (ETL) from several data sources, develop necessary SQL for loading, updating and maintaining data tables. Also, trouble-shooting data file related issues, and quality control.

The candidate will test and verify processes and systems to understand the cause of data issues. Statistically analyze data and interpret findings to identify opportunities for database and product improvements. Additionally, this position will create and maintain detailed documentation as required pertinent to problems and errors produced by database processes and applications. Coordinate various business improvement initiatives by applying excellent analytical and problem resolution skills.

Retrieve data from various sources and prepares data for analysis. Working on data manipulation and extraction using Microsoft SQL Server Management Studio 2008

Develop complex SQL queries against various data and computer sources. Including complex Sub queries, correlated queries, and nested queries.

Analyze and interpret data, producing clear and compelling reports for different audiences which may include graphs and charts of data developed by analyzing situations and/or data models from which answers can be obtained.

Supports business area projects by applying general knowledge of the business area processes including best practices.

May provide data and respond to questions to external groups/agencies/vendors.

Concisely summarize and communicate recommendations to various levels of management maintaining confidential information

Required Experience:
REQUIRED EXPERIENCE

A Bachelor’s degree with an emphasis in Computer Science, Databases, Technology, or equivalent work experience. 5+ years of business experience

5+ years of MS SQL Server (2005/2008), Transact-SQL, Stored Procedures

Strong (3+ solid years) of experience with SQL Server Reporting Services (SSRS)

and at least one year of SQL Server Integration Services (SSIS)

Retrieve data from various sources and prepares data for analysis. Working on data manipulation and extraction using Microsoft SQL Server Management Studio 2008

Develop complex SQL queries against various data and computer sources. Including complex Sub queries, correlated queries, and nested queries.

Analyze and interpret data, producing clear and compelling reports for different audiences which may include graphs and charts of data developed by analyzing situations and/or data models from which answers can be obtained.

Supports business area projects by applying general knowledge of the business area processes including best practices.

May provide data and respond to questions to external groups/agencies/vendors.

Intermediate MS Office skills including the ability to create, manipulate and formulate spreadsheets. Knowledge of spreadsheet functionality including v-look-up, pivot tables, charts and graphing.

Must be well organized, extremely detail oriented and have great communication skills, both oral and written.

Concisely summarize and communicate recommendations to various levels of management maintaining confidential information

Must be flexible and have the ability to adapt quickly as external environment and organizational changes occur.

Write queries and stored procedures in SQL, exports data into excel or csv files, reviews them for quality and data integrity, and sends them to internal clients or external agencies.

Combining of data files for use of suppression or enrichment (Combining of different outputs format to aid in targeting)

Basic understanding of the direct marketing project process flow, including postal database structure is a plus.

Basic knowledge of MicroStrategy developing reports and dashboards a plus.

Knowledge of SQL 2014 a huge plus.

We strongly encourage Armed Forces Veterans to apply

Keyword: SQL, SSRS, SQL Server, Reporting, Developer

From: GreenSky