Data Warehouse Designer

If you are passionate about data and enjoy designing and developing data warehouses, we want to hear from you! Join our team and be a part of building a robust and scalable data warehouse that will drive our organization's success.

Position: Data Warehouse Designer

Location: New York, New York, United States

Salary: $100 Per hour

Overview: We are seeking a highly skilled and experienced Data Warehouse Designer to join our growing team. The ideal candidate will have a strong background in data warehousing, database design, and SQL development. As a Data Warehouse Designer, you will be responsible for designing and developing our data warehouse to support the organization's analytics and reporting needs.

Key Responsibilities:

• Design and develop data warehouse solutions to support business intelligence and reporting needs
• Collaborate with cross-functional teams to understand data requirements and translate them into data warehouse design
• Develop logical and physical data models for the data warehouse
• Design and implement efficient data extraction, transformation, and loading (ETL) processes
• Ensure data quality and integrity by implementing data validation and cleansing processes
• Monitor and optimize data warehouse performance
• Troubleshoot and resolve data warehouse issues in a timely manner
• Create and maintain documentation for data warehouse design, processes, and procedures
• Stay updated with emerging trends and technologies in data warehousing and make recommendations for process improvements

Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field
• Minimum of 5 years of experience in data warehousing and database design
• Strong proficiency in SQL and experience with database management systems such as Oracle, SQL Server, or MySQL
• Experience with ETL tools, such as Informatica, Talend, or DataStage
• Familiarity with data warehousing concepts and methodologies, such as Kimball and Inmon
• Knowledge of data modeling techniques and tools, such as ER/Studio or ERwin
• Experience with data visualization tools, such as Tableau or Power BI, is a plus
• Excellent problem-solving and analytical skills
• Strong attention to detail and ability to work with large datasets
• Excellent communication and teamwork skills
• Ability to work in a fast-paced and dynamic environment
• Certification in data warehousing or database design is a plus