Fast-growing entrepreneurial online training company seeks to add an experienced SQL Developer with strong Data Analysis skills to its team. Your primary focus will be to support email deliverability analytics in the healthcare industry by preventing and resolving delivery challenges with the company’s high volume email campaigns. This is a perfect opportunity for someone who loves maintaining, analyzing, auditing, and interpreting data on the technical side of an email marketing environment.

You will identify opportunities for optimizing overall email pipeline health, contact flow, domain reputation, email deliverability, and engagement. Your goal will be to transform data from multiple sources into actionable insights that promote organizational growth, and informed decision-making at all levels.

Key Responsibilities include:

• Generate intuitive reports for executive leadership and non-technical team members that effectively communicate trends, patterns, and predictions using relevant data extracted from multiple repositories and platforms.
• Analyze data from our email and digital marketing pipelines to identify opportunities for optimizing overall pipeline health, pipeline flow, domain reputation, email deliverability, engagement, and conversion, while mitigating risk.
• Audit data stored and accessed by disparate platforms including internal databases, Email Service Providers (ESP’s), CRM systems, website CMS, Power BI, and Excel spreadsheets.
• Design, manage, and optimize complex queries and stored procedures using efficient code to support new and existing reporting requirements with a high degree of accuracy. Assist with data management by developing workflows, automations, and ETL procedures. Assist with the migration of data from legacy systems to new solutions.
• Work with leading ISPs, email blacklist operators and antispam providers to resolve deliverability issues.
• Track and report on overall email deliverability metrics and take appropriate action on emerging issues.

Requirements:

• Expert level proficiency with MS SQL Server (5+ years of T-SQL), including SSMS.
• Ability to write complex queries, stored procedures, and ETL processes for reporting, auditing, and cleansing. Ability to find and correct data errors by interacting directly with relational databases and third-party data sources.
• Expert level proficiency with MS Excel and the ability to create complex pivot tables, charts, and formulas with large underlying datasets.
• Ability to derive business intelligence from complex datasets and provide comprehensive actionable insights, enabling management to readily draw conclusions and make well informed business decisions.
• Values data integrity and has exceptional attention to detail such that inconsistencies are identified, prioritized, and addressed early on. Compelled to notice and act upon erratic data and illogical/inefficient processes.
• Ability to anticipate end-user needs, and consistently produce relevant, useful end user experiences.
• Strong problem solving and critical thinking skills, including the ability to communicate clearly and effectively with all levels of the organization. Ability to be readily understood by non-technical team members by expressing technical issues in common terms.
• Familiarity with MySQL, Dynamics CRM, Visual Studio, C#, REST API’s, Power BI, and DAX programming is a plus.

Healthcare Training Leader Values:

Healthcare Training Leader is a small, customer-centric and entrepreneurial minded team producing the most current, relevant and actionable content focused on solutions for small practices within the healthcare industry.

The culture at Healthcare Training Leader is built on our shared core values – People First, Own It, Tenacious Optimism, and Results. It is important that we all hold each other accountable to these values with every decision we make. These values should demonstrate who we are, not who we hope to be. They are defined as follows:

PEOPLE FIRST: Every decision we make should have some level of positive impact on our customers and/or team. We work hard and strive for balance between our lives in and out of the company.

OWN IT: When things are good, we celebrate. When mistakes are made, we stand up and are accountable for them, we work together to ferret out the issue and tackle it head on. We never hide from the truth.

TENACIOUS OPTIMISM: We do the best we can every time, and when that isn’t enough, we work harder & never give up on a project or mission if we believe in it. However, this doesn’t mean we wear blinders

RESULTS: The outcomes we achieve allow us to grow, identify opportunities, help our customers, and ensure a strong, supportive where we want to be.

We hire, fire, review, reward, and recognize our teammates based on these characteristics, so it’s essential that you share these values in order to be part of our team. We work hard to live and breathe these values, so if you don’t embody them, it will seriously stand out. Better to know now.

Job Type: Full-time

Pay: $70,000.00 per year

Benefits:

• Flexible schedule
• Health insurance
• Paid time off
• Tuition reimbursement

Compensation package:

• Bonus pay

Experience level:

• 5 years

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday
• No nights
• No weekends

Application Question(s):

• Are you able to write complex SQL Server queries and stored procedures without searching for syntax on the internet?
• How would you rate your skill at creating and analyzing Pivot Tables? Also, roughly how many Pivot Tables have you created in the past year?

Experience:

• Microsoft Excel: 5 years (Required)
• Microsoft SQL Server Management Studio (SSMS): 5 years (Required)

Work Location: Remote

Please Note :
caminobluff.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, caminobluff.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.