Company Description Lewis Electric was originally opened by a couple that relocated here in Granville Co. from the New York area. We were one of the first Electrical and Plumbing companies in this area. Lewis Electric and Plumbing was involved in providing power and indoor plumbing to most the houses in the rural areas of the county during the mid 40nd early 50p class="title_p"> Nelson Wilson soon came to work and learn the business from the owners. During the years that followed he bought and moved the company from the Main Street location to the present 912 Williamsboro Street location. As the business continued to grow all of the family members were soon working here.
It is here where we all learned how important family and customers are.
Job Description The Data Analyst role will be working with several facets of the Lewis Electric of Oxford data environment. The role will primarily facilitate the member selection process into Lewis Electric of Oxfordeekly sales emails. We use proprietary technology and programs to build these lists according to very specific criteria. The role will creatively determine how to meet these requirements while also guaranteeing the delivery of contractual quantities.
The role will also involve reporting and analytics on the relevant member populations, as well as special ad-hoc deep statistical analyses.
Specifically, the duties and responsibilities of the new role are the following:
Essential Functions: - Apply the day-to-day logistics of Lewis Electric of Oxfordomplex email marketing function. Lewis Electric of Oxford emails are highly targeted to the individual member
- Create email campaigns based on Sales targeting using SFMC and other in house tools
- Understand the Lewis Electric of Oxford data ETL processes
- Work closely with Sales and Client Services to ensure the marketing visions of the campaigns are realized through the most appropriate targeting.
- Develop reporting based on member registration and interaction with the site/email campaigns
- Prepare and maintain weekly, monthly, quarterly reports.
- Pull counts based on various criteria required by sales and client services team.
- Leverage statistical tools such as R/SPSS to analyze and identify insights on email campaigns to personalize future targeting.
Qualifications
Qualifications: - Bachelor's in a Quantitative Field
- Excellent verbal and written (reports, presentations, direct mail, etc.) skills
Additional Information Specific Skills/Attributes:
- Fluent in SQL-based language, preferably Vertica
- Comfortable using GUIs to develop queries
- Comfortable with statistical tool, preferably R.
- Advanced excel (pivots and vlookups)
- Salesforce, especially programming, a pluserience with SFMC ExactTarget is a plus
- Experience with Visualization tools such as Qlik
- Basic understanding of ETL processes and data warehouse concepts
- Excellent communication skills
- Strong analytical and problem-solving skills
- Must enjoy working in a team environment
- Excellent attention to detail
