SQL Developer - ETL/SAS Viya

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 resources

Technical 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 (progress/roadblocks/etc.)

- 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 relevant

Candidate 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