Data Warehouse (DW) Developer

Kredit Pintar

View Salaries, Reviews, and more

Job Description

Designing and implementing robust data warehouse architectures that support business requirements
Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository
Creating data models that accurately represent business processes and support analytics
Ensuring the security of the data warehouse and compliance with data governance standards
Optimizing data warehouse performance through indexing, partitioning, and query tuning
Collaborating with business analysts and data scientists to understand analytical needs and deliver appropriate data structures
Writing complex SQL queries for data manipulation and retrieval
Testing and troubleshooting data systems to ensure accuracy and quality of data
Documenting the data warehouse environment and maintaining metadata repositories
Monitoring data warehouse systems to ensure reliability and performance standards are met
Keeping abreast of new technologies and methodologies in data warehousing and big data
Providing support and training to end-users on data warehouse usage and best practices

Minimum Qualifications

Bachelor's degree in Computer Science, Information Technology, or a related field.
Proven experience as a Data Warehouse Developer or similar role.
Strong knowledge of database management systems (DBMS) and SQL.
Experience with data warehousing tools and technologies (e.g., Oracle, SQL Server, Teradata).
Proficiency in ETL tools (e.g., Informatica, Talend, SSIS).
Experience with data modeling and database schema design.
Strong analytical and problem-solving skills.
Excellent communication and collaboration skills.
Detail-oriented with a focus on data accuracy and quality.
Ability to work independently and as part of a team.
Experience with BI and analytics tools (e.g., Tableau, Power BI) is a plus.
Knowledge of data governance and data quality best practices.
Familiarity with data privacy and security regulations.
Experience with cloud-based data warehousing solutions (e.g., AWS Redshift, Google BigQuery) is a plus.
Strong organizational and time management skills.
Ability to manage multiple projects and priorities simultaneously.
Experience with scripting languages (e.g., Python, R) is a plus.
Knowledge of big data technologies (e.g., Hadoop, Spark) is a plus.
Certification in data warehousing or related fields is a plus.