Campaign Database Business Analyst

FastTek

Campaign Database Business Analyst

Campaign Database Business Analyst #438254
Job Description:
The energy at our company is contagious. We’re driven by our immense passion, as we constantly seek out challenges and identify new opportunities. We work hard to connect with our customers and earn their loyalty for life.  Bring your talent to our company – our opportunities for growth span the globe. We will give you the training and opportunities to unleash your ambition.
 
Responsibilities
  • Design, document, and produce complex direct marketing campaigns from a database perspective.
  • Know and manage all campaign business rules for a portfolio of campaigns.
  • Design and perform UAT to assure quality in data processing and campaign list production.
  • Develop custom/advanced SQL queries to extract, organize and analyze information in order to investigate issues, answer questions, create lists, forecast audience sizes, formulate solutions/recommendations, etc.
  • Design and create processes to derive new information from raw data in order to satisfy new business needs.
  • Serve as technical subject matter expert: understand underlying data, database, data processes and derivations in order to provide appropriate consultation to stakeholders.
  • Serve as liaison to business stakeholders in order to properly formulate business requirements, prepare campaign design documents, and facilitate production in the database.
  • Monitor daily inputs into the marketing database to ensure there are not unknown gaps and to assure quality/database integrity. Facilitate resolution of any disturbances to normal inflows.
  • Work on intra-departmental and cross-functional teams to support continuous improvement of overall campaign management process, including design of data environment, data integrity assurance, and process automation.
  • Collaborate with business, functional, technical, and application stakeholders to gain expertise on systems and data to ensure cross-functional system integration.
  • Prepare and track CRs for data / database processes. Perform UAT on solutions developed by third party database vendor.
  • Perform basic project management and oversee multiple work projects from inception through resolution without need for close supervision.
 
Required Skills/Experience
  • 8 years of work experience in database operations, direct marketing operations or related fields
  • Advanced SQL proficiency
  • Strong problem solving and analytical ability
  • Strong written and verbal communication skills
  • Ability to work under pressure
  • Ability to work on multiple projects in various stages of development, concurrently
  • High degree of personal accountability
 
Required Education
  • BA/BS in business, advertising, communications, computer science, or related quantitative or technical field
 
Required Skills
  • Data quality testing
  • Data analysis
  • Presentation Skills
  • Gather and translate business requirements into articulable data needs
  • Track down and document sourcing of data needs for use by IT and business partners
  • Transform business and technical metadata into external data product documents
  • Research and communicate data related inquires to non-technical business partners and skilled IT resources as a Data SME.
  • Profile and investigate structured and semi-structured datasets, reverse engineering based on business requests
  • Review and sign off on development unit testing and QA test results
  • Create and update internal project documents, including in-depth business metadata, UAT test plans and data integration
  • Perform UAT analysis and drive standardization of UAT testing with the lens of an external consumer
  • Create data quality metrics based off of UAT analysis and profiling and ensure implementation into final product.
  • Determine downstream and upstream impact analysis on new changes and updates
  • Ensure that data anomalies are detected and contained within thresholds
  • Perform root cause analysis of data discrepancies based on data quality metrics
  • Anticipate new issues and functionalities based on data quality trending.
 
Travel requirements
  • Occasional travel may be expected – once or twice a year to Detroit
  • Occasional travel between Detroit – Warren is expected.
 
Additional Info:
At FastTek Global, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories. Also, Doing the right thing is our mantra.  We act responsibly, give back to the communities we serve and have a little fun along the way.
 
We have been doing this with pride, dedication and plain, old-fashioned hard work for 24 years!
 
FastTek Global is financially strong, privately held company that is 100% consultant and client focused.
We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.
 
Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include:
 
  • Medical and Dental (FastTek pays majority of the medical program)
  • Vision
  • Personal Time Off (PTO) Program
  • Long Term Disability (100% paid)
  • Life Insurance (100% paid)
  • 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
 
Plus, we have a lucrative employee referral program and an employee recognition culture.
 
FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019 and 2020!
 
To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork
Follow us on Twitter: https://twitter.com/fasttekglobal
Follow us on Instagram: https://www.instagram.com/fasttekglobal
Find us on LinkedIn: https://www.linkedin.com/company/fasttek
You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/