Data Warehousing Consultant
PB Consulting
Washington, DC
Posted On: Feb 08, 2024
Posted On: Feb 08, 2024
Job Overview
Required Skills
- Data Modeling
- Database
- ETL
- Azure ADF / SAP BODS
- SQL
- Python
- Data Warehousing
Job Description
Job Description
- Candidate Should have hands-on experience on working in Cloud Based Datawarehouse Solution with below capabilities:
- Data Modeling: Design and implement data models based on business requirements.
- Optimize and normalize database structures for efficient data storage and retrieval.
- Database Development: Develop and maintain database schemas, tables, indexes, and views.
- Write efficient and optimized SQL queries for data manipulation and retrieval.
- ETL (Extract, Transform, Load)
- Design and implement ETL processes to extract data from various sources, transform it as needed, and load it into the target databases
- Experience on any ETL tools like Azure ADF/SAP BODS
- Data Integration: Integrate data from diverse sources and systems to create a unified view.
- Implement data integration solutions for real-time or batch processing.
- Extensive experience in data analysis using SQL, Python
- Design and develop data warehouses to support business intelligence and reporting needs.
- Optimize data warehouse performance and ensure scalability.
- Data Security: Implement and maintain security measures to protect sensitive data.
- Monitor and audit data access to ensure compliance with security policies.
- Performance Tuning: Identify and resolve performance issues in databases and data processing pipelines.
- Optimize queries and processes for better performance.
- Collaboration: Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders
- Communicate effectively to understand and address data requirements.
- Continuous Learning: Stay updated on industry trends, emerging technologies, and best practices in data development.
- Problem Solving: Identify and resolve data-related issues and challenges.
- Troubleshoot and debug issues in databases and data processing systems.
Job ID: PC240045