Lead IT Data Modeler

As the Lead IT Data Modeler, you will play a crucial role in designing data models and architectures that not only address current business requirements but are also scalable for future challenges. Your primary responsibility will be to provide advanced mentorship to both junior and senior data modelers, fostering a culture of continuous improvement and innovation in data management practices. You must have a deep understanding of query optimization, execution plans, and complex SQL for handling large datasets. Your proficiency should extend to various database systems such as MySQL, PostgreSQL, Oracle, and Microsoft SQL Server, along with utilizing version control systems like Git for efficient change management. Additionally, you will be integrating data engineering practices such as ETL, job orchestration, and monitoring to enhance data transformation processes, ensuring the development of robust data systems that support critical business functions. **Key Responsibilities:** - Proficiency in using and managing relational database systems such as BigQuery, MySQL, PostgreSQL, Oracle, or Microsoft SQL Server. - Knowledge of SQL for querying and manipulating data, including creating, modifying, and optimizing database queries. - Proficiency in data modeling fundamentals, including entity-relationship diagrams (ERDs), data flow diagrams, and dimensional modeling. - Strong documentation skills for maintaining clear and up-to-date data model diagrams, schema descriptions, and metadata. - Familiarity with version control systems like Git for tracking changes to data models and related code. - Proficient in complex SQL queries, common table expressions, and optimization techniques for managing and querying large datasets. - Understanding of data governance principles, data stewardship, and data cataloging. - Skill in optimizing database and query performance, including query execution plans, indexing, and caching strategies. - Capability to mentor junior data modelers and provide leadership in data modeling initiatives. - Ability to design comprehensive data architectures aligning with business needs and long-term data strategies. - Expertise in designing data models covering the entire enterprise for data consistency and alignment with business processes. **Qualifications:** - Education: Bachelor's Degree or relevant experience. - Preferred Certification(s): Any relevant IT Certification. - Experience: 5+ years of relevant and practical experience. **Additional Company Details:** The organization values visionary leadership, mentorship, innovation, strategic communication, change management, conflict resolution, decision-making, emotional intelligence, negotiation, and thought leadership in driving industry best practices in data modeling and architecture. (Note: Relocation assistance is not eligible for this position) In summary, as the Lead IT Data Modeler, you will be at the forefront of crafting scalable data models, providing advanced mentorship, fostering innovation in data management, and designing comprehensive data architectures that align with business needs and long-term strategies.,