BI Analyst

National Society for Black Engineers; Bogotá; Presencial; COP 60.000.000 - 90.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Volunteer Paid Time off

Employee Assistance Program

Wellbeing programs

On-demand learning resources

Descripción de la vacante

Rockwell Automation is seeking a BI Analyst to design, build, and maintain world-class reporting using Power BI. You will model data, create dashboards and analyses, and work with data sources such as Azure SQL and SQL Server.

You’ll report to the Team Lead - BI & Data Analytics and collaborate with the Enterprise Analytics group to ensure standards are followed. The ideal candidate has a Bachelor's degree, 3+ years in analytics or BI, and advanced English.

Formación

• Bachelor's degree.
• Minimum 3 years of experience in business analytics or BI.
• Advanced English.

Responsabilidades

• 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 requirements into high-level technical specifications and design.
• Develop 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 dimensional modeling (star schema) and semantic model design.
• Prepare, ingest, cleanse, and maintain data in the data warehouse for efficient Power BI delivery.
• Collaborate with Enterprise Analytics to stay aligned with standards.
• Identify gaps and work with data engineering and solution architects to deliver finished solutions.

Conocimientos

Advanced English

Business analytics

Educación

Bachelor's degree

Herramientas

Power BI

SQL Server

Azure SQL

Azure Synapse

Databricks

Python

R

Descripción del empleo

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.
• Minimum 3 years of experience in business analytics or business intelligence.
• Advanced English

The Preferred - You Might Also Have

• 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.