Company: Superior Vision
Position Title: .Net (C#)/ SQL Developer
Duration: 6 months C2H
Location: Linthicum, MD
3 Must Haves:C#
SSIS/SSRS
SQL Server 2014
Job Description:
Major Duties and Responsibilities:
- Design and develop applications for data warehouse and data marts to meet the reporting requirements of business departments.
- Facilitate the transformation 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.
- Analyze and remedy database and query performance issues.
- Automate 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.
- Other duties as assigned.
Qualifications:
Education: Bachelor's Degree in Computer Science or related field.
Experience: Minimum of 3 years relevant work experience. Experience in managed health care environment is helpful.
Competencies: - SQL Server database (2014)
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- SQL Server OLTP transaction processing.
- Proficiency with C# .NET development.
- Accuracy, attention to details.
- Experience in reporting toolsets, job scheduling, publishing and distribution of reports.
- Experience in implementation of control and reconciliation reports.
- Experience working with business leadership to identify key performance metrics and developing associated reporting requirements.
- Team oriented, with the ability to work effectively across functional areas of the company.
- Excellent analytical, problem resolution and people skills.
- Ability to deliver quality results under tight deadlines.
- Excellent customer service orientation.
- Ability to work independently with minimal supervision.
- Proficiency with Crystal Reports, PowerShell scripting a plus.
- Understanding of vision care insurance or health care insurance data is a plus.