SQL Developer

Roles and Responsibilities :- Manage SQL development tasks and ensure timely delivery of project milestones, coordinating with onshore and offshore teams.- Develop, optimize, and maintain complex SQL queries, stored procedures, and ETL processes for data extraction, transformation, and loading.- Perform data validation, cleansing, and quality checks to ensure data accuracy and integrity.- Monitor database performance, troubleshoot issues, and implement optimization techniques such as indexing and query tuning.- Schedule and oversee regular backup, restore operations, and support end-user connectivity and access issues.- Assist in migration activities involving SQL databases and SAS datasets, ensuring seamless transitions and data integrity.- Prepare and maintain comprehensive technical documentation for SQL scripts, workflows, and standard operating procedures.- Collaborate closely with development, testing, and business teams to translate requirements into effective database solutions.- Communicate project status, technical concepts, and challenges clearly with clients and stakeholders, including preparing presentation materials.- Mentor junior team members, foster knowledge sharing, and demonstrate ownership and proactive problem-solving in a fast-paced environment.- Monitor project progress and ensure adherence to client expectation- Communications, including deck writing- Coordination of all sub-team efforts; Creation of project plan, define milestones, timelines, review plan with the team- Delivery of output- Facilitation and gathering of client feedback on problem structuring- Understand and define business problems, get all background information and collect relevant data points- Create solution hypothesis and get client buy in, discuss and align on end objective, staffing need, timelines and budget- Effective management of frequency of feedback loop with offshore resourcesTechnical skills :- Experience SAS 9.4 (base and advance)- Experience SAS Viya 3.3,3.5 and 4 (base and advance)- Experience in migration from SAS EG & SAS Viya:- Expertise in converting .EGP file to .Flow in Viya- Experienced in scheduling regular backups/restore strategies.- Experienced in reading SAS logs to find out root cause issues.- Experienced in preparing documentation of Installation and standard operating procedures- Scheduling the jobs and monitoring for day-to-day activities, escalating problems to the tech support if any issues arise.- Support end-users with access and connectivity issues.- Establish a formal, regularly scheduled backup process.- Working with Development and Testing teams to prioritize and handle issues to resolve quickly.- Extract, transform, and load (ETL) data from various sources into SAS datasets.- Perform data quality checks and implement data cleansing and validation procedures.- Optimize data processing and storage for efficient performance.Soft skills :- Strong work ethic and desire to product quality results- Consistently and proactively communicates (verbally/written) to stakeholders Continuous Improvement mindset and approach to work product- Ability to take complex subjects and simplify it to less technical individuals- Provides clear documentation of processes, workflows, recommendations, etc.- High level of critical thinking capabilities- Organized and has the ability to manage work effectively, escalating issues as appropriate- Takes initiative & is a self-starter- Displays ownership of their work (quality, timeliness)- Seeks to become an expert in their field and shares their expertise through recommendations, proactive communications/actions and peer sharing/coaching where relevantCandidate Profile :- Bachelors/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply- 4+ years experience, preferably in insurance analytics- Experience in working in dual shore engagement is preferred- Must have experience in managing clients directly- Superior analytical and problem solving skills- Demonstrated leadership ability and willingness to take initiative- Strong record of achievement, solid analytical ability, and an entrepreneurial hands-on approach to work- Outstanding written and verbal communication skills- Able to work in fast pace continuously evolving environment and ready to take up uphill challenges- Is able to understand cross cultural differences and can work with clients across the globe (ref:hirist.tech)