Solutions Developer (Business Intelligence) at Scremer · Remote, Hyderabad, Indore · 3 - 5 years · ₹10L - ₹15L / yr · Bootstrapped · Remote friendly · Posted 7 Jun 2024
Must have
Proven understanding of Data Modelling and Analytics
Advanced knowledge and experience working with relational and NOSQL databases as well as data warehousing.
Experience of working with Microsoft’s BI technology stack SSIS, SSRS, SSAS (tabular model), Power BI, Power Query, Excel.
Experience with Microsoft Azure Analytics tools and technologies such as Azure Synapse Analytics, Azure Data Bricks, HD Insight, Azure Data Factory, Azure Machine learning, Azure Stream Analytics, Azure Data Lake, Azure Analysis Services, Event Hubs, Azure Data Explorer, Azure Data Share, Azure Time Series Insights.
Good interpersonal, verbal, and written communication skills with a proven ability to explain complex technical ideas and problems clearly to non-experts
Good to have
Self-motivated, enthusiastic, and strong problem solving skills
Cultural awareness and experience of delivering solutions internationally working in an agile project delivery environment.
Experience maintaining source control in Git or Azure DevOps
Strong experience with various Software Development Life cycles (SDLC) methodologies: Agile or Standard waterfall initiatives
Proven experience working with various Project Management practices and disciplines
Demonstrated strong interpersonal skills to augment a close working relationship with cross functional teams
A history of designing and implementing reporting solutions that are both functional and engaging
Meticulous attention to detail
Proficiency in DAX, MDX, Python/Scala/Spark SQL
Non-profit sector knowledge/experience
Cosmos DB
Machine Learning
Roles & Responsibilities
Provide the organisation with accurate and timely BI solutions based on requirements gathered through business partnering activities
Maintain and support existing BI solutions
Proactively source new and innovative solutions that provide clear business value and construct ‘proof of concepts’ to demonstrate the new solutions
Proactively identify any technical project risks/issues related to BI
Estimate and deliver BI project tasks to agreed prioritisation and timeframes
Support the IT Service Delivery team with the BI reporting environment
Assist product owners in designing, agreeing, implementing and managing changes to the BI environment
Maintain accurate technical documentation
Communicate data and insights
Shubham Vishwakarma
Full Stack Developer - Averlon
About Scremer
About
Company social profiles
Similar jobs (1)
Business Intelligence Analyst - 2
Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.
Job Summary:
The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products.
This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst – 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.
Key Responsibilities:
· Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.
· Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimization, stored procedures, views, and complex queries.
· Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security.
· Support and troubleshoot SSAS Tabular and Multidimensional models, including processing, calculations, relationships, security, and performance.
· Develop and troubleshoot advanced SSRS/paginated reports, including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats.
· Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.
· Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.
· Analyze and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.
· Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.
· Perform end-to-end root-cause analysis and performance optimization across the BI technology stack.
· Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.
· Provide technical guidance and mentoring to BI Analyst – 1 team members and contribute to BI best practices and documentation.
Required Skills & Qualifications:
· 5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.
· Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modeling.
· Advanced knowledge of SQL Server and T-SQL, including query optimization and performance tuning.
· Strong experience with SSRS and enterprise reporting.
· Experience with SSAS Tabular and/or Multidimensional models.
· Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.
· Experience working with OData and enterprise data integration.
· Strong understanding of Data Warehousing, Datamarts, Automart, ETL/ELT, and data modeling.
· Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.
· Strong analytical, troubleshooting, and root-cause analysis skills.
· Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.
· Experience with tools such as DAX Studio, Tabular Editor, Performance Analyzer, Query Store, or SQL Profiler is an advantage.
- Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon