Sign in

SQL Server Developer/Data Analyst

Company:
Dedicated Tech Services, Inc.
Location:
Columbus, Ohio, 43215, United States
Posted:
September 21, 2017
Description:

We are not considering Corp-to-Corp subcontractors for this position.

U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Required Skills and Experience:

• SQL Server database development and customization

• Strong experience in automating reports and processes

• Bachelor’s degree

• Minimum of three to five years of experience

• Process engineering experience (understanding current and future state needs)

• API tools

• Experience and aptitude in extracting, analyzing, massaging, aggregating, and customizing data into meaningful and useful information

• Passion for technology, data, and business intelligence

• Aptitude for coding and scripting languages

• Senior (master-level) skills in MS Excel, including connecting to other data sources for data extraction and aggregation

• Experience creating strategies around synthesizing data and establishing policies and procedures for standards

• Thorough knowledge of infrastructure, application programming, and web and software applications.

• Positive attitude and willingness to learn

• Must be open to receiving an offer of employment from the client

Job Description:

We are seeking a SQL Server Developer/Data Analyst who will extract, customize, massage, aggregate, and analyze data from multiple sources. He or she will also gain an understanding of our client’s data, data sources, and how to pull data into analytics and reports. This is a potential right-to-hire position.

The client has multiple technology platforms, so the selected candidate will help the client create a strategy for synthesizing data and establishing policies and procedures for “system of record” standards.

The client also has several sources that provide it with the aggregate view of the business information. The developer/analyst will pull together:

• Financial data (revenue, expenses, budget) from the client’s accounting system (which has a SQL Server back end) and spreadsheets. Variances are calculated relative period over period, actual to plan, forecast to plan, etc.

• Customer data relative to sales, customer growth and retention, Net Promoter Score, and more. These data elements reside in disparate source.

• Operations data relative to servicing metrics.

This data is used to produce operational reporting, executive reporting, and ad-hoc business analysis.

One of the largest sources of data is the carriers that provide sales transaction data via email. That data is manually keyed into spreadsheets or SQL Server.

The client’s portals and systems include:

• An internal agency management system that houses its business transactional data and accounting information. It also has a SQL Server backend. The developer/analyst will use SQL Server (or MySQL as an alternative) to aggregate data.

• SalesForce.com as the sales, marketing, and CRM system that house prospect information and customer data. The client is constantly customizing SalesForce with data from other sources to create a “single view” of the customer.

• A new business submission portal that its clients use to submit sales requests. The client also has a Net Promoter Score platform which includes data and customer feedback

• ImageRight as its document storage system

• Office 365 SharePoint for other document storage and sharing functions.

5662