Power BI and Data Visualization Consultant

Job Description-

• Proficient in Power BI report development and dashboards and publishing to the consumers for decision making
• Design and develop optimized reporting applications (Power BI/SSRS) on SQL, Azure SQL.
• Sound knowledge of various visuals like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms
• Design and develop SQL procedures / ETL jobs, data processing in Microsoft Azure SQL, SQL Server with optimized processing time.
• Communicate design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager.
• Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions.
• Design and code high quality database solutions within a fast paced sprint release cycle.
• Proficiency in creating visualizations / reports / dashboards based on business requirements.
• Manage errors gracefully. Document code and work completed.
• Conduct thorough unit testing of code and document the unit test cases.
• Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria.
• Provide support as needed throughout Test and User Acceptance Testing phases.
• Create Technical Design Specification documentation that clearly articulates the design and code being implemented.
• Provide client communication as appropriate to project.
• Be able to translate technical specifications into finished programs and systems and also have a thorough understanding of developing solutions to handle
• large volume data sets that are typical with BI solutions.
• Assist in architectural design reviews and ensure technology stack selection is relevant
• Ensure development and testing follow industry standards

• 6-8 years of experience with any Business analytics visualization tool with at least 2 years of relevant experience in PBI development
• Demonstrated SQL expertise, coding functions, packages, stored procedures, scripts, and queries in SQL Server.
• Good technical knowledge in SQL Server BI Suite (ETL, Reporting, Analytics, Dashboards) using SSIS(good to have), SSAS(good to have), SSRS(good to have) and  Power BI (must have)
• Expertise in Query Optimization and create new SQL procedures based on business requirements.  This is a must have skill set
• Advanced working SQL knowledge and experience working with relational databases, query authoring as well as optimizing the data base objects
• Experience in working with Structured, semi-structured and un-structured data.
• Demonstrated experience in working on Power BI
• Understands how to create optimized db schema
• Strong data warehouse design and physical data modeling skills
• Ability to quickly troubleshoot issues and work on multiple tasks in parallel.
• Excellent coding and debugging skills
• Should have exposure of working PBI Premium Workspace and Gateways
• Ability to work in a self-directed way either individually or as part of a team.
• Excellent communication skills (written and spoken) and ability to work under continual deadline constraints are necessary.

Experience: 2 to 5 Years.
Skills: SQL, DBT, Airflow, Python, Golang, PostgreSQL, Clickhouse, BigQuery, Kafka/RabbitMQ, Data Scraping, System Design, ETLs, REST.
Work Location: Gurgaon/Bangalore/Remote.

We are seeking an experienced Analytics Engineer to join our team. The ideal candidate will have a strong background in Python, SQL, dbt, Airflow, and core database concepts. As an Analytics Engineer, you will be responsible for managing our data infrastructure, which includes building and maintaining robust API integrations with third-party data providers, designing and implementing data pipelines that run on schedule, and working with business, product, and engineering teams to deliver high-quality data products.

Key Responsibilities:
- Design, build, and maintain robust API integrations with third-party data providers.
- Develop and maintain data pipelines using Python, dbt, and Airflow.
- Collaborate with business, product, and engineering teams to deliver high-quality data products.
- Monitor and optimize data pipelines to ensure they run on schedule and with high performance.
- Stay up-to-date with the latest developments in data infrastructure and analytics technologies.
- Troubleshoot and resolve data pipeline and integration issues as they arise.

Qualifications:
- Strong experience with SQL, dbt, Airflow, and core database concepts.
- Experience with building and maintaining API integrations with third-party data providers. 
- Experience with designing and implementing data pipelines.
- Strong problem-solving and analytical skills.
- Excellent communication and collaboration skills.
- Experience with big data warehouses like BigQuery, Redshift, or Clickhouse.
- Experience with data visualization and analysis tools such as Metabase, Tableau or Power BI is a plus.
- Familiarity with cloud platforms such as AWS or GCP is a plus.

If you are passionate about data infrastructure and analytics and are excited about the opportunity to work with a talented team to deliver high-quality data products, we want to hear from you! Apply now to join our team as an Analytics Engineer.

Role : Senior Customer Scientist 

Experience : 6-8 Years 

Location : Chennai (Hybrid) 
 
 

Who are we? 
 
 

A young, fast-growing AI and big data company, with an ambitious vision to simplify the world’s choices. Our clients are top-tier enterprises in the banking, e-commerce and travel spaces. They use our core AI-based choice engine  maya.ai , to deliver personal digital experiences centered around taste. The  maya.ai  platform now touches over 125M customers globally. You’ll find Crayon Boxes in Chennai and Singapore. But you’ll find Crayons in every corner of the world. Especially where our client projects are – UAE, India, SE Asia and pretty soon the US. 
 
 

Life in the Crayon Box is a little chaotic, largely dynamic and keeps us on our toes! Crayons are a diverse and passionate bunch. Challenges excite us. Our mission drives us. And good food, caffeine (for the most part) and youthful energy fuel us. Over the last year alone, Crayon has seen a growth rate of 3x, and we believe this is just the start. 
 

 
We’re looking for young and young-at-heart professionals with a relentless drive to help Crayon double its growth. Leaders, doers, innovators, dreamers, implementers and eccentric visionaries, we have a place for you all. 
 

 
 

