Lead IT Data Modeler

• Data Modeler

Lead IT Data Modeler

The
Lead IT Data Modeler takes a leadership role in crafting data models andarchitectures that meet current business needs and are scalable for futurechallenges. They provide advanced mentorship to junior and senior datamodelers, fostering a culture of continuous improvement and innovation in datamanagement. This role demands deep expertise in query optimization, executionplans, and complex SQL for large datasets. They are proficient in variousdatabase systems like MySQL, PostgreSQL, Oracle, and Microsoft SQL Server andemploy version control systems such as Git to manage changes efficiently. TheLead Data Modeler also integrates data engineering practices like ETL, joborchestration, and monitoring to enhance data transformation processes,ensuring robust data systems that support critical business functions.

Essential
Duties and 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, andoptimizing database queries.

Proficiency
in the fundamentals of data modeling, including entity-relationship diagrams(ERDs), data flow diagrams, and dimensional modeling.

Strong
documentation skills to maintain 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 andrelated code.

Proficient
in complex SQL queries, common table expressions, and optimization techniquesfor 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 modelinginitiatives.

Ability
to design comprehensive data architectures that align with business needs andsupport long-term data strategies.

Expertise
in designing data models that cover the entire enterprise, ensuring dataconsistency and alignment with business processes.

Develop
and execute data strategies that align with the organizations businessobjectives and long-term data needs.

Mastery
of complex data modeling techniques, including handling intricaterelationships, multi-dimensional modeling, and advanced normalization.

Lead
and mentor a team of data modelers, providing guidance, training, andoversight.

Develop
and execute a strategic plan for data modeling initiatives, aligning them withthe organizations vision.

Perform
other assigned job-related duties that align with our organizations vision,mission, and values and fall within your scope of practice.

Qualifications:

Education:
Bachelors Degree or relevant experience.

Preferred
Certification(s): Any relevant IT Certification.

Experience:
5+ years of relevant and practical experience.

Special
Skills:

Proficiency
in designing comprehensive data models that align with business processes.

Advanced
knowledge of SQL, data warehousing, and dimensional modeling.

Skills
in data governance, cataloging, and stewardship.

Experience
in enterprise-level data strategy and management of complex data architectures.

Soft Skills:

Visionary
Leadership: Crafting scalable foundational data models for current and futurebusiness needs.

Mentorship:
Providing advanced guidance to both junior and senior data modelers

Innovation:
Fostering a culture of continuous improvement in data management practices.

Strategic
Communication: Articulating complex data strategies to executive stakeholders.

Change
Management: Guiding teams through evolving data technologies and methodologies.

Conflict
Resolution: Addressing challenges within data modeling teams andcross-functional collaborations.