Business Intelligence Data Warehouse Consultant
As a BI & DWH Specialist, you will be responsible for designing, developing, and maintaining our data warehouse and business intelligence solutions. You will work closely with business stakeholders to understand their data needs and deliver actionable insights.
Key Responsibilities:
1. Data Warehouse Design and Development:
Design and implement a robust data warehouse architecture.
Develop ETL processes to extract, transform, and load data from various sources into the data warehouse.
Ensure data quality and consistency through data profiling and cleansing techniques.
2. Business Intelligence Development:
Design and develop interactive dashboards and reports using BI tools (e.g., Power BI, Tableau) to provide insights into key business metrics.
Collaborate with business users to understand their reporting needs and translate them into actionable insights.
Create data visualizations that are easy to understand and interpret.
3. Data Analysis and Reporting:
Conduct in-depth data analysis to identify trends, patterns, and opportunities.
Prepare regular and ad-hoc reports to support decision-making.
Provide data-driven insights to improve business performance.
4. Data Governance:
Establish and maintain data governance policies and procedures.
Ensure data security and privacy compliance.
Monitor data quality and accuracy.
Qualifications and Experience:
1. Bachelor's degree in Computer Science, Information Systems, or a related field.
2. 6+ years of experience in data warehousing and business intelligence.
3. Strong proficiency in SQL and data modeling techniques.
4. Experience with BI tools (e.g., Power BI, Tableau).
5. Knowledge of data warehousing concepts, ETL processes, and data mining techniques.
6. Strong analytical and problem-solving skills.
7. Excellent communication and interpersonal skills.
8. Experience in Oracle Warehouse Builder is required.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Consulting, Information Technology, and Engineering
Industries
IT Services and IT Consulting, IT System Operations and Maintenance, and IT System Data Services
#J-18808-Ljbffr