Data Analyst

Sypherlink

B.S. in Computer Science or similar degree is required

• Competent with SQL Commands 
• Experience converting data from one data model to another o Experience with an ETL tool such as Informatica, Pentaho or SQL Server Integration Services is a plus
• Competence in reading and reviewing XML output
• Experience writing basic scripts in any scripting language
• Strong documentation and communication skills
• Familiarity with the domain of law enforcement and related systems is a big plus
• U.S. Citizenship is required. Candidate will need to have one or more background checks performed as directed by the end client.

Overview A Data Analyst I is responsible for creating mappings between fields from client source databases to Sypherlink’s internal data model and then creating extract, transform and load (ETL) transformations to move the data. The source systems will have already been mapped in the past and are documented. Position Responsibilities • Analysis of database tables as they relate to a data warehouse model and determination of likely intra and inter-database relationships. • Assess the quality and consistency of data stored in a source database and develop recommendations for data cleansing based upon data warehouse business rules. • Prepare a Data Quality and Schema Structure Report which documents findings regarding the database analysis work performed. ER diagramming will be a part of this activity. • Create mappings between the fields in the source and target systems as well as identifying relationships within a source (implicit foreign keys, lookup tables, etc.). • Leverage mappings to create an ETL process to move the data from the source system to the target system. • Quality assurance validation of the transformed data output, often in XML format.