Hi,
We are looking for a *Sr. Data Analyst* in the location *NYC, NY*. *Job Description* *Sr. Data Analyst* *NYC, NY* *6 months* *Job Description* A senior data analyst is required to develop, design, construct, and maintain data structures, models and physical databases. The data analyst will collaborate across stakeholders (product managers, project managers, business analysts, and testers) to elicit and analyze requirements. The analyst will analyze, design, tune, maintain and test data and database solutions. • Meet with business stakeholders and other technical team members to gather and analyze application data requirements. • Design and build data solutions to satisfy application (business and technical) requirements. • Perform data analysis where requirements need to be derived from available documentation, user interviews, and file specifications/samples. • Perform data analysis activities (data profiling, creation of data dictionaries, data transformation rules, integration requirements) • Support and apply data standardization policies • Responsible for requirements gathering and BRD/SRD preparation. • Has thorough knowledge of the Software Development Life Cycle. • Conducts reviews of the test Plan and test Data. • Ensures that expected application performance levels are achieved. • Contributes to defining time tables and project plans. . Analyze and document upstream financial and risk measures . Validate new datasets for completeness and correctness . Coordinate acceptance testing and production roll-out . Provide custom datasets for analysis and ad hoc reporting . Participate in control reporting and data governance development . Help to enforce data integrity . Research and document data mapping from source to target systems . Assist with data modeling as necessary . Work closely with Project Management, Data Architects, Data Modelers, other analysts and ETL Development Team to design and implement the requirements for the Enterprise Data Warehouse. . Work closely with business users to verify data requirements and access needs. *Key Responsibilities:* 30% - Perform Data Analysis 20% - Perform Data Profiling 10% - Apply Data Standards 20% - Gather Data Requirements 20% - Assist developers with database activities *Key Competencies/Skills:* 30% Data Analysis 20% Data Profiling 20% Data Governance / Management 20% Communication with management, development teams, vendors and systems administrators 10% SQL performance tuning *Qualifications* *Experience/Knowledge Requirements* *Preferred Previous Work Experience:* • 6-8+ years of experience in data analysis required; experience in the securities or financial services industry is a plus • Minimum 5 years’ experience working with Oracle, SQL Server Databases, and SQL • Minimum 5 years of experience gathering business requirements • Experience in both design and develop of enterprise level operational and data warehouse database systems • Experience in both design and develop of enterprise level operational and reporting systems and dashboards • Strong database design experience and experience with data modeling tools like Erwin etc. • Experience leading design sessions • Experience leading business requirements sessions • Mathematical background with knowledge of pricing, risk calculation, etc. • Solid experience with SQL, R programming experience a plus. • Excellent communication and presentation skills • Must be a self-starter that does not require direct supervision • Have a strong fundamental understanding of project management, specifically in the SDLC and Agile methodologies • Have expert level skills in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio • Excellent written and verbal communication skills to enable them to: • Facilitate meetings with technical peers regarding the requirements definition • Communicate effectively with business, vendor, and project management staff • Participate in ongoing decisions regarding study design, data collection, data analysis, and Methodology *Required Skills/Abilities* Preferred Education/Licenses/Certifications/Registrations: Bachelor's degree in quantitative / computer science or a related discipline, or equivalent work experience required Other Skills, Abilities and/or Training: SQL / R / Data Analysis certifications Erwin or other Data Modelling tool experience Ability to write PL/SQL scripts to perform data refreshes from one system to another or run data queries Ability to identify and map source and target data fields Ability to work independently or as part of a team Thanks & Regards, Ram | IT Technical Recruiter Technology Resource Group Inc. 3736 Hillsdale Court Santa Clara, CA 95051 Office: 408-709-1760 Ext: 723 Fax: 408-213-8316 r...@tresourceinc.com | www.tresourceinc.com -- You received this message because you are subscribed to the Google Groups "RESOURCE OPTIONS, INC." group. To unsubscribe from this group and stop receiving emails from it, send an email to resourceoptions+unsubscr...@googlegroups.com. To post to this group, send email to resourceoptions@googlegroups.com. Visit this group at http://groups.google.com/group/resourceoptions. For more options, visit https://groups.google.com/d/optout.
