Data Analyst Intern

We are a leading home services provider and we are looking for a knowledgeable and highly motivated individual to join our team in a part time capacity as an Intern working with our Data Analytics team as a SQL Programmer.

The Data Analyst SQL Programmer will assist in developing, migrating, and testing SQL-based stored procedures and views, either in MS SQL Server Studio or in the AWS Redshift environment, as well as validating the results on the Looker reporting tool. The role will have the opportunity to work in reporting automation, involving Python programming.

This role has the opportunity to gain deep into Energy industry business reporting, automation & analytics knowledge and technical skills related to AWS services and Looker.

The role can be remote with occasional in-person meetings as needed at the Stamford, CT location.

Responsibilities:

• Review existing stored procedures by each subject area, and update the procedures for new mapping / codes
• Test the updated stored procedures in the development mode to ensure successful execution
• Validate the results against control data and reports
• Work closely with the manager to review code changes and run demos
• Help to deploy validated stored procedures / views to production
• Document the changes implemented for future reference
• Assist with report automation using Python programming
• Ad hoc analytics or reporting as needed

Requirements:

• Microsoft Excel
• SQL
• Basics of Python
• Ability to multi-task and meet strict daily deadlines

The following skills will have to developed, if the candidate does not already possess SQL and stored procedures

• AWS Glue, Scheduling, DMS etc.
• Python
Looker
• - Look ML
Analytic techniques
• - Simple regression, Logistic regression, Segmentation methodologies

This is a part-time role requiring approximately 20 hours of weekly work. Schedule to be determined.

The salary range is between $17 - $19 per hour.

We are proud to be an equal opportunity employer and are committed to a drug and alcohol free workplace.