Business Intelligence Analyst
Há 3 dias
**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
-
Business Intelligence Data Analyst
Há 3 dias
Curitiba, Paraná, Brasil beBee Careers Tempo inteiroJob Summary:">We are seeking a highly skilled Business Intelligence Data Analyst to join our team. As a key member of the data science and analytics portfolio, you will provide technical support and development expertise for Data Warehouse technologies. This includes SAP Native HANA 2.0, Microsoft SQL & cloud environments.">Main Responsibilities:">">Develop...
-
Curitiba, Paraná, Brasil beBee Careers Tempo inteiro**Business Intelligence Role Overview**As a Senior Business Intelligence Analyst Lead, you will be responsible for driving business improvements and innovation across various operating areas. This involves developing visual reports and dashboards to inform business decisions.**Key Responsibilities:**Lead the development of business intelligence solutions to...
-
Business Intelligence Developer
2 semanas atrás
Curitiba, Paraná, Brasil Talent Hackers Tempo inteiroWe are seeking a talented Business Intelligence Developer to join our team at Talent Hackers. As a Business Intelligence Developer, you will be responsible for designing and implementing complex business intelligence solutions using a range of tools and technologies.The ideal candidate will have a strong background in business intelligence and experience...
-
Business Intelligence Analyst
3 semanas atrás
Curitiba, Paraná, Brasil Ranger Technical Resources Tempo inteiroBI Analyst #2479Position Summary:Our partner, a growing streaming and marketing optimization product company, is looking to add a BI Analyst to its team. In this role, your focus will be on analyzing operational business data and transforming it into meaningful insights and actionable strategies. You will collaborate with stakeholders to gather requirements,...
-
Business Intelligence Developer
Há 3 dias
Curitiba, Paraná, Brasil beBee Careers Tempo inteiroAbout the Role">We are seeking an experienced Senior Data Analyst to join our Business Intelligence & Advanced Analytics organization. As a key member of our team, you will play a crucial role in delivering high-quality data insights and supporting business decisions. This is an excellent opportunity to work with a talented team of professionals who are...
-
Business Intelligence Analyst
Há 4 dias
Curitiba, Paraná, Brasil beBee Careers Tempo inteiroAbout the RoleThe ideal candidate will have expertise in data warehousing, ETL/ELT, and data lake modernization. They will also be comfortable with query optimization, big data, business intelligence, and analytics. Additionally, they should have experience with data integration and be familiar with NoSQL databases.
-
Business Intelligence Analyst
Há 7 dias
Curitiba, Paraná, Brasil Doctoralia Tempo inteiroJob DescriptionThe Business Intelligence Specialist | RevOps role at Doctoralia Brasil is an exciting opportunity to join a leading healthcare platform. About UsWe are a Docplanner Group company, present in 13 countries, serving over 55 million patients and processing more than 15 million appointments per month. Our mission is to make the healthcare...
-
Business Intelligence Architect
2 semanas atrás
Curitiba, Paraná, Brasil DataSelf Corp Tempo inteiroAbout DataSelf CorpDataSelf Corp simplifies and amplifies business intelligence with its own ETL+ and data warehousing solutions. We leverage popular tools like Tableau, Power BI, Excel, and Microsoft BI technologies such as Fabric, Data Lake, and Synapse to provide comprehensive business intelligence expertise.We offer out-of-the-box solutions with over...
-
Curitiba, Paraná, Brasil Jobfinder Spain Tempo inteiroBusiness Intelligence Analyst with Tableau (Senior) ID26704Posted On 12/20/2024Job InformationCity: CuritibaState/Province: ParanaZip Code: 80000-000Industry: IT ServicesJob DescriptionAgileEngine is one of the Inc. 5000 fastest-growing companies in the U.S. and a top-3 ranked dev shop according to Clutch.We create award-winning custom software solutions...
-
Business Intelligence Analyst with Tableau
2 semanas atrás
Curitiba, Paraná, Brasil JobFinder Spain Tempo inteiroBusiness Intelligence Analyst with Tableau (Senior) ID26704Posted On 12/20/2024 Job InformationCity: Curitiba State/Province: Parana Zip Code: 80000-000 Industry: IT Services Job DescriptionAgileEngine is one of the Inc. 5000 fastest-growing companies in the U.S. and a top-3 ranked dev shop according to Clutch. We create award-winning custom software...