Rockwell Automation is a global technology leader focused on helping the world’s manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing companies that help feed the world, provide life-saving medicine on a global scale, and focus on clean water and green mobility - our people are energized problem solvers that take pride in how the work we do changes the world for the better.
We welcome all makers, forward thinkers, and problem solvers who are looking for a place to do their best work. And if that’s you we would love to have you join us!
Job Description
The Data Analyst will partner with business stakeholders to understand and align business strategies and requirements with organizational priorities. The role requires strong collaboration with both business and technology teams to translate high-level business requirements into clear functional, non-functional, and data requirements.
A key focus of this role is to design and build data models from scratch , ensuring that business requirements are accurately converted into scalable and efficient data structures. The candidate will be responsible for defining data models (fact/dimension, star/snowflake schemas), establishing relationships, and enabling high-quality data solutions for downstream consumption.
The individual will work closely with design and development teams to ensure these data models are effectively implemented into technical solutions that meet business needs. Strong expertise in data modeling and SQL is mandatory , while visualization skills are considered secondary.
- Gather and validate business, technology, and data requirements to define scope, success criteria, and key metrics
- Translate business requirements into data modeling requirements, including entities, relationships, and data structures
- Design and build logical and physical data models from scratch (fact/dimension, star/snowflake schemas)
- Define data granularity, hierarchies, and semantic layers to support analytics and reporting needs
- Work closely with business stakeholders and architects to ensure data models align with enterprise data architecture
- Ensure data quality, consistency, and governance, including metadata definition and approval
- Review and optimize data models for performance, scalability, and maintainability
- Support production issues by analyzing data/model design gaps and providing improvements
- Lead discussions with stakeholders to align data model design with 3–6 month business priorities
- Collaborate across teams to identify dependencies and ensure smooth delivery of data solutions
- Use modeling and prototyping tools (Power BI or others) only to validate data models and business logic (not as primary responsibility)
- Bachelor’s degree in Computer Science, Management Information Systems, or a related field
- Proven experience in designing and developing logical and physical data models (fact/dimension, star/snowflake schemas)
- Strong experience building data models from scratch (requirement analysis to implementation)
- Strong problem-solving and analytical skills
- Strong hands-on experience in data modeling (design + build from scratch)
- Expertise in SQL
- Deep understanding of:
- Fact & Dimension modeling
- Star vs Snowflake schema
- Data warehousing concepts
- Strong communication and stakeholder management skills
- Experience translating business requirements into data models and technical solutions
- Ability to work across cross-functional teams and challenge design decisions
- Understanding of system design, architecture standards, and data security principles
- Experience with Analytics & Data platforms such as:
- Azure SQL DW, AAS, Power BI
- Python, ADF, ADLS Gen2
- Domain knowledge in Finance processes (GL, Cost Center, Profitability)
- Exposure to SAP systems (ECC, CRM, Hybris)
- Knowledge of planning applications (Hyperion, Enterprise Planning Management)
Important Note :
- Candidates with only visualization / Power BI experience without core data modeling design should not be considered
- SQL + Data Modeling is mandatory (others are optional)
What We Offer:
Our benefits package includes …
- Comprehensive mindfulness programs with a premium membership to Calm
- Volunteer Paid Time off available after 6 months of employment for eligible employees.
- Company volunteer and donation matching programs – Your volunteer hours or personal cash donations to an eligible charity can be matched with a charitable donation.
- Employee Assistance Program
- Personalised wellbeing programmes through our OnTrack programme
- On-demand digital course library for professional development... and other local benefits!
At Rockwell Automation we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right person for this or other roles. Rockwell Automation's hybrid policy aligns that employees are expected to work at a Rockwell location at least Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.
Rockwell Automation’s hybrid policy aligns that employees are expected to work at a Rockwell location at least Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.
