Senior SQL Developer

Job Purpose:

We are looking for a Senior SQL Developer to join our growing team of BI & analytics experts. The hire will be responsible for expanding and optimizing our data and data queries, as well as optimizing data flow and collection for consumption by our BI & Analytics platform. The ideal candidate is an experienced data querying builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The SQL Developer will support our software developers, database architects, data analysts and data scientists on data and product initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. The hire must be self-directed and comfortable supporting the data needs of multiple systems and products. The right candidate will be excited by the prospect of optimizing our company’s data architecture to support our next generation of products and data initiatives.

Job Responsibilities:

Essential Functions:

Requirements:

• Create and maintain optimal SQL queries, Views, Tables, Stored Procedures.
• Work together with various business units (BI, Product, Reporting) to develop data warehouse platform vision, strategy, and roadmap.
• Understand the development of physical and logical data models.
• Ensure high-performance access to diverse data sources.
• Encourage the adoption of an organization’s frameworks by providing documentation, sample code, and developer support.
• Communicate progress on the adoption and effectiveness of the developed frameworks to department head and managers.

Required Education and Experience:

• Bachelor’s or Master’s degree or equivalent combination of education and experience in relevant field.
• Understanding of T-SQL, Data Warehouses, Star Schema, Data Modeling, OLAP, SQL and ETL
• Experiencing in Creating Table, Views, Stored Procedures.
• Understanding of several BI and Reporting Platforms, and be aware of industry trends and direction in BI/reporting and applicability to the organization’s product strategies.
• Skilled in multiple database platforms, including SQL Server and MySQL.
• Knowledgeable of Source Control and Project Management tools like Azure DevOps, Git, and JIRA
• Familiarity of using SonarQube for clean coding T-SQL practices.
• Familiarity with DevOps best practices and automation of documentation, testing, build, deployment, configuration, and monitoring
• Communication skills: It is vital that applicants have exceptional written and spoken communication skills with active listening abilities to contribute in making strategic decisions and advise senior management on specialized technical issues, which will have an impact on the business
• Strong team building skills: it is crucial that they also have team building ability to provide direction for complex projects, mentor junior team members, and communicate the organization’s preferred technologies and frameworks across development teams.

Experience: A candidate for this position must have had at least 5+ years working in a data warehousing position within a fast-paced and complex business environment, working as a SQL Developer. The candidate must also have had experience developing schema data models in a data warehouse environment. The candidate will also have had experience with full implementation of system development lifecycle (SDLC).

The candidate must also have a proven and successful experience working with concepts of data integration, consolidation, enrichment, and aggregation. A suitable candidate will also have a strong demonstrated understanding of dimensional modeling and similar data warehousing techniques as well as having experience working with relational or multi-dimensional databases and business intelligence architectures.

Analytical Skills: As expected, a candidate for the position will have passion as well as skill in research and analytics as well as a passion for data management tools and technologies. The candidate must have an ability to perform detailed data analysis, for example, in determining the content, structure, and quality of data through the examination of data samples and source systems. The hire will additionally have the ability to troubleshoot data warehousing issues and quickly resolve them.

Expected Competencies:

• Detailed oriented with strong organizational skills
• Ability to pay attention to programming style and neatness
• Strong English communication skills, both written and verbal
• Ability to train, mentor junior colleagues with patience with tangible results

Work Timings :

This is a full-time position. Days and hours of work are Monday through Friday, and should be flexible to support different time zones ranging between 12 PM IST to 9PM IST, Work schedule may include evening hours or weekends due to client needs per manager instructions This role will be working in Hybrid Mode and will require at least 2 days’ work from office at Hyderabad. Occasional evening and weekend work may be expected in case of job-related emergencies or client needs.

EEO Statement

Cendyn provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Cendyn complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Cendyn expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Cendyn’s employees to perform their job duties may result in discipline up to and including discharge.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.