Sr. Business Analyst (Data Warehouse Operations Analyst)
Advanced Technology Systems Inc. - Washington, DC

This job posting is no longer available on Advanced Technology Systems Inc.. Find similar jobs: Senior Business Analyst jobs - Advanced Technology Systems jobs

Salient Federal Solutions, Inc. (Salient) has completed the acquisition of ATS Corporation (ATSC). For more information please visit Salient at

We are looking for a Senior Business Analyst (Data Warehouse Operations Analyst) for our direct client at Washington DC.

This is a long term position.

This individual will support the Securities and FDW business team within Enterprise Data Warehouse Operations.

The individual will contribute to the on-going support and maintenance of our clients’s Enterprise Data Warehouse, a critical system in client’s daily business operations.
This mission of this individual will be to ensure that client’s corporate data repositories are up to date with the highest quality information.

To achieve goal, the individual will be required to conduct detailed data reconciliations and execute data quality checks to identify and remediate data anomalies.

The successful candidate will have strong data analysis and problem solving skills, and will be expected to work collaboratively to identify root causes of data issues and establish remediation plans.

In addition, the individual will also assist in establishing and executing operational procedures for business continuity planning and operational risk management, including the development new metrics and reporting focused on the data quality and effectiveness of the data warehouse environment.

Required Experience:
The successful candidate will be smart, inquisitive, highly motivated to succeed within a team environment, and will be dedicated to delivering high quality data to our key stakeholders.
The successful candidate will possess excellent organizational, critical thinking, communication skills, along with a superb attention to detail.
A solid understanding of data warehouse / database concepts is required.

Strong data analysis skills using SQL/MS Access is also required.

Previous experience in financial services industry is highly preferred.
Previous experience working in a production IT environment, ideally with an enterprise data warehouse or other relational database management system is also highly preferred.

Preferred Experience:
Experience in the secondary mortgage industry, knowledge of securities accounting, or understanding of capital markets operations.

Knowledge of securities data repositories, such as Bloomberg is preferred.
Previous project management experience is preferred.
Bachelors Degree in Information Systems, Computer Science, Accounting, Finance, or BBA

Experience writing SQL queries in Oracle data warehouse environment , using MS Access, Rapid SQL or TOAD

What this person will do in everyday terms:
Data analysis, production data reconciliations, data requirements writing, business continuity testing.


Salient Federal Solutions, Inc. (Salient), a leading provider of information technology; engineering and intelligence analytic services; to agencies in the intelligence, defense, homeland security, and cyber domains, completed its acquisition of ATS Corporation (ATSC), a leading information technology company delivering innovative technology solutions to government and commercial organizations.

Salient is proud to be an Equal Employment Opportunity/AAP employer and maintains a Drug-Free Workplace. Salient prohibits discrimination against employees and qualified applicants for employment on the basis of race, color, religion, sex (including pregnancy), age, disability, marital status, national origin, veteran status, or any other classification protected by applicable discrimination laws. Salient will make reasonable accommodations, in appropriate cases, for qualified individuals with disabilities, if it can do so without undue hardship.


    Skills Required



    Advanced Technology Systems Inc. - 2 years ago - save job