Job Description :
SQL Data Analyst/ETL

Location: San Mateo, CA

Duration: 6 month CTH





The Data Analyst/ETL is responsible for the implementation and the continued evolution of data queries, data stores, data warehouses, and data marts used for business analytic reporting.

The data analyst will collaborate closely with both technical and business analysts to design, test, enhance and maintain these systems to propel business productivity. He/She also supports appropriate planning for current state and future technology objectives.


Knowledge/Skills/Abilities:

Requires broad knowledge and experience in data warehousing (SQL, ETL, ODS, star schemas, OLAP, dimensional modeling, data profiling, data quality, etc and relational database experience; knowledge preferably MS SQL Server.
Design and develop source to target mappings to support ETL process.
Design data views; help develop reporting data mart; provide support to reporting teams.
Demonstrated experience working with users to identify information system needs.
Experience identifying potential solutions, designing, developing, documenting, testing, and maintaining databases/applications required.
Ability to communicate effectively and work collaboratively with disparate clients.
Ability to independently lead or facilitate meetings.
Ability to identify potential solutions and take initiative.
Must be able to work independently and within a team and handle sensitive data professionally.
Must be able to work on multiple projects concurrently and work within deadlines.
Help verify and reconcile data for accuracy and consistency using data profiling tools.


Qualifications:

Bachelor’s degree
Minimum 8 years’ experience in data analytics and reporting
Experience working with AGILE methodologies
Experience with MS SQL Server and SAP BusinessObjects Data Services (including Data Services Designer) experience strongly preferred
Experience with Qlikview, Cognos front end reporting tools, a definite plus