ETL Developer

Company Description

BETSOL is a cloud-first digital transformation and data management company offering products and IT services to enterprises in over 40 countries. BETSOL team holds several engineering patents, is recognized with industry awards, and BETSOL maintains a net promoter score that is 2x the industry average. BETSOL’s open source backup and recovery product line, Zmanda (Zmanda.com), delivers up to 50% savings in total cost of ownership (TCO) and best-in-class performance. BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for its customers. BETSOL offices are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India. We take pride in being an employee-centric organization, offering comprehensive health insurance, competitive salaries, 401K, volunteer programs, and scholarship opportunities. Office amenities include a fitness center, cafe, and recreational facilities. 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 (Talend, Microsoft SSIS & T-SQL)

Preferred Skills:
– Azure Data Factory & Data Lake
– Analytics/ OLAP Cube Development (Microsoft SSAS/AAS, MDX – Multidimensional Model, DAX – Tabular Model)
– Report and Dashboard Development (Microsoft SSRS and Microsoft Power BI)

Primary responsibilities:
– Demonstrate advanced knowledge and skills in designing and implementing Data Marts, Data Warehouse, ETL and BI solutions 
– Expertise / Handson skills in data modelling, ETL and data components development using: SQL Server T-SQL, SQL stored procedures, triggers and views, SSIS, and SQL agent jobs
– Designing, developing and testing data transformations for reporting and interfaces between systems
– Understanding of database architecture, security and deployment strategies

Secondary Responsibilities:
– Developing Cubes using SSAS Models and querying data using Excel and Powerview
– Developing Reports using SSRS / PowerBI
– Helping business with Self-service BI and Analytics
– Hands on administrative experience with SQL Server 2016

Soft Skills:
– Ability to read, analyze, and interpret general business documentation, technical specifications and project management documentation
– Data gathering, research and analytical abilities so as 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.