PowerBI Jobs in Hyderabad
It's regarding a permanent opening with Data Semantics
Data Semantics
We are Product base company and Microsoft Gold Partner
Data Semantics is an award-winning Data Science company with a vision to empower every organization to harness the full potential of its data assets. In order to achieve this, we provide Artificial Intelligence, Big Data and Data Warehousing solutions to enterprises across the globe. Data Semantics was listed as one of the top 20 Analytics companies by Silicon India 2018 & CIO Review India 2014 as one of the Top 20 BI companies. We are headquartered in Bangalore, India with our offices in 6 global locations including USA United Kingdom, Canada, United Arab Emirates (Dubai Abu Dhabi), and Mumbai. Our mission is to enable our people to learn the art of data management and visualization to help our customers make quick and smart decisions.
Our Services include:
Business Intelligence & Visualization
App and Data Modernization
Low Code Application Development
Artificial Intelligence
Internet of Things
Data Warehouse Modernization
Robotic Process Automation
Advanced Analytics
Our Products:
Sirius – World’s most agile conversational AI platform
Serina
Conversational Analytics
Contactless Attendance Management System
Company URL: https://datasemantics.co
JD:
MSBI
SSAS
SSRS
SSIS
Datawarehousing
SQL
A Business Transformation Organization that partners with businesses to co–create customer-centric hyper-personalized solutions to achieve exponential growth. Invente offers platforms and services that enable businesses to provide human-free customer experience, Business Process Automation.
Location: Hyderabad (WFO)
Budget: Open
Position: Azure Data Engineer
Experience: 5+ years of commercial experience
Responsibilities
● Design and implement Azure data solutions using ADLS Gen 2.0, Azure Data Factory, Synapse, Databricks, SQL, and Power BI
● Build and maintain data pipelines and ETL processes to ensure efficient data ingestion and processing
● Develop and manage data warehouses and data lakes
● Ensure data quality, integrity, and security
● Implement from existing use cases required by the AI and analytics teams.
● Collaborate with other teams to integrate data solutions with other systems and applications
● Stay up-to-date with emerging data technologies and recommend new solutions to improve our data infrastructure
Exp-8-12 Years
Job location-Hyderabad, Bengaluru, Mumbai, Pune and Goa
CTC – As per market standard
Notice Period-Max 15 -30 days joiners
Responsibilities:
- Work with Database Architect to understand the design considerations for the BI Next Gen Data Warehouse.
- Take accountability of the development / update of the DW Database Objects and Code as per the requirement.
- Take accountability of the development / update of the PowerBI and SSRS Reports.
- Take accountability of Unit Testing the developed solution.
- Be available for weekend job monitoring and troubleshooting, as necessary.
- Ensure that all delivery timelines are adhered to.
- Work with QA (Testing) team to test the DW / Report Solution and fix as necessary.
Job Requirements:
- 8 - 10 years of experience in SQL Server database development.
- Excellent understanding of SQL Server 2016 and above.
- Excellent understanding of T-SQL. Must have the ability to analyze, debug and write complex T-SQL code.
- Very good hand-on knowledge on query tuning and performance optimization.
- Excellent understanding of SQL Server Integration Services and SQL Server Reporting Services.
- Excellent understanding of PowerBI.
- Should be completely aware of coding standards and should be able to develop high performance & scalable database applications.
- Exceptional Problem Solving and Analytical Skills.
Excellent communication skills (oral and written).
Job Summary
The purpose of this role is to rationalize the full stack BI architecture, including ETL, Dimensional Model and Semantic layer and establishment of an efficient CI/CD pipeline. This platform will support efficient production of BI reports and models, to deliver insights and decision support for specific business processes.
Responsibilities
- Establish a clean dimensional model architecture, in a platform that is aligned with the BW BI strategy, in tune with the scale and complexity of the BV business
- Supported by existing, in-house Application and IBM i DB2 experts, rationalize the existing DB2, SQL ETL code base and add components, to feed the chosen architecture
- Establish a Data Warehouse, which may overlap with PBI Dataflows, to support Fact Table aggregations and Slowly Changing Dimensions along with basic shaping and cleaning
- Rationalize the existing Power BI Workspaces to align with the chosen architecture and establish CI/CD pipelines, to support ongoing management of the model, with appropriate orchestration
- Establish Master Data management to provide a self-serve user interface for managing off-system Master Data, to support BI
- Rationalize the Semantic Layer in the Power BI model to provide a clean structure, with consistent naming conventions, in Business language, to support self-serve analysis
Ideal Candidates should have
- Familiarity with best practice, Azure and PBI architectural principles
- 4 to 5 years’ experience, Microsoft Certified preferable
- Expert in Dimensional Modelling in an Azure/PBI environment
- Comfortable with SDLC Tools for BI (Git, MS Devops, Pipelines)
- Mature, personable, team player
- Strong analytical and problem-solving skills
- Strong oral and written communication skills
As a Power BI and QlikView Developer, we expect the candidate to be a key contributor in the implementation of data analytics dashboards – from data preparation to dashboard development, unit testing and deployment. The primary work focus for the candidate is as under:
- Understanding the database design.
- Develop efficient SQL queries from simple to complex and test the data output as a part of data preparation activity
- Development & Unit Testing – Dashboards & Data Visualizations using Power BI
- Troubleshooting/debugging and rectifying issues
- Review, feedback and mentoring the team
- Adherence of standards and best practices as defined by the company at the individual level and as a team
QUALIFICATIONS AND EXPERIENCE
- Degree in BE/ BTech with at least 3 to 5 years of overall experience
- Experience in working on multiple databases like MS SQL (Mandatory), PostgreSQL, Mongo DB, MySQL (would be a plus) etc. and data analytics projects (a minimum of 2 to 3).
- Experience working on SQL Server: Writing queries of 1 to 2 years is mandatory.
- Expertise in Power BI and knowledge of QlikView (1-2 years).
- Understanding other tools like Tableau, Domo etc. would be a great plus
- Experience in working on different types of visualizations, in addition to the generic ones – Scatter plots, Heat Maps, Geo maps, Gantt, Bubbles, Tree Maps etc.
- Experience working on Trends, forecasting etc. would be a plus
- Experience in working with projects teams and ensuring the successful delivery of the solution
Experienced in writing complex SQL select queries (window functions & CTE’s) with advanced SQL experience
Should be an individual contributor for initial few months based on project movement team will be aligned
Strong in querying logic and data interpretation
Solid communication and articulation skills
Able to handle stakeholders independently with less interventions of reporting manager
Develop strategies to solve problems in logical yet creative ways
Create custom reports and presentations accompanied by strong data visualization and storytelling
Senior Software Engineer
MUST HAVE:
POWER BI with PLSQL
experience: 5+ YEARS
cost: 18 LPA
WHF- HYBRID
4-6 years of total experience in data warehousing and business intelligence
3+ years of solid Power BI experience (Power Query, M-Query, DAX, Aggregates)
2 years’ experience building Power BI using cloud data (Snowflake, Azure Synapse, SQL DB, data lake)
Strong experience building visually appealing UI/UX in Power BI
Understand how to design Power BI solutions for performance (composite models, incremental refresh, analysis services)
Experience building Power BI using large data in direct query mode
Expert SQL background (query building, stored procedure, optimizing performance)
JD – Attached Sample Profile for Reference
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills
Nice to have
1) Experience in SAP BO / Crystal report /SSRS/ Power BI
2) Experience in Informix
3) Experience in ETL
Responsibilities
• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another
- Design thinking to really understand the business problem
- Understanding new ways to deliver (agile, DT)
- Being able to do a functional design across S/4HANA and SCP). An understanding of the possibilities around automation/RPA (which should include UIPath, Blueprism, Contextor) and how these can be identified and embedded in business processes
- Following on from this, the same is true for AI and ML: What is available in SAP standard, how can these be enhanced/developed further, how these technologies can be embedded in the business process. There is no point in understanding the standard process, or the AI and ML components, we will need a new type of hybrid SAP practitioner.
- Building and operationalizing large scale enterprise data solutions and applications using one or more of AZURE data and analytics services in combination with custom solutions - Azure Synapse/Azure SQL DWH, Azure Data Lake, Azure Blob Storage, Spark, HDInsights, Databricks, CosmosDB, EventHub/IOTHub.
- Experience in migrating on-premise data warehouses to data platforms on AZURE cloud.
- Designing and implementing data engineering, ingestion, and transformation functions
- Experience with Azure Analysis Services
- Experience in Power BI
- Experience with third-party solutions like Attunity/Stream sets, Informatica
- Experience with PreSales activities (Responding to RFPs, Executing Quick POCs)
- Capacity Planning and Performance Tuning on Azure Stack and Spark.
Should have Business Intelligence Experience in a data warehouse environment
Should have good experience in writing Power Query, DAX, MDX for complex data projects
Good on Rest Services including the API documentation.
Should have Experience authoring, diagnosing, and altering SQL Server objects and T-SQL
queries
Should have worked on Tabular models in Azure Analysis Services or SSAS
Should have Experience in Microsoft Azure Platform
Hands on in Power BI & Power Tool
Build Analysis Services reporting models.
Develop visual reports, dashboards and KPI scorecards using Power BI desktop.
Connect to data sources, importing data and transforming data for Business Intelligence.
Analytical thinking for translating data into informative visuals and reports.
Implement row level security on data and have an understanding of application security layer models in Power BI.
Make DAX queries in Power BI desktop.
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
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
Job Role – SDE2
Duration – 12 months
Location – HYD
Key Skills:
- 3- 5 years
- Understanding databases and building reports
- Ideal candidate should have experience in Cosmos, Kusto and powerbi
- Mandatory experience in some Database query language(such as SQL)