Job Details:

SUMMARY: The Lead Data Modeler is responsible for the development of high performance, scalable enterprise data models on cloud platform. Should possess strong SQL skills with excellent data modelling skills. Needs to be well versed in the Kimball methodology. Should participate in various activities throughout the systems development lifecycle. Participate in support activities, involve in POCs and present the outcome in acceptable manner. Also responsible for analyzing, architecture, designing, programing and debugging existing/new products to be developed and also mentoring team members. Taking ownership and demonstrate high professional and technical ethics including a consistent focus on emerging and predominant technologies that help the organization.

 

Essential Duties and Responsibilities:

10+ years of work experience in data modeling or engineeringDefine, design, implement enterprise data models.Build Kimball compliant data models in Analytic layer of data warehouseBuild 3rd normal form compliant data models in hub layer of data warehouseTranslate tactical/strategic requirements to ensure effective solutions which meet business needs.Demonstrated ability to take ownership of initiatives and comfortable seeking help.Participate and provide consultation on complex initiatives.Comfortable tackling new problems and learning along the way.Review specifications and coach to ensure consistency in approach and use.Research improvements in coding standards, participate in code reviews.Refactor code to improve testability and maintainability when needed.Perform detailed technical design, development and unit testing of custom applications and data flows in the context of projects, releases and production support.Deliver high quality code for features and bug fixes.Demonstrated ability to effectively adapt to changing technology.Mentor and coach the team members

Requirements:

Technical Skills: Hands on experience in SQL & Query optimization, working on RDBMS and Data Warehouse (ER and Dimensional modeling)Experience Modeling data into star schemas using the Kimball methodologyExperience Modeling data into 3rd normal formExperience in Agile methodologyExperience with CICD frameworks and common DevOps practicesExperience working in an onsite-offshore modelAwareness about the Metadata, Data Quality and Governance needs of Data and Analytics platforms

 

Soft Skills:

Strong Leadership, analytical, engineering, problem solving, presentation and communication skillsAbility to work with a broad group of team members with diverse backgroundsAbility to take a decision and articulate back to leadership as well as business teamsAbility to guide other team members through a complex problem or deliverable

Education: Bachelor’s degree in Computer Science, Information Systems or other technical area (Preferably B.E in Computer Science/Information Tech)

Nice to have skills:

Apache Spark PythonExperience with graph databaseExperience in data identification, ingestion, transformation, and consumption related workGood knowledge of Data visualizationSap Enterprise S/4 HANA FamiliarityProgramming Language Skills (Python, NodeJs, Unix Scripting)Experience on GCP Cloud Ecosystem (Big Query, DataFlow, Airflow, Cloud Storage and equivalent tools on other Cloud solutions, design/build data services)

​Experience in all aspects of software engineering, during these deliverables: Define, architect, build, test, and deploy

Relocation Assistance Eligible:

No

Work Shift:

Tyson is an Equal Opportunity/Affirmative Action 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.