Can you say “Yes, I have!” to the below? 
 
 

1. Experience with exploratory analysis, statistical analysis, and model development 
    

1. Knowledge of advanced analytics techniques, including Predictive Modelling (Logistic regression), segmentation, forecasting, data mining, and optimizations 
    

1. Knowledge of software packages such as SAS, R, Rapidminer for analytical modelling and data management. 
    

1. Strong experience in SQL/ Python/R working efficiently at scale with large data sets 
    

1. Experience in using Business Intelligence tools such as PowerBI, Tableau, Metabase for business applications 
    

 
 

 

Can you say “Yes, I will!” to the below? 
 
 

1. Drive clarity and solve ambiguous, challenging business problems using data-driven approaches. Propose and own data analysis (including modelling, coding, analytics) to drive business insight and facilitate decisions. 
    

1. Develop creative solutions and build prototypes to business problems using algorithms based on machine learning, statistics, and optimisation, and work with engineering to deploy those algorithms and create impact in production. 
    

1. Perform time-series analyses, hypothesis testing, and causal analyses to statistically assess the relative impact and extract trends 
    

1. Coordinate individual teams to fulfil client requirements and manage deliverable 
    

1. Communicate and present complex concepts to business audiences 
    

1. Travel to client locations when necessary  

 

 

Crayon is an equal opportunity employer. Employment is based on a person's merit and qualifications and professional competences. Crayon does not discriminate against any employee or applicant because of race, creed, color, religion, gender, sexual orientation, gender identity/expression, national origin, disability, age, genetic information, marital status, pregnancy or related.  
 
 

More about Crayon:  https://www.crayondata.com/   
 

More about  maya.ai :  https://maya.ai/   

 

 

Hello
Our esteem client MITS are looking for MSBI developer as per below JD

BI Developer

 

Roles and Responsibilities:

• Comprehensive knowledge of SQL
• Expertise as a Microsoft BI Developer (SQL Server, SSIS)
• Experience and understanding of build and deploy processes
• A structured approach to software development (agile or waterfall), and a thorough understanding of the full software development lifecycle
• Knowledge and experience in experience banking
• Contribute to planning and estimation of sprints, features and releases
• Integrate new data sources using SQL, SSIS and C#
• Contribute to the testing and UAT phases
• In addition SQL Server 2014, Integration Services, Analysis Services, and Reporting Services (SSIS, ), Microsoft .NET, Tableau, Power BI, Data warehouse design

 

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

1.     Around 3+ years of Experience

• Strong knowledge in Power BI (DAX + Power Query + Power BI Service + Power BI  Desktop
• Visualizations) and Azure Data Storages.
• Should have experience in Power BI mobile Dashboards.
• Strong knowledge of SQL.
• AAS Data model Deployment in Azure, Querying data from AAS to build Reports
• Experience in developing, optimizing, and administering Tabular Models in 'Azure Analysis service'.

• Design and Create AAS/OLAP/ Tabular cubes and automate processes for analytical needs.
• Good knowledge of DWH concepts.  
• Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using DAX functions in - Azure Analysis service

 

JD of the Scrum Master.

 

Along with Scrum Master we need couple of BI developers skilled in Power BI with 3-4 Years of relevant experience in BI and 1+ years of experience in Power BI.

• Responsible for handling the scrum process in a POD structure with coordination of POD team and product owner in Agile methodology
• Supporting the Product Owners to groom and maintain the product backlog in good shape and make them ready for the next sprint
• Facilitating discussion, administrating, and conflict resolution to get the work done including monitoring, tracking and communication to relevant stakeholders.
• Follow the scrum rituals such as sprint planning, daily scrum, stand-up meetings, facilitate & scheduled meetings, demo, decision-making process etc.

 

  Competencies

• Overall 2-4 years of IT project management and delivery experience with 2+ years of Scrum Master experience in data analytics projects
• Ability to take and understand the commitment to deliver the product on time
• Applicable knowledge of the technologies used by the team, for example in Data Analytics/Data Science area
• Planning and problem solving with product management and delivery teams
• Certified Scrum Professional

Experience developing new PowerApps model and canvas driven apps as well as enhancing existing apps.
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

JD for Power BI Architech. Need someone with 5-7 years’ experience in Power BI . The person needs to have good communication and should have 2-3 projects in Power BI proven track record on Enterprise Data Warehouse & BI Solution Implementation with last 5 years as a BI / Data Architect. * Hands-on as well as a big picture thinker with sound knowledge on BI Architecture & Framework, Data Integration & Workflow, BI Strategy & Roadmap, BI Solution re-engineering etc.. * Rich Experience in Data Modeling, Data Integration, Reporting & Analytics, Reference Data, ETL & BI Tools, Data Governance & Security etc.. * Any experience in Big Data, Hadoop & NoSQL Implementations would be a plus * Agile development methodologies * Strong Consulting Experience * Excellent Verbal & Written Communication Skills * Should have hands-on experience on both Data integration / ETL and BI Reporting implementations * Experience in end-to-end data warehouse implementations as a Solution Architect * Experience in data modelling.