Sr.Staff Engineer – Data Modeler and Analyst

Overview

Sr. Staff Engineer to lead data and analytics strategy for Global Stores within TJX IT, designing and maintaining enterprise data models that support analytics, reporting, operational systems and data governance.

What you'll do

• Design conceptual, logical and physical data models for enterprise data platforms.
• Translate business requirements into scalable data structures and schemas.
• Build mapping documents and document technical requirements.
• Develop dimensional models, data marts and warehouse models for analytical use cases.
• Partner with Data Engineering teams to implement data models in cloud and on-premises environments.
• Define data standards, naming conventions and modeling best practices.
• Collaborate with business teams to understand data requirements and data relationships.
• Support data governance, metadata management and data lineage initiatives.
• Optimize data models for performance, scalability and maintainability.
• Participate in architecture reviews and data platform modernization efforts.
• Ensure compliance with enterprise security and regulatory requirements.
• Lead discussions on design approaches to solving visible, strategic and complex business problems.
• Identify emerging technologies for consideration for new technology direction and implement proof of concepts.
• Maintain broad knowledge of the business applications and services that comprise a given technical domain.
• Provide technical subject matter expertise related to the business applications in a given technical domain.
• Act in a Lead Engineer capacity for medium to large initiatives, prioritizing and assigning tasks, providing guidance and resolving issues.
• Design, code, test, deploy and support working software or technology components, working collaboratively with architects and other engineers.

What you'll need

• Bachelor's Degree or equivalent engineering skillset, training or work experience in a relevant technical domain.
• 14+ years of strong experience in data modelling and database design.
• Strong knowledge of relational, dimensional and data warehouse modeling techniques.
• Experience with SQL and database platforms such as SQL Server, Oracle, Snowflake, Databricks or PostgreSQL.
• Experience with data modeling tools such as ERwin, ER/Studio, SAP PowerDesigner or similar.
• Strong understanding of ETL/ELT processes and data integration concepts.
• 14+ years' experience in any combination of: Data Modeling, Data Warehouse Design, SQL and PL/SQL, Database Architecture, Data Governance, Metadata Management, Dimensional Modeling, Analytical Thinking, Stakeholder Management, Problem Solving.
• Tools: ERwin, ER/Studio, Power Designer.
• Strong communication and influence skills.
• Solid team leadership with mentorship skills.
• Shows a positive, open-minded and can-do attitude.

Nice to have

• AWS, GCP, Azure or Databricks.
• Python, PySpark or Fabric.

Details

• Location: Salarpuria Sattva Knowledge City, Inorbit Road, Hyderabad, India (APAC Home Office).
• Works closely with global teams across North America, Europe, Asia and Australia.