WTW inc.
Data Analyst - Marketing Development
WTW inc., Salt Lake City, Utah, United States, 84193
The Role:Reporting to the Marketing Operation Development Manager, the Analyst role is responsible for working within the Marketing Operations Development team to design, build and maintain applications that support member marketing communication execution and automation. This is an entry-level role with an opportunity to gain experience developing applications and advance SQL and developer skills. The position requires writing and debugging code, so we are looking for applicants with a basic understanding of Java, HTML, and Python. This role also requires experience using SQL to update and retrieve data. This position is a remote position, but must be within a reasonable distance to our office in Salt Lake City, Utah. If you want to build your current skills, learn new systems and solve problems creatively, this is your opportunity.ResponsibilitiesWork as part of the Marketing Operations Development team to build marketing automation.
Utilize Python, Smartsheet, Azure, and Microsoft SQL Server to develop solutions based on stakeholder needs
Follow the peer review standards in place to reduce errors
Brainstorm and operationalize ideas for automation to streamline current processes
Create branches in GitHub with requirements template for developer consistency
Manage version control through development, quality assurance, user acceptance testing, and production environments
Ensure the development process is auditable at every step
Write and update SQL query templates for mail file creation
Work with large data sets to create reporting dashboards and manage production files
Requirements2+ years using SQL to update and retrieve data; OR
2+ years working in Python
Have a working knowledge of B2C channel outputs including:
Email Service/API (B2C enterprise campaigns, on-demand, and personalized notification through a service provider, such as MailChimp, SendGrid, etc.)
SMS text service (push notifications, enterprise messaging, on-demand, and personalized two-way interaction).
Possess a thorough understanding of API function and setup; creation and execution of APIs between software/systems specific to digital B2C marketing.
Knowledge of software testing methodologiesExperience or the willingness to learn low-code platforms
Flexibility; ability to adapt to new processes and tools. Willingness to learn new software, systems, and platforms.
Bachelor's degree preferred or 3+ years of Business Analysis experience or any equivalent combination of experience and training which provided the required knowledge, understanding, and skill sets needed to perform the role.
Bonus PointsComfortable using InDesign, SmartCommunications, Quadient, or similar software
Note: Employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity. This position will remain posted for a minimum of three business days from the date posted or until a sufficient/appropriate candidate slate has been identified.Compensation and BenefitsBase salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that salaries may vary for different individuals in the same role based on several factors, including but not limited to location of the role, individual competencies, education/professional certifications, qualifications/experience, performance in the role and potential for revenue generation (Producer roles only)Company BenefitsWTW provides a competitive benefit package which includes the following (eligibility requirements apply):Health and Welfare Benefits:
Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Group Accident, Group Critical Illness, Life Insurance, AD&D, Group Legal, Identify Theft Protection, Wellbeing Program and Work/Life Resources (including Employee Assistance Program)
Leave Benefits:
Paid Holidays, Annual Paid Time Off (includes paid state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, ADA, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off (https://cdn-static.findly.com/wp-content/uploads/sites/1862/2023/01/31091722/Washington-State-Time-Off.pdf) (
Washington State only
)
Retirement Benefits:
Contributory Pension Plan and Savings Plan (401k). All Level 38 and more senior roles may also be eligible for non-qualified Deferred Compensation and Deferred Savings Plans.
At WTW, we trust you to know your work and the people, tools and environment you need to be successful. The majority of our colleagues work in a hybrid style, with a mix of remote, in-person and in-office interactions dependent on the needs of the team, role and clients. Our flexibility is rooted in trust and hybrid is not a one-size-fits-all solution.We understand flexibility is key to supporting an inclusive and diverse workforce and so we encourage requests for all types of flexible working as well as location-based arrangements. Please speak to your recruiter to discuss more.EOE, including disability/vets (https://cdn-static.findly.com/wp-content/uploads/sites/1240/2021/06/14082050/EEO-Policies-for-WTW-Careers-site-2021.pdf)
Utilize Python, Smartsheet, Azure, and Microsoft SQL Server to develop solutions based on stakeholder needs
Follow the peer review standards in place to reduce errors
Brainstorm and operationalize ideas for automation to streamline current processes
Create branches in GitHub with requirements template for developer consistency
Manage version control through development, quality assurance, user acceptance testing, and production environments
Ensure the development process is auditable at every step
Write and update SQL query templates for mail file creation
Work with large data sets to create reporting dashboards and manage production files
Requirements2+ years using SQL to update and retrieve data; OR
2+ years working in Python
Have a working knowledge of B2C channel outputs including:
Email Service/API (B2C enterprise campaigns, on-demand, and personalized notification through a service provider, such as MailChimp, SendGrid, etc.)
SMS text service (push notifications, enterprise messaging, on-demand, and personalized two-way interaction).
Possess a thorough understanding of API function and setup; creation and execution of APIs between software/systems specific to digital B2C marketing.
Knowledge of software testing methodologiesExperience or the willingness to learn low-code platforms
Flexibility; ability to adapt to new processes and tools. Willingness to learn new software, systems, and platforms.
Bachelor's degree preferred or 3+ years of Business Analysis experience or any equivalent combination of experience and training which provided the required knowledge, understanding, and skill sets needed to perform the role.
Bonus PointsComfortable using InDesign, SmartCommunications, Quadient, or similar software
Note: Employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity. This position will remain posted for a minimum of three business days from the date posted or until a sufficient/appropriate candidate slate has been identified.Compensation and BenefitsBase salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that salaries may vary for different individuals in the same role based on several factors, including but not limited to location of the role, individual competencies, education/professional certifications, qualifications/experience, performance in the role and potential for revenue generation (Producer roles only)Company BenefitsWTW provides a competitive benefit package which includes the following (eligibility requirements apply):Health and Welfare Benefits:
Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Group Accident, Group Critical Illness, Life Insurance, AD&D, Group Legal, Identify Theft Protection, Wellbeing Program and Work/Life Resources (including Employee Assistance Program)
Leave Benefits:
Paid Holidays, Annual Paid Time Off (includes paid state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, ADA, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off (https://cdn-static.findly.com/wp-content/uploads/sites/1862/2023/01/31091722/Washington-State-Time-Off.pdf) (
Washington State only
)
Retirement Benefits:
Contributory Pension Plan and Savings Plan (401k). All Level 38 and more senior roles may also be eligible for non-qualified Deferred Compensation and Deferred Savings Plans.
At WTW, we trust you to know your work and the people, tools and environment you need to be successful. The majority of our colleagues work in a hybrid style, with a mix of remote, in-person and in-office interactions dependent on the needs of the team, role and clients. Our flexibility is rooted in trust and hybrid is not a one-size-fits-all solution.We understand flexibility is key to supporting an inclusive and diverse workforce and so we encourage requests for all types of flexible working as well as location-based arrangements. Please speak to your recruiter to discuss more.EOE, including disability/vets (https://cdn-static.findly.com/wp-content/uploads/sites/1240/2021/06/14082050/EEO-Policies-for-WTW-Careers-site-2021.pdf)