@AppsAssociates (I) Pvt Ltd is #Seeking #powerbi resources for remote location.
Seeking #earlyjoiners
Role: Power BI Consultant
Experience: 6 to 10 years
Skills:
- At least 5 years of experience in data analysis and visualization using Power BI.
- Develop operational paginated reports and build automated reports and dashboards with the help of Power BI Desktop, Service and other Azure Analytics / reporting features
- Strong analytical skills and the ability to work with complex data sets to identify trends and patterns.
- Proficient in SQL and experience with data modeling, data warehousing, and exposure to ETL processes.
- Be experienced in tools and systems on MS SQL Server, BI tech Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and Strong DAX experience
- To create dashboards and visual interactive reports using Power BI and to identify KPIs with clear objectives and monitor them consistently.
- Ability to create and maintain Power BI Modeling, visualizations involving dimensional hierarchies, drill down, drill through and dashboards with advanced visualizations that provide actionable insights to stakeholders.
- Well experienced in custom columns, measures, time series metrics, KPIs and integrate custom visualizations, collaboration features
Similar jobs
Briefly describe Mandatory Skills:
We are looking for a MIS Analyst to participate with other Analysts in the team to convert the data into reports in various forms and thereby provide meaningful insights to the users of the reports and help them in decision making process. Experience Level – 1-2 yrs. of experience as MIS executive/analyst Responsibilities - · Managing the data including creation, updates, and deletion · Collecting the data, interpreting, analyzing, and developing the reports and dashboards · Generating reports from single or multiple systems · Processing confidential data and information according to the guidelines · Create visualizations and reports for requested projects in MS Excel and PowerBI platforms · Develop and update documentation Skills / Requirements - · Strong knowledge and experience in Advance MS Excel (MUST HAVE) · Basic knowledge of reporting tools like Power BI or Tableau · Basic Knowledge of SQL queries · Strong mathematical and analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy · Ability to analyze large data set and create meaningful visualization and reports · Analytical mind with a problem-solving attitude · Excellent communication · BSc/ MSc in Computer Science MSc/MCA, Engineering, or relevant field |
To be successful in this role, you should possess
- Overall Industry experience 2-6 years
- Bachelor’s Degree in analytical subject area. E.g., Engineering, Statistics.... etc.
- Proficient in advanced Excel functions and macros, involving complex calculations and pivots
- Exceptional Analytical, problem solving & Logical skills.
- Understanding of relational database concepts and familiar with SQL
- Demonstrable aptitude for Innovation & Problem solving.
- Good communication skills & ability to work across Cross-functional teams.
- Understands complex utility tariffs, rates and programs and converts these into a model.
- Participates in sprint planning & other ceremonies, passionately works towards fulfilling the committed sprint goals.
- Knowledge of and ability to automate routine tasks using Python is a PLUS
Preferred Qualifications:
- Experience in Energy Industry & familiar with basic concepts of Utility (electrical/gas...) tariffs
- Experience & Knowledge with tools like; Microsoft Excel macros,
- Familiarity with writing programs using Python or Shell scripts.
- Passionate about working with data and data analyses.
- 1+ year experience in Agile methodology.
Roles and responsibilities
- Understands complex utility tariffs, rates and programs and converts these into a model.
- Responsible for analysis of the energy utilization data for cost and usage patterns and derive meaningful patterns
- Responsible for Maintaining the tariff models with timely updates for price, logic or other enhancements as per client requirement.
- Assist delivery team in validating the input data received from client for modelling work.
- Responsible for Communicating & Co-ordinating with Delivery team
- Work with Cross functional teams to resolve issues in the Modelling tool.
- Build and deliver compelling demonstrations/visualizations of products
- Be a lifelong learner and develop your skills continuously
- Contribute to the success of a rapidly growing and evolving organization
Additional Project/Soft Skills:
- Should be able to work independently with India & US based team members.
- Strong verbal and written communication with ability to articulate problems and solutions over phone and emails.
- Strong sense of urgency, with a passion for accuracy and timeliness.
- Ability to work calmly in high pressure situations and manage multiple projects/tasks.
- Ability to work independently and possess superior skills in issue resolution.
Professional experience in Python – Mandatory experience
Basic knowledge of any BI Tool (Microsoft Power BI, Tableau etc.) and experience in R
will be an added advantage
Proficient in Excel
Good verbal and written communication skills
Key Responsibilities:
Analyze data trends and provide intelligent business insights, monitor operational and
business metrics
Complete ownership of business excellence dashboard and preparation of reports for
senior management stating trends, patterns, and predictions using relevant data
Review, validate and analyse data points and implement new data analysis
methodologies
Perform data profiling to identify and understand anomalies
Perform analysis to assess quality and meaning of data
Develop policies and procedures for the collection and analysis of data
Analyse existing process with the help of data and propose process change and/or lead
process re-engineering initiatives
Use BI Tools (Microsoft Power BI/Tableau) and develop and manage BI solutions
Title/ Role: Power Apps Technical Consultant
Experience: 4-9 Years
Work Location: Bangalore, Noida, Gurgaon
Notice Period: Immediate to 30 days Max
Mandatory Skills: Power Platform Development, Power Apps, Power Automate, Power BI, MS D365 CE, CRM, SharePoint, Integration
Job Description:
The Integration Technical Consultant is responsible to work with business solution architects and project team to execute integration project activities on Shell projects. The incumbent will establish close working relationships with Technical Leads, Architects, business IT, third parties and external delivery partners to successfully deliver enterprise integration technical projects in Shell.
As a Power Apps Developer, you are able to design, test and deploy Power Apps (Canvas, Model-Driven, Portal)
Job Requirements:
- Power Apps Technical expert with experience in IT industry, as well as proven skills in technical consulting. Be able to show skills across advising, scoping, designing and defining projects which are either complex or broad in scope.
- This is a wide-ranging role where you’ll be able to flex your technical and professional skills, as you confidently oversee Shell’s computing strategy for end user productivity and help us lead on standards for cloud consumption
- Develop Power Apps solutions on the Microsoft Power Platform, including Common Data Service (CDS), Power Apps and Dynamics 365 CE
- Experience in developing new Power Apps model-driven and canvas apps as well as enhancing existing apps
- Development knowledge on CRM Plugins, CRM Workflows
- Development knowledge on PCF Controls for both canvas and model driven apps
- Strong development knowledge on customization of Views/forms using JavaScript
- Strong development knowledge on Microsoft stack especially C#, ASP.NET, Azure and Office 365.
- Ability to create custom connectors for Power Automate
- Experience with SharePoint integration scenarios with Power Apps and D365
- PowerBI report development
- Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
- Connecting data sources, importing data, and transforming data for Business intelligence.
Job Description
Education : Graduation in Computer Science
Job Description :
Around 3 years of professional experience in Oracle Applications 11i / R12 as Technical Consultant.
Expertise in developing the reports using Report Builder , Discoverer and XML Publisher. Having Technical knowledge in various modules like OM , FA , GL , AP , PO , INV , AR , CM and AOL.
Oracle Database Upgrade 9i to 11g.
Database Patching , Space Management Purging Archiving , Connectivity Issue Tablespace Creation , Modification , Deletion , Troubleshooting Concurrent Manager , Monitoring Application Performance
Excellent Knowledge in Oracle (SQL , PL / SQL , Reports 10g).
Good exposure with SQL Loader.
Good Knowledge on Technical architecture and functional flow of Oracle Applications modules such as Account Payable , Account Receivables , Purchasing , General Ledger , Fixed Assets , Inventory and Order Management.
Having good experience in designing and preparation of documents likeMD70 , MD120 and TE20 as a part of Object Deliverables.
Worked on Inbound Interfaces for e.g. (AP Invoice , GL Interface , AR Invoice etc.).
Experience in designing and development of Conversion Programs to load data from Legacy system to Oracle Applications with effective validation logic and Error handling mechanism (Supplier Conversion , Item Conversion).
Responsibilities :
- Provide Support Services to our Gold & Enterprise customers using our flagship product suits. This may include assistance provided during the engineering and operations of distributed systems as well as responses for mission-critical systems and production customers.
- Lead end-to-end delivery and customer success of next-generation features related to scalability, reliability, robustness, usability, security, and performance of the product
- Lead and mentor others about concurrency, parallelization to deliver scalability, performance, and resource optimization in a multithreaded and distributed environment
- Demonstrate the ability to actively listen to customers and show empathy to the customer’s business impact when they experience issues with our products
Requires Skills :
- 10+ years of Experience with a highly scalable, distributed, multi-node environment (100+ nodes)
- Hadoop operation including Zookeeper, HDFS, YARN, Hive, and related components like the Hive metastore, Cloudera Manager/Ambari, etc
- Authentication and security configuration and tuning (KNOX, LDAP, Kerberos, SSL/TLS, second priority: SSO/OAuth/OIDC, Ranger/Sentry)
- Java troubleshooting, e.g., collection and evaluation of jstacks, heap dumps
- Linux, NFS, Windows, including application installation, scripting, basic command line
- Docker and Kubernetes configuration and troubleshooting, including Helm charts, storage options, logging, and basic kubectl CLI
- Experience working with scripting languages (Bash, PowerShell, Python)
- Working knowledge of application, server, and network security management concepts
- Familiarity with virtual machine technologies
- Knowledge of databases like MySQL and PostgreSQL,
- Certification on any of the leading Cloud providers (AWS, Azure, GCP ) and/or Kubernetes is a big plus
2) Design and Create AAS/OLAP/ Tabular cubes and automate processes for analytical needs. Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using DAX functions in - Azure Analysis service
3) Writing optimized SQL queries for integration with other applications, Maintain data quality and overseeing database security, Partitions and Index. Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries and trouble-shoot cubes SQL and T-SQL.
4) Designing database tables and structures, creating views functions and stored procedures.
5) Exposure to PowerBI will be an added advantage.
Understanding PowerApps formulas and development methods. Ability to develop
POWER BI Min 2+ years of hand on experience in POWER BI Reports and dashboard development, MS SSAS, MS SSAS & POWER BI Candidate
Should have hands on experience on writing complex SQL queriesworkflows using PowerApps and Microsoft PowerAutomate.
Customizing SharePoint lists and disparate systems with PowerApps Knowledge of PowerApps and PowerAutomate licensing Automating business processes with Microsoft PowerAutomate.
Automating business processes with Microsoft PowerAutomate.
Ability to create custom connectors for Microsoft PowerAutomate.
Experience with API or rest services integrations.
Understanding of how to implement solutions with multiple data source Understanding PowerApps formulas and development methods
• Strong knowledge of data structure and algorithms
• Ability to write complex SQL
• Familiarity with Test driven development and Continuous Integration
• Strong knowledge and hands-on with code development tools (Eclipse, GIT, Jenkins, Unit, Testing Frameworks)
• Familiar with Software development methodology like Agile methodology
• Knowledge of JavaScript and AngularJS would be a plus
• Knowledge of Java and Python
• Knowledge of Unix and shell scripting would be a plus
• Strong leadership skills
• Desire to learn and develop new tools and techniques and share with the team
• Capability to mentor junior team members
• Active involvement is required in all phases of Software Development
• Ability to establish trusted partnership with executive level stakeholders