Senior SQL 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:
- 6+ years experience in core database design, development, performance tuning, and optimization
- Strong experience with SQL Server 2016/Azure databases
- ETL (Extraction, Transformation and Loading) Design & Development (Microsoft SSIS/ADF & T-SQL)

Preferred Skills:

- Knowledge of Data Marts / Data Warehouse Solution Design, Dimensional Modeling (Kimball Methodology)

Primary responsibilities:

• Understanding of database architecture, security, and deployment strategies
• Demonstrate good knowledge and skills in designing and implementing Data Marts, Data Warehouse, BI and Dashboard solutions
• Exhibit hands-on skills in data modelling
• 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)
• Connect to multiple datasets to bring all the relevant data together in one place
• 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
• 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, analyze, 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.