Microsoft ELT (SSIS) Developer

Error message

  • Deprecated function: implode(): Passing glue string after array is deprecated. Swap the parameters in drupal_get_feeds() (line 394 of /home2/sharps/public_html/includes/common.inc).
  • Deprecated function: The each() function is deprecated. This message will be suppressed on further calls in _menu_load_objects() (line 579 of /home2/sharps/public_html/includes/menu.inc).
Job Location: 
Woodlawn, MD
Positions Available: 
2
Hours per Week: 
40+
Years of Experience: 
12+
Benefits: 
All Company Benefits
Description of Work: 
  • Help the client design, build, stabilize and deploy a Microsoft Business Intelligence solution for a large 12 million record flat file using SQL Server, SSIS, SSAS, SSRS.
  • Participate in customer team meetings and conversations with client personnel to understand business and technical requirements including  requirements definition, schema design, ETL (SSIS), cube design and development (SSAS), end-user presentation (via analytic reports, graphs, scorecards, etc.), testing, deployment, and post-deployment support.  
  • Create and maintain a variety of related artifacts (e.g., requirements, process models or diagrams, data matrices, project deliverables).
  • Plan for and conduct implementation activities.
  • Demonstrate strong oral and written communication skills, with the ability to communicate technical topics to management and non-technical audiences, as well as interface with the customer and Northrop Grumman management on a daily basis and compile periodic reports.
  • Become knowledgeable on the HIPAA policies and procedures for the program and ensure awareness of HIPAA breach process.  Understand your role in HIPAA compliance and be able to execute that role in an effective manner.
Basic Qualifications: 
  • Bachelor’s degree and 14 years of related experience; Master’s degree and 12 years of experience; or 18 years of experience will satisfy degree and experience requirements.
  • ETL developer with 3+ years demonstrable experience using SSIS , T-SQL with SQL Server 2008 - 2012
  • Knowledge of Data Warehousing methodologies and concepts
  • Strong understanding of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services ( SSRS)
  • Experience in analysis, design and construction of data marts and data warehouses in SQL Server
  • Strong in T-SQL, Stored Procedures , error/exception handling and tuning of tables and views
  • Experience in performance tuning in Sqlserver.
  • Proficient in Microsoft Visio, Project, Excel, Word
Preferred Qualifications: 
  • Prior SSA or Federal consulting experience
  • Familiarity with SSA infrastructure including exposure to COBOL, JCL, SAS, FOCUS, or DB2 a plus.
  • Knowledge of SSA disability systems or claims administration processes for large health or human services organizations
  • Knowledge of SSA disability program/policy (or the capability to quickly understand)
  • Experience in Agile development environments