Senior MSBI Developer

Company Description

BETSOL is a cloud-first digital transformation and data management company offering products and solutions to both enterprises and consumers. BETSOL’s Data Management product lines include Rebit (Rebitgo.com) and Zmanda (Zmanda.com). BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for our customers. Our engineering team, with its several patents, delivers award-winning products and solutions in over 40 countries. Our work locations are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India. We take pride in being an employee centric organization. Learn more at betsol.com

Job Description

Candidate Must Have:
- 4-6 yrs Experience in Business Intelligence along with database design and integration experience with SQL Server databases
- Strong experience of SQL Server 2016/Azure databases
- Data Marts / Data Warehouse Solution Design, Dimensional Modeling (Kimball Methodology)
- ETL (Extraction, Transformation and Loading) Design & Development (Microsoft SSIS, ADF & T-SQL)
- Report and Dashboard Development (T-SQL, DAX, Microsoft SSRS and Microsoft Power BI)

Preferred Skills:
- Azure Data Factory & Data Lake
- Analytics/ OLAP Cube Development (Microsoft SSAS/AAS, MDX - Multidimensional Model, DAX - Tabular Model), Microsoft Fabric

Primary responsibilities:

• Demonstrate good knowledge and skills in designing and implementing Data Marts, Data Warehouse, BI and Dashboard solutions
• Exhibit hands-on skills in data modelling
• Understanding of database architecture, security and deployment strategies
• Data components development using SQL Server T-SQL, SQL stored procedures, triggers, views and SQL Agent Jobs
• ETL Design & Development using Microsoft SSIS / Azure Data Factory (Optional)
• Developing Cubes using SSAS Tabular Model and querying data using Excel and Power view
• Development and deployment of reports using SQL Server Reporting Services and PowerBI that represent different findings and insights from the data using interactive charts and maps etc.
• Connect to multiple datasets to bring all the relevant data together in one place and create reports that provide a consolidated view of the different sources.
• Assist in creating advanced visualization like heat maps and many other Using Microsoft Power BI publisher for Excel, to take snapshots from insights in Excel, like   PivotTables, Charts, and ranges and pin them to dashboards in Power BI
• Uploading of Power BI reports to Power BI online service, implement security and audit # Scheduling of Power BI Data Sets in online version and knowledge of viewing dashboards in Power BI mobile version
• Helping business with Self-service BI and Analytics
• Designing, developing and testing data transformations for reporting and interfaces between systems
• Ability to develop systematic testing plans for unit testing

Soft Skills:

• Ability to read, analyse, and interpret general business documentation, technical specifications and project management documentation
• Data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs
• Good analytical, logical reasoning and problem-solving skills
• Good interpersonal, written, and oral communication skills
• Self-motivated and directed, with keen attention to detail
• Able to prioritize and execute tasks in a high-pressure environment # Experience working in a team-oriented, collaborative environment 

Qualifications

BE/BTECH in Information Technology, Computer Science, or related field

Additional Information

All your information will be kept confidential according to EEO guidelines.