Analytics/SQL developer
Carrollton, TX

Job Description

The Analytics/Database developer is responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses. The successful candidate will provide complex database analytics and reporting based on the services we provide. In addition, the candidate will oversee data collection while analyzing the data and creating metrics to drive operational performance and improvement. This role will be 50% analytic development and 50% SQL development.

The candidate should be competent to complete most development tasks independently but may require instruction and guidance on complex tasks.

* Design and develops database applications using SQL Server Integration Services TSQL and Stored Procedures.


* Perform algorithm development for predictive analytics and forecasting


* Develop data cubes using SSAS for data analysis


* Consult with the business to determine logical design for new business solutions according to existing data architecture


* Perform code reviews analyze execution plans and re-factor inefficient code


* Follows data standards resolves data issues completes unit testing and completes system documentation for ETL processes


* Collaborate with business analysts source system experts and other team members to determine data extraction and transformation requirements


* Collaborate with IT operations and testing organizations to ensure timely releases of projects and database environments are sustainable


* Collaborate with IT operations for support in problem resolution and root cause analysis.


* Support IT staff and business users in the development usage and troubleshooting of database-driven applications


* Participate in special projects as needed and performs other duties as assigned.


* Provides on-call assistance as needed


* Ensure development follows the ABSG SDLC process


* BS or BA or equivalent experience required.


* 6 years of SQL Server programming experience.


* Knowledge of Power BI, QlikView, Excel PowerPivot or SSRS; Statistical background and/or some exposure to R programming is a nice to have.


* Knowledge of physical database administration with SQL Server a plus.


* Excellent written and verbal communications skills required.


* Must be able to work in a fast paced team environment.


* 6 years of SQL Server programming experience.


* SQL Server Database Architecture and Design (OLTP/OLAP) and SQL Server Database Programming and Development. SQL Server 2008 and SQL Server 2012 (SQL Server 2016 a plus)


* Strong knowledge of T-SQL Stored Procedures Triggers and DTS development