Data Analyst/Senior

Job Description

The duties and responsibilities of this position include, but are not limited to:
• Assist the Lead Database Architect in defining and implementing data architecture principles to align and conform with business objectives
• Assist the ETL team in the design of efficient processes to load and manage the data, including a Data Quality Assessment to ensure the quality of the source data will meet the information requirements, developing Business Rules, Data Mappings, and Transformation Rules
• Provide a standard design for the construction of data mapping documents and oversee their generation.
• Execute the design, analysis, or evaluation using database design principles and adhering to business standards, practices, procedures, and product / program requirements
• Facilitate, conduct and document data mapping session
• Ability to define requirements by conducting interviews and facilitating/participation in data modeling sessions with business clients
• Assist application development teams in creating effective database designs from business requirements.
• Responsible for developing and maintaining a formal description of the data and data structures
• Assist the Lead Database Architect in defining and implementing data architecture principles to align and conform business capabilities
• .Serve as IT subject matter expert during application development lifecycle by participating in peer reviews and knowledge transfer.
• Analyze data to identify missing, incomplete, or invalid information. Contact originators of source documents to resolve questions, inconsistencies, or missing data
• Assist in supporting multiple SQL Server data repository, which may include documenting database architecture and analyzing datasets to identify missing, incomplete, or invalid information.
• Document the business definitions for the database entities and attributes
• Assume responsibility for data integrity among various internal groups and/or between internal and external sources
• Inventory existing data repositories, documenting the structures and contents of each and the data flow between them.
• Model business and systems processes based on findings through use case scenarios, workflow diagrams, and data models

Qualifications

 ER/Studio Data Architect – 2+ yrs exp
* MS Office/ Visio – 2+ yrs exp
* Windows 7 – 2+ yrs exp
* SQL Server 2005/2008/2012/ T-SQL – Intermediate – 1-3 yrs exp
* Visual Studio 2010/2012 – 1-3 yrs exp
* SSIS – Intermediate – 1-3 yrs exp
* Relational Databases – Intermediate – 1-2 yrs exp

Additional Information

- "All your information will be kept confidential according to EEO guidelines". 
- All candidates who are authorized to work in US are encouraged to apply.

- Most of our positions require Candidate to clear the Background check prior to commencing the assignment.

SOURCER ASSIGNED: Pete Tylor; Email: pete dot tylor at idealforce.com

Disclaimer: 

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.