Previous Job
SQL Server Developer
Ref No.: 18-15985
Location: Linthicum, Maryland
Required Skills :
SQL, SSIS, and SSRS (SSAS is a plus)

Basic Qualifications :

Job Description :
Apex Systems has an opening for a SQL Server Developer to assume responsibilities for the data warehouse and reporting activities. Job responsibilities will include developing processes for data migration activities, develop automated processes for measuring the quality and consistency of key data and building processes to enhance data quality. The MS SQL Server Developer will also assist in the implementation of the SQL Server reporting architecture and will assist the Application Development team and various Business departments with SQL Server related activities including OLTP, reporting and analytics. This is a contract-to-perm position located outside of Baltimore, MD.
Job Title: SQL Server Developer
Location: Linthicum, MD
Responsibilities of SQL Server Developer:
Design and develop applications for data warehouse and data marts to meet the reporting requirements of business departments.
Facilitate the transformation of volumes of data into end-user excel workbooks and reports.
Perform ad-hoc data queries in response to critical business needs.
Design, develop and maintain T-SQL database objects including table schemas, stored procedures, views and triggers for OLTP environment.
Design and implement ETL components of data warehouse including data quality control reports and balancing reports from source system to data warehouse.
Perform data analysis on source system data to understand gaps, inconsistencies and other quality issues, and develop data quality improvement solutions.
Produce comprehensive documentation of all developed software & repositories.
Train and assist report developers in Data Warehouse design and SSRS reporting techniques and standards.
Assist application developers with OLTP data implementation.
Analyze and remedy database and query performance issues.
Automation of routine processes with appropriate monitoring controls.
Define and maintain standards for data architecture, data governance, data integrity, data access, and data security.
Design and implement solution for the data migration activities from the different source system to the new target system.
Experience Requirements of SQL Server Developer:
Accuracy, attention to details.
SQL Server database (2012)
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS) / MDX / OLAP
SQL Server OLTP transaction processing
Experiencing developing Crystal Reports
Experience in development and implementation of data warehouse / mart solutions using complex datasets.
Experience in reporting toolsets, job scheduling, publishing and distribution of reports.
Data modeling and normalization.
Experience in implementation of control and reconciliation reports.
Experience working with business leadership to identify key performance metrics and developing associated reporting requirements.
Understanding of health care insurance data is a plus.