Battle Resource Management, Inc.

ETL Analyst and Developer

Job Locations US-DC-Washington
Posted Date 2 weeks ago(2/8/2018 10:10 AM)
ID
2018-1848
# of Openings
1
Category
Analytics

Overview

In support of a financial institution association, BRMi is developing a pilot solution for master data management where the first stage will be to extract and transform 3 major data sources into a normalized staging database. The second stage will be to evaluate master data management tools and apply deduplication, matching, and merging of sources records to create a unified enterprise set of records. BRMi is initialy seeking a SSIS ETL analyst and developer to support this important initiative. The ideal candidate will have not only strong technical capability but also strong analysis capability to support key decisions to be made for the pilot. To continue to support the pilot for the second stage, the candidate requires additional capabilities with the data quality and master data management tools.

Responsibilities

  • Work closely with Business Representatives to understand business requirements
  • Perform Data profiling and analysis of structured and unstructured data
  • Define data issues and inconsistencies in a logical and business friendly manner
  • Define new interface layouts for integrating into into a data warehouse
  • Create source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
  • Create ETL Processes using Microsoft Server Integration Services (SSIS)
  • Create Process Flows using Visio
  • Create/maintain design related artifacts i.e. data models , Mapping documents, architecture diagrams, data flow diagrams
  • Performance tuning of ETL processes
  • Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions.
  • Plan and conduct ETL unit, system, and integration testing; identify and remedy solution defects.
  • Create other technical artifacts needed for project implementation

Qualifications

Required:

  • 5+ years of Data Integration/ETL development experience
  • 3+ years of ETL design using Microsoft SSIS
  • 3+ years of SQL Server Experience with versions 2008 and/or 2012
  • Configuration Management using Microsoft Team Foundation Server and/or other version control tools
  • Understanding of Enterprise Data warehouse data models and dimensional modelling concepts, source to target mapping and Data Integration architecture
  • Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the client
  • Excellent oral and written communication skills
  • U.S. Citizenship

Desired:

  • Familiarity with data quality tools such as Microsoft Data Quality Services (DQS) and Master Data Services (MDS)
  • Familiarity with reporting tools such as Microsoft SQL Server Reporting Services, Cognos, Business Objects, Microstrategy, QlikView
  • Experience applying data-related capabilities within the financial industry
  • Experience creating dimensional models using Erwin

EOE/Minorities/Females/Vet/Disabled 

We are an equal opportunity employer that values diversity and commitment at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. Employment policies and decisions on employment and promotion are based on merit, qualifications, performance, and business needs. The decisions and criteria governing the employment relationship with all employees are made in a nondiscriminatory manner, without regard to race, religion, color, national origin, sex, age, marital status, physical or mental disability, medical condition, veteran status, or any other factor determined to be unlawful by federal, state, or local statutes. 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed