Randstad ETL Data Analyst-FTE-NJ in Mount Laurel, New Jersey
ETL Data Analyst-FTE-NJ
Mount Laurel, NJ
Tuesday, October 11, 2016
Looking for an ETL Data Analyst for a Permanent role with our client in southern NJ.
The Senior IT Data Analyst provides technical leadership across a broad range of data analysis functions including data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data management functions. Works independently as a senior lead and may manage and direct activities related to analysis, design and support of technical data management solutions on various projects ranging in larger projects. Elicit, analyze and understand business and data requirements to develop complete business solutions, including data models (entity relationship diagrams, dimensional data models), ETL and business rules, data life- cycle management, governance, lineage, metadata and reporting elements.
Apply automation and innovation on new data platforms and on-going on any new development projects / initiatives aligned to business or organizational strategies
Design and implement reporting platforms, including modeling, ETL, BI framework and be able to deliver complete BI solution that meets business requirements
Design and implement complex ETL frameworks to provide a solution that meets business requirements
Collaborate and build effective working relationships with colleagues across technology and the business to achieve business and IT objectives
Work closely with various technology/project teams to understand the business meaning of data, and provide analysis and requirements to ensure the data design is fully understood and the development initiatives are in line with the intended design and standards
Advanced knowledge of the technical environment/ tools) for own area of expertise.
Advanced knowledge of business processes and procedures on a broad, organizational level.
Sound to advanced knowledge of business/ organization, client standards, infrastructure, architecture and technology in related areas from a design/support/ solutions perspective.
Subject matter expert in at least one area of discipline and consults with clients/or project teams with respect to all aspects of research, analysis, design, hardware / software support, development of technical solutions and/or testing.
Works independently in a senior/lead role on a diverse range of tasks and may be relied upon to coach / educate others.
Assignments are moderately to highly complex and multi-faceted.
May provide guidance / direction to others within own area of expertise.
Accountabilities are moderately complex and performed under management guidance.
Generally reports to a Manager or Senior Manager.
Undergraduate degree or Technical Certificate
5-7 years related experience
Hands-On experience and proficiency with Informatica
Experience in a technical lead role managing both on-site and offshore resources developing ETL processes via Informatica
Proven hands-on experience utilizing SQL, Oracle PL/SQL and SQL Loader, Microsoft DTS and T-SQL, VBScript, and Perl, DOS or UNIX shell scripting for manipulating large volumes of data to and from enterprise systems, as well as experience manipulating flat-files, EBCDIC to ASCII conversion, and non-relational data
Experience with Web development and Web Services is a plus.
Experience with FSLDM (Financial services logical data model)