Business Intelligence Analyst
4 semanas atrás
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 Analyst
3 semanas atrás
Curitiba, Paraná, Brasil BuscarVagas - Empregos e Consultoria Brasil Tempo inteiroLiason: this professional acts like a bridge among business and IT areas, translating business and product needs and requirements into a Product Roadmap and further Project Documentations;Evaluates business processes, anticipate requirements, uncover areas for improvement, and develop and implement solutions;Highly professional communication abilities are a...
-
Analista de Business Intelligence
1 semana atrás
Curitiba, Paraná, Brasil Lyx Participações Tempo inteiro R$90.000 - R$120.000 por anoA Lyx Engenharia é a maior incorporadora do casa verde amarela do Paraná, com uma história de sucesso que se estende por décadas. Somos conhecidos por nossa excelência na execução de projetos de construção de grande escala e já realizamos o sonho da casa própria de mais de pessoas. Nossa dedicação à qualidade e ao compromisso com prazos é o...
-
Business Analyst
Há 3 dias
Curitiba, Paraná, Brasil BuscarVagas - Consultoria Tempo inteiro R$90.000 - R$120.000 por anoATRIBUIÇÕES: Liason: this professional acts like a bridge among business and IT areas, translating business and product needs and requirements into a Product Roadmap and further Project Documentations; Evaluates business processes, anticipate requirements, uncover areas for improvement, and develop and implement solutions; Highly professional communication...
-
Analista de business intelligence
4 semanas atrás
Curitiba, Paraná, Brasil LYX Tempo inteiroExperiência em Business Intelligence, Análise de Dados ou áreas relacionadas. Domínio de SQL para consultas em bancos de dados. Experiência com ferramentas de visualização de dados (Power BI, Tableau, Looker, Qlik). Forte conhecimento em Excel avançado. Capacidade analítica para interpretar dados e gerar insights claros. Boa comunicação para...
-
Agile Business Analyst
4 semanas atrás
Curitiba, Paraná, Brasil ExxonMobil Tempo inteiro**Job Role Summary**:Business analysts must analyze and synthesize information provided by a large number of people who interact with the business, such as customers, staff, information technology (IT) professionals and executives.The business analyst is responsible for eliciting the actual needs of stakeholders, not simply their expressed desires. In...
-
Analista de Business Intelligence
1 semana atrás
Curitiba, Paraná, Brasil LyX Tempo inteiro R$80.000 - R$120.000 por anoA Lyx Engenharia é a maior incorporadora do casa verde amarela do Paraná, com uma história de sucesso que se estende por décadas. Somos conhecidos por nossa excelência na execução de projetos de construção de grande escala e já realizamos o sonho da casa própria de mais de pessoas. Nossa dedicação à qualidade e ao compromisso com prazos é o...
-
Business Analyst
Há 19 horas
Curitiba, Paraná, Brasil Frontall USA Tempo inteiro R$60.000 - R$80.000 por anoInformações da VagaEmpresa: Frontall USALocalização: Curitiba - PRÁrea de Atuação: Engenharia de Produção / ProcessosPrincipais ResponsabilidadesLiason: this professional acts like a bridge among business and IT areas, translating business and product needs and requirements into a Product Roadmap and further Project Documentations;Evaluates business...
-
FBS Assoc Business Solution Analyst
3 semanas atrás
Curitiba, Paraná, Brasil Capgemini Tempo inteiro2 days ago Be among the first 25 applicants Get AI-powered advice on this job and more exclusive features. This range is provided by Capgemini. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range MX$1.00/yr - MX$1.00/yr Our Client is one of the United States' largest insurers, providing a...
-
QA Business Analyst
4 semanas atrás
Curitiba, Paraná, Brasil FullStack Labs Tempo inteiroOverview QA Business Analyst - Remote - Latin America Join to apply for the QA Business Analyst - Remote - Latin America role at FullStack Labs About FullStack FullStack is the most transparent IT talent network, connecting highly skilled individuals with top global companies and Silicon Valley startups for remote, on-demand projects. We focus on building a...
-
Senior Business Analyst
3 semanas atrás
Curitiba, Paraná, Brasil buscojobs Brasil Tempo inteiroBorn digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a mission-driven group of over 39,000+ practical problem solvers and creative...
