Deskripsi pekerjaan Datawarehouse Developer Avows Technologies
Data Warehouse Developer Job Description:
- Consolidate and optimize available data warehouse infrastructure.
- Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients.
- Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked.
- Design and implement ETL processes and data architecture to ensure proper functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard.
- Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
- Carry out monitoring, tuning, and database performance analysis.
- Perform the design and extension of data marts, meta data, and data models.
- Ensure all data warehouse architecture codes are maintained in a version control system.
Data Warehouse Developer Requirements:
- Possess Diploma or Bachelor’s degree in an analytical related field, including information technology, science, and engineering discipline.
- Five years or more experience performing data warehouse architecture development and management.
- Remarkable experience with technologies such as SQL Server 2008, as well as with newer ones like SSIS and stored procedures.
- Exceptional experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database.
- High proficiency in dimensional modeling techniques and their applications.
- Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel.
- Several years working experience with Tableau, SportFire, TIBCO, QlikView, MicroStrategy, Information Builders, and other reporting and analytical tools.
- Working knowledge of SAS and R code used in data processing and modeling tasks.
- Remarkable experience with Microsoft Azure and Amazon AWS computing platforms.
- Strong experience with Hadoop, Impala, Pig, Hive, YARN, and other “big data” technologies.
