Data Warehouse Modeler

Join our team at Urban Planning Association and be a part of a dynamic and innovative organization. We offer a competitive salary, benefits package, and opportunities for professional growth and development. If you are a passionate Data Warehouse Modeler with a strong understanding of data modeling and a desire to make a meaningful impact, we would love to hear from you.

Job Title: Data Warehouse Modeler

Company: Urban Planning Association

Location: Washington, District of Columbia, United States

Employment Type: Full-time

Salary: Based on experience

About the Role: We are seeking a skilled and experienced Data Warehouse Modeler to join our team at Urban Planning Association. As a Data Warehouse Modeler, you will play a crucial role in designing and maintaining our organization's data warehouse systems. You will work closely with our data engineers, architects, and business analysts to understand the data needs of our company and create effective data models to support the organization's business objectives.

Key Responsibilities:

• Design and develop data warehouse models that meet the business requirements of the organization.
• Collaborate with data engineers to ensure the effective implementation of data integration processes.
• Work closely with business analysts to understand data requirements and translate them into data warehouse structures.
• Conduct data profiling and analysis to identify data quality issues and provide recommendations for improvement.
• Develop and maintain data transformation rules and data mapping documents.
• Create and maintain data warehouse documentation, including data dictionaries, data flow diagrams, and data lineage.
• Perform data validation and testing to ensure the accuracy and completeness of data models.
• Identify and recommend improvements to existing data warehouse policies, procedures, and processes.
• Stay up-to-date with the latest data warehouse technologies, tools, and techniques and make recommendations for their adoption.
• Provide technical support to end-users and troubleshoot data warehouse-related issues.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 3 years of experience as a Data Warehouse Modeler or a similar role.
• Strong hands-on experience with data modeling tools such as ER/Studio, ERwin, or ER/Studio Data Architect.
• In-depth understanding of data modeling concepts, including dimensional modeling, star schemas, snowflake schemas, and normalization.
• Proficient in SQL and experience with ETL tools like Informatica, Talend, or SSIS.
• Experience with relational databases such as Oracle, SQL Server, or MySQL.
• Knowledge of data warehouse design principles and best practices.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration skills.
• Ability to work independently and in a team environment.
• Proven track record of delivering high-quality work within tight deadlines.
• Knowledge of data governance and data quality frameworks is a plus.

Apply now and join us on our exciting journey towards success!.