Senior BI Analyst
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 BI Analyst is responsible for designing, building, delivering, and maintaining world-class reporting for all areas of the business using Power BI. This role involves modeling data and designing reports, dashboards, and analysis. It uses tools like Power BI, Data Flows, and in some cases SQL Server or Azure Analysis Services. The goal is to create custom visualizations and dashboards.
You will report to the Team Lead - BI & Data Analytics
Main responsibilities:
- Design Power BI dashboards, reports, and semantic data models for enterprise use
- Gather business requirements from stakeholders at multiple levels and translate into scalable BI Solutions
- Translate our needs into high-level technical specifications and design
- Develop an understanding of multiple business processes, data sets, and BI deliverables.
- Build and optimize data models using Power Query, DAX, SQL and relational data principles
- Apply best practices in dimensional modeling (star schema) and semantic model design
- Prepare, ingest, cleanse, and maintain data in the data warehouse for efficient delivery to Power BI.
- Work with the Enterprise Analytics team (DA&I) to stay up-to-date with enterprise standards.
- Critically evaluate information gathered from multiple sources, reconcile and identify gaps, uncover unmet needs, and work with data engineering and solution architects to create a finished solution.
The Essentials - You Will Have
- Bachelor's degree.
- Advanced English
The Preferred - You Might Also Have
- Minimum 5 years of experience in business analytics or business intelligence.
- Experience with SQL, relational databases, and dimensional modeling (star schema)
- Experience in Power BI development, including DAX, Power Query, and data modeling
- Experience working with enterprise data sources (Azure SQL, SQL Server, Databricks)
- Translate our requirements into analytical solutions and applicable insights
- Experience working in data governance-aligned environments
- Experience in Customer Experience business functions especially Customer Success or related teams.
- Working knowledge of BI and data warehouse concepts and terminology.
- Experience building complex reports in Power BI, Tableau, or similar platforms.
- Experience with analytical programming languages such as SQL, Python, or R.
- Can while still achieving deadlines.
- Detail-oriented person who is passionate about quality and enthusiastic about new technology.
- Familiarity with basic AI functionality as a resource for modelling and building reports that can be queried by AI
We will give priority consideration to candidates with prior experience specifically using Power BI to build complex, interactive models. You should also have experience publishing Power BI reports to the Power BI service for reporting consumers, and working with Azure SQL Data Warehouse/Azure Synapse.
This is a summary of the position's responsibilities and does not reflect the entire scope of work expectations.
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.
We match your volunteer hours or personal cash donations to an eligible charity with a charitable donation through its volunteer and donation matching program.
- Employee Assistance Program.
- Personalized wellbeing programs through our OnTrack program
- On-demand digital course library for professional development... and other local benefits!
Rockwell Automation's hybrid policy expects employees to work at a Rockwell location at least on Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.
We believe that employee diversity is an important element of our common future. We provide opportunities for talent growth with the entire organization. We support equality by celebrating the individuality of every person, regardless of their origin and identity. We appreciate the unique cultural pattern and variety of experiences in each of us. We invite all who want to join and change the world of Our organization.
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.