Business Intelligence Analyst

Há 4 dias

Curitiba, Paraná, Brasil Pantheon Inc. Tempo inteiro
**Job Summary**:
Work with business and technical teams to provide technical support and development expertise for Data Warehouse technologies (SAP Native HANA 2.0, Microsoft SQL, Snowflake & cloud environments) in Fuels Value Chain - Data & Analytics portfolio
**Primary Job Functions**:
- Develop or enhance data models, data integration and ETL activities.
- Support and break fix of existing data warehouse products
- Support maintenance activities such as support pack and enhancement packs, adding of aggregates, partitioning of data objects etc.
- Execute demos, projects, proof of concepts in development or technical design
- Collaborate with project teams, business customers and other support partners in solution ideation, requirements gathering and product delivery
- Ensure solution compliance to solution design, best practices, technical architecture, design standards, technology roadmaps and business requirements
- Support adoption / promotion of new products delivered
- Support and Mentor less experienced team members
- Explore and develop skills in new technologies according to technology roadmap
**JOB REQUIREMENTS**:
- Minimum B.S. in Computer Science or equivalent.
- Experience in Agile development and working on an Agile team
- Strong knowledge of financial processes
- Willing to travel internationally and accommodate occasional work schedule flexibility
- Familiarity with SAP ECC modules (FI, CO, SD, MM, etc.) and business process (OtC, PtP, SC, Financials, PtA, etc.)
- Applied Knowledge of Business Intelligence technologies (HANA 2.0, BOBI, Tableau, Power BI, Azure, MSBI, BODS, BO IS, ABAP, SDA, SDI, SLT and SQL)
- Understand emerging technologies
- English Language Fluency - Verbal and Written
- Self-starter and independent worker
- Experience in Applications support
- Strong problem resolution skills
- Strong communication skills (written and verbal)
- Strong customer focus - Commitment to teamwork
- Commitment to excellent product quality
- Experience in full cycle delivery of data warehouse projects
**PREFFERED KNOWLEDGE )SKILL)ABILITIES**
- Application Design;
- Application Development and Support;
- SAP Business Warehouse and HANA (2.x)
- SAP Business Objects Business Intelligence suite;
- SAP Data Services;
- SAP SLT - MS SQL;
- SDA/SDI**Modeling Question**
1. What is the difference between table function and stored procedure? Explain in which scenario you will use table function and which scenario you use store procedure?
A1: Table function is a read-only type of procedure that returns a result set and can be queried via SELECT statement;
A2: Procedures on the other hand allow output parameters and write operations;
A3: Table function in scenarios where the result requires logic that is better implemented via code than in a graphical view (e.g. recursive query).
A4: Procedure in scenarios where data needs to be written to tables (e.g. materialization)
2. Referential join vs inner join and left join - In which scenario referential join will work as inner join and in which scenario it work as left join
A1: When referential integrity is maintained
A2: When none of the columns from the table on the right side are requested (column not in result set nor as a filter)
3. Can you explain how join cardinality improve query performance?
A: if properly set, it drives better execution plans

  • Strategic Business Intelligence Consultant

    Há 6 dias

    Curitiba, Paraná, Brasil beBeebusiness Tempo inteiro R$80.000 - R$150.000

    Business Intelligence Specialist Job DescriptionWe are seeking a skilled Business Intelligence Specialist to join our team. As a Business Intelligence Specialist, you will be responsible for analyzing business needs and requirements to identify solutions that meet our company's objectives.

  • Data Driven Business Intelligence Professional

    1 semana atrás

    Curitiba, Paraná, Brasil beBeeData Tempo inteiro US$40.000 - US$80.000

    Job TitleData Analyst – Business IntelligenceAbout the RoleWe are seeking a skilled Data Analyst to join our team in Curitiba. This is a fixed-term contract until December 2026, with the possibility of extension.The successful candidate will work on data process improvements, ensuring high-quality data management and facilitating data-driven decisions...

  • Senior Business Intelligence Data Analyst

    1 semana atrás

    Curitiba, Paraná, Brasil beBeeDataDriven Tempo inteiro R$134.000 - R$221.000

    Job Title: Senior Business Intelligence DeveloperWe are seeking a highly skilled Senior Business Intelligence Developer to join our team. The ideal candidate will be responsible for designing and developing data-driven solutions using Tableau, BigQuery, and Google Cloud Platform.Key Responsibilities:Designing and developing data-driven solutions using...

  • Senior Business Intelligence Data Specialist

    2 semanas atrás

    Curitiba, Paraná, Brasil beBeeBusiness Tempo inteiro US$60.000 - US$90.000

    About this OpportunityWe are seeking a seasoned Business Intelligence expert to join our team. As a key member, you will be responsible for creating advanced dashboards, data visualizations, and reports using Tableau. This role involves leveraging SQL expertise to prepare datasets, distill complex information into actionable insights, and communicate...

  • Senior Business Data Specialist

    Há 5 dias

    Curitiba, Paraná, Brasil beBeeDataDriven Tempo inteiro US$90.000 - US$120.000

    Business Intelligence Analyst RoleWe are seeking a skilled Business Intelligence Analyst specializing in Tableau to support data-driven decision-making processes. The role involves creating advanced dashboards, data visualizations, and reports using Tableau, with Power BI experience considered a plus.Key Responsibilities:Create detailed data visualizations...

  • IT - Business/Functional Analyst

    3 semanas atrás

    Curitiba, Paraná, Brasil Syensqo Tempo inteiro

    Join to apply for the IT - Business/Functional Analyst role at Syensqo 3 days ago Be among the first 25 applicants Join to apply for the IT - Business/Functional Analyst role at Syensqo Syensqo is all about chemistry. We're not just referring to chemical reactions here, but also to the magic that occurs when the brightest minds get to work together. This...

  • Business Analyst Role

    Há 6 dias

    Curitiba, Paraná, Brasil beBeeTax Tempo inteiro R$47.200 - R$90.880

    Business Analyst RoleWe're looking for a skilled Business Analyst to join our team. As a Junior Tax and Technology Analyst, you will play a critical role in shaping the future of our company.Key ResponsibilitiesSupport financial operations by preparing journal entries, adjustments, and recording relevant transactions.Conduct balance sheet reconciliations and...

  • Business Analyst

    2 semanas atrás

    Curitiba, Paraná, Brasil buscojobs Brasil Tempo inteiro

    OverviewAt INDI, we're passionate about empowering individuals and businesses worldwide. Our cutting-edge recruiters connect leading companies with top talent, fostering a dynamic environment where innovation thrives. Join us in shaping the future of work.About the Role: We are looking for a Business Intelligence Analyst to join our team. This professional...

  • IT - Business/Functional Analyst

    4 semanas atrás

    Curitiba, Paraná, Brasil Syensqo Tempo inteiro

    Join to apply for the IT - Business/Functional Analyst role at Syensqo3 days ago Be among the first 25 applicantsJoin to apply for the IT - Business/Functional Analyst role at SyensqoSyensqo is all about chemistry. We're not just referring to chemical reactions here, but also to the magic that occurs when the brightest minds get to work together. This is...

  • Senior Business Data Analyst

    1 semana atrás

    Curitiba, Paraná, Brasil beBeeBusiness Tempo inteiro R$40.000 - R$80.000

    Business Intelligence Analyst RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team. The ideal candidate will have extensive experience in developing BI dashboards and reports, analyzing and visualizing data.The role involves working with stakeholders to understand reporting needs, identifying and querying data sources to...