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
Bachelor's degree in Computer Science