Senior Data Analyst - SQL/Python (5-10 yrs)

JOB OVERVIEW :

We are looking for a Lead Data Analyst to join our data team. This is a hands-on technical role. Minimum 6 years Experience with Shell Script and SQL (T-SQL/PostgreSQL/OracleSQL) is essential. The data analyst will follow an agile iterative development methodology with a focus on innovation, data quality, user value, and robust data analysis.

WHAT YOU WILL DO :

- Build and test metrics using SQL data-stores.

- Build, test and deploy reports and interactive dashboard, leveraging the same metrics.

- Focus on visualization for effective report generation, revealing a clear data story.

- Process, cleanse, and verify data-integrity for analysis.

- Work closely with the USA team to collect and process data on the web crawler software.

- Build analysis reports for various tests and production runs on the web crawler software.

- Interpret data and analyze results using statistical techniques, and provide ongoing reports.

- Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

- Acquire data from primary or secondary data sources and maintain databases/data systems.

- Identify, analyze, and interpret trends or patterns in complex data sets.

- Filter and "clean" data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.

- Work with management to prioritize business and information needs.

- Locate and define new process improvement opportunities.

- Handle Data Analysis team.

REQUIRED SKILLS & QUALIFICATIONS :

- Min 6 year and above experience

- Strong T-SQL OR PostgreSQL OR Oracle SQL Skills.

- Strong Microsoft Office Skills especially Word and Excel

- Experience with scripting Language: Shell

- Skilled at queries, report writing and presenting findings.

- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

- Ability to write comprehensive reports.

- Processing confidential data and information according to guidelines.

- Supporting the data warehouse in identifying and revising reporting requirements.

- Supporting initiatives for data integrity and normalization.

- Providing technical expertise on data storage structures, data mining, and data cleansing.

- Identify areas to increase efficiency and automation of processes.

- Monitor and audit data quality.

- Ability to deal with high-volume data under tight deadlines.

- Create data dashboards, graphs and visualizations.

- Strong verbal and written communication skills.

- Ability to work with little or no supervision.

- Ability to work calmly under pressure.

- Ability to work as a strong team player

PREFERRED SKILLS & QUALIFICATIONS :

- Knowledge of data processing, database programming and data analytics.

- Robust data analysis domain knowledge.

- Ability to understand various data structures and common methods in data transformation.

- Knowledge of scripting languages such as Python, Shell/Sed/Awk.

- Exceptional problem solving and data analysis skills.

- A high degree of reliability, flexibility, and adaptability while working under pressure.

- Strong verbal and written communication skills.

- Detail oriented with excellent follow-up skills.

- A Bachelor's degree in Technology

- Master's degree in Computer Applications