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