Description

Role and Responsibilities

· Act as a liaison between business teams and software team to gather, analyze and document data requirements.

· Understand business requirements and develop data models usable by users and efficient for ETLs

· Organize, design, develop ETL workflows from heterogeneous data sources and dashboards for scalable, refreshable analysis and reporting

· Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems.

· Supporting analysts with data queries and dashboard creation used for business decision making and performance monitoring.

· Writes technical documentation (design specifications, data model diagrams, data flow diagrams, Configuration Management, Production Support documents etc.,).

· Adhere to development standards, time tracking, policies and change management process

· Monitors developed ETL processes in production, and trouble-shoots production problems when they occur.

Qualifications/Competencies:

· Minimum 5 years of experience as a data analyst or developer.

· Proven experience as a BI Developer or Data Analyst

· Understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework

· Proficient knowledge in SQL queries, SSIS

· Working knowledge of Microsoft Power BI, Tableau.

 

Skills/attributes:

· Must have ability to translate user requirement to technical implementation and break down to tasks

· Strong verbal communication skill and team collaboration consensus required

· Analytical mind with a problem-solving aptitude

Ability to work independently and with a team on simultaneous tasks in a fast-paced environment

Education

Bachelor's degree in Computer Science