Marketing Analyst - SAS/Analytics - BFSI

A Well known Investment Firm is looking for Marketing Analyst for Gurgaon Location;

Salary : 8-10 Lacs;Work Exp : 3-5 years;

Job Description:

The Marketing Analytics team uses multiple sources of data – both internal and external. Where possible, it uses internal data warehouse but in many cases the team needs to develop their own temporary data structures merging internal data with external or merging internal data from multiple internal systems. This requirement is going to increase as the scope of work done and hence the range of data used expands. The primary responsibilities of this role include:

- Developing and maintaining data structures in SAS and other internal systems that can support analysis requirements of the team

- Designing and executing data extraction queries based on self maintained and other internal databases to support team’s requirements for analysis and reporting

- Developing a detailed understanding of FIL’s relevant data architecture and databases including data dictionaries and acting as the team’s subject matter expert on these data structures

- Liaising with Technology, Business Finance and other such stakeholders of internal data and technical teams of external data vendors to represent the team’s interests

Experience and Qualifications

Core and soft skills - Practised abilities, capabilities and behaviours

- Well-versed in data profiling, data manipulation and data analysis. Ability to write complex queries and sample/select large data sets from disparate data sources using SAS, SQL, Access, BI (Business Objects),or other tools. Familiarity with one or more mainstream RDBMS systems is a must.

- Ability to document business needs via user use cases, data flows, logical data models, corresponding ETL and BI requirements. This includes documenting current state data structures and design new data structures.

- Performs complex analytical and technical deep dive in relation to data intensive problem solving

- Awareness of latest tools and techniques in data warehousing and data mining

- Ability to liaise with a diverse set of stakeholder including technical teams and users on data related topics

- Must be able to work to tight deadlines without prejudicing data integrity. Must be open-minded and willing to adapt to accommodate the reasonable needs of others’.

- Must have strong time management and organisational skills.

- Must have strong numerate skills which must be rigorously applied.

Technical expertise - specialist knowledge, technical skills and other areas of expertise (e.g. process, domain and application knowledge)

Work Experience

Required

- 3-5 years related work experience in software development/ database design especially in a data warehousing and data mining environment

Preferred

- One year work experience using SAS Business Intelligence or two years experience using Base SAS.

Education

Required

- Bachelor's/Masters degree in Eng/ MCA/ Advanced Technical course in Database design and SQL programming

Preferred

- Previous big data experience from a technical standpoint

- Knowledge of SAS or SQL would prove helpful

- Demonstrated proficiency using standard office software and depending on area of specialization, may include advanced software applications to create reports, query and control languages, network servers, and experience providing technical support for desktop software.

- Application/report and database development.

- Systems analysis techniques and the systems development life cycle.

- Installation, testing, and evaluation processes in relation to new and existing software.