Senior IT Data Modeler MXT

Job Details:

The Senior IT Data Modeler is expected to design enterprise-wide data models that ensure data consistency and align with business processes. They lead data modeling initiatives and mentor a team of data modelers, providing expert guidance and training. This role involves developing data strategies that support the organization's long-term objectives, designing complex data architectures, and implementing comprehensive data governance principles. They are skilled in writing and optimizing complex SQL queries, utilizing indexing and caching strategies, and understanding the nuances of dimensional and multi-dimensional modeling. Additionally, they maintain meticulous documentation of data models, schema descriptions, and metadata.
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, and optimizing 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 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 that align with business needs and support long-term data strategies.
• Expertise in designing data models that cover the entire enterprise, ensuring data consistency and alignment with business processes.
• Develop and execute data strategies that align with the organization's business objectives and long-term data needs.
• Mastery of complex data modeling techniques, including handling intricate relationships, multi-dimensional modeling, and advanced normalization.
• Perform other assigned job-related duties that align with our organization's vision, mission, and values and fall within your scope of practice.
Qualifications:
Education: Bachelor's Degree or relevant experience.
Preferred Certification(s): Any relevant IT Certification.
Experience: 3+ 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:
• Communication: Effectively explaining complex data concepts to technical and non-technical stakeholders.
• Leadership: Mentoring junior data modelers and guiding data modeling initiatives.
• Analytical Thinking: Solving complex data challenges and optimizing data architectures.
• Attention to Detail: Ensuring accuracy in data models, documentation, and metadata.
• Collaboration: Working effectively with cross-functional teams to align data models with business processes.
• Adaptability: Staying current with evolving data technologies and methodologies
• Strategic Thinking: Developing data strategies that support long-term organizational objectives.
• Problem-solving: Addressing complex data modeling challenges and optimizing query performance.
• Time Management: Balancing multiple projects and priorities effectively.
• Continuous Learning: Keeping up-to-date with data modeling and tool advancements.

Relocation Assistance Eligible:

Work Shift:

Tyson is an Equal Opportunity Employer. All qualified applicants will be considered without regard to race, national origin, color, religion, age, genetics, sex, sexual orientation, gender identity, disability or veteran status.