Business Intelligence Analyst
1 semana atrás
**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
-
Curitiba, Brasil Bairesdev Tempo inteiroBusiness Intelligence Analyst - Remote Work:At BairesDev, we've been leading the way in technology projects for over 15 years.We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley.Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact...
-
Curitiba, Brasil BairesDev Tempo inteiroBusiness Intelligence Analyst - Remote Work: At BairesDev, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley. Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant...
-
Business Intelligence Analyst | Remote Work | Curitiba, Brazil
4 semanas atrás
Curitiba, Brasil BairesDev Tempo inteiroBusiness Intelligence Analyst - Remote Work: At BairesDev, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley. Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive...
-
IT - Business/Functional Analyst
4 semanas atrás
Curitiba, Brasil Syensqo Tempo inteiroJoin 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....
-
Business Analyst
Há 7 dias
Curitiba, Brasil DIGIU DIGITAL Tempo inteiroOur team is growing! We’re looking for business analysts, able to analyse customer’s business requirements or technical problems and act as a technical advisor and problem solver to our clients: - Drive innovation to optimize, automate and standardize the operational processes. - Deliver high quality and ensure stable operations. EXPECTATIONS AND...
-
IT - Business/Functional Analyst
4 semanas atrás
Curitiba, Brasil Syensqo Tempo inteiroJoin 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....
-
IT Business Analyst
1 hora atrás
Curitiba, Brasil Ewave do Brasil Tempo inteiroVocê quer abrir as portas para atuação em uma empresa que é uma grande potência no mercado? Então essa é sua oportunidade! A Ewave do Brasil está contratando profissional da área de desenvolvimento para atuação em seu cliente Volvo do Brasil! Atuação 100% home office. vempraewave **Responsabilidades e atribuições** The IT Business Analyst has...
-
IT Business Analyst
4 semanas atrás
Curitiba, Brasil Ewave do Brasil Tempo inteiroVocê quer abrir as portas para atuação em uma empresa que é uma grande potência no mercado?Então essa é sua oportunidade! A Ewave do Brasil está contratando profissional da área de desenvolvimento para atuação em seu cliente Volvo do Brasil!Atuação 100% home office.vempraewave**Responsabilidades e atribuições**The IT Business Analyst has an...
-
Business Analyst
1 dia atrás
Curitiba, Brasil HCLTech Tempo inteiroBusiness Analyst (TAX)***Add resume in English***Activities: - Serves as a Tax, Sourcing, Travel, Expense, and Real Estate applications subject matter expert associated with functionality, content, processes, and procedures. - Assist with the design and implementation of operational and system enhancements to ensure production capabilities are both effective...
-
649 Services Business Intelligence Analyst
2 semanas atrás
Curitiba, Brasil A PRIORI EXCELÊNCIA EM RECURSOS HUMANOS Tempo inteiro**Requisitos**:- Bachelor’s in engineering, IT, Business Administration or equivalent combination of education and experience;- Experience with data analysis and preparation, including experience with BI (Business Intelligence);- Experience with “Service designing” methods;- Good verbal and written communication skills in Portuguese and English;-...
