BI Consultant for e - Emphasys ERP focused on analytics systems implementation. Collaborating with teams to design data - driven processes and reporting applications.
About the role
- Senior Data Analyst (PowerBI) developing advanced dashboards and reports. Working on ETL processes and collaborating with business areas in Contagem, Brazil.
Responsibilities
- Develop advanced dashboards and reports in Power BI using DAX to create complex measures and data modeling.
- Create and optimize queries in SQL Server and PostgreSQL, ensuring performance and efficiency in data access.
- Develop and maintain ETL processes and data pipelines using Apache Airflow for automation and integration.
- Work directly with business units and executive leadership, translating requirements into technical solutions and presenting strategic insights.
- Document business rules, assumptions, and calculation methodologies, maintaining traceability and data governance.
- Participate in executive meetings to align on KPIs and corporate metrics.
- Ensure the quality and consistency of data presented in corporate reports and dashboards.
Requirements
- Strong experience with advanced Power BI, developing complex dashboards and using gateways.
- Full proficiency in DAX for creating measures, calculated columns, and tables.
- Advanced SQL knowledge with experience in query optimization and performance tuning.
- Experience with SQL Server and PostgreSQL, including administration, stored procedures, and indexing.
- Experience in development and data wrangling using Python.
- Experience developing and maintaining ETLs and data integration processes.
- Proven experience interacting directly with business areas and delivering executive presentations.
- Ability to document technical processes and business rules clearly and structurally.
- Preferred: Knowledge of Apache Airflow for creating and managing data pipelines.
- Knowledge of Cloud (Azure/AWS).
- Power BI certifications.
- Knowledge of Git.
- Knowledge of Docker.
Benefits
- Health and Dental Insurance
- Transportation Allowance
- Remote Work Allowance
- Meal Allowance
- Paid Vacation
- Birthday Day Off
- Health and Well-being Program
- Individual Development Program (IDP).
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Lead Data Analyst managing adult skills programmes for Greater London Authority. Delivering software and data systems, ensuring quality assurance and supporting analysis of critical data.
Quality Data Analyst creating insights from quality and complaint data for an international company. Proactively analyzes data to identify trends and issues, supporting cross - functional projects.
Data Analytics Intern supporting innovative AI services for production processes at BMW Group. Collaborating on applications, prototyping, and data analytics solutions from concept to operation.
Junior SAP Finance and Data Analyst supporting SAP S/4 Finance design and functional specifications at The Boeing Company. Collaborating with teams and contributing to enterprise - level improvements.
Senior Merchant Analytics Manager at Upside leveraging data to enhance merchant partnerships and drive product analytics. Leading analysis projects and collaborating with cross - functional teams.
Merchant Analytics Manager analyzing data to assist merchant partners in understanding business impacts. Collaborating to improve product strategy and incremental profit opportunities at Upside.
Data Analytics Junior designing, developing and testing data processing solutions in a hybrid work environment. Handling data pipelines and collaborating with business teams.
Data Analyst II leveraging data to solve business problems and improve customer experience at Pizza Hut Global. Collaborate with teams to analyze operational data for strategic decisions.
Junior Data Analyst at Arcadis working on digital asset management services. Contributing to projects involving data handling and supporting multi - disciplinary teams in delivering results.