Job Title: Data Modeler
Location: Chicago, IL - Onsite
Job Description
To succeed in this role, you must be able to conceive and portray the data picture. The ideal candidate will have a deep understanding of multi-dimensional and canonical design, proven experience in data modeling using Power Designer, with excellent analytical, communication, and problem-solving abilities.
Responsibilities:
- Design and implement effective and scalable database solutions and models to store and retrieve organization data.
- Create and maintain conceptual and physical data models that accurately represent the organization's data.
- Implement data warehouse architecture standards, processes, and methodologies to ensure the integrity and accuracy of data.
- Collaborate with stakeholders and cross-functional teams to gather requirements and design data models that meet the needs of the business.
- Ensure data quality and integrity within the data warehouse and data marts.
- Responsible for the architecture, modeling, design, development, testing, implementation, and maintenance of the ETL, procedures and structures which populate and grow our databases, data marts and tables.
- Provide direction to fellow ETL developers on solution design and implementation. Ensuring standards are being followed.
- Monitor system performance by performing regular tests, troubleshooting, and integrating new features.
- Guide and coach staff members on standards, guidelines, best practices, and adherence to set standards.
Job Qualifications:
- In-depth understanding of multi-dimensional and canonical design.
- 5+ years of data modeling experience utilizing the Power Designer tool.
- 7+ years of experience in architecting and building medium to large scale enterprise data warehouses and data marts.
- Strong experience with Microsoft SQL Server, Azure Data Warehouse, and Snowflake.
- Proven experience implementing data warehouse architecture standards, processes, and methodologies.
- Able to hit the ground running with a can-do attitude.
- Good written and verbal communication skills.
- Bachelor’s degree in Computer Science, Computer Engineering or relevant field.