JOB SCOPE & PURPOSE
The Technology Data Analyst is responsible for supporting the creation and execution of marketing, reporting and analytics processes as defined by client. He/she is a subject matter expert on client's data sources and become intimately familiar with database, email and preference data including understanding key business rules that drive data outputs.
MAIN RESPONSIBILITIES
- Technically able to understand and create complex ETL processes.
- Work hand-in-hand with client
- Effectively utilizes programming tools and applications (SQL and ETL).
- Plays a role in thought leadership and uses strong consultative skills.
- Monitors quality control on deliverables prior to client distribution. Ensures the client team is following quality control procedures as applicable
- Based on business requirements, contributes to detailed technical requirements and specifications; identifies missing details in the business requirements and engages the appropriate resource(s) for clarification.
- Become an internal expert in ETL, CDI and complex Datamart Build services for campaign, reporting and analytics processes.
- Develops mapping and data processing procedures to import data from various data sources and populate the client database.
- Demonstrates knowledge of the data model and the data, to provide insights and recommendations.
- Develops data extracts and procedures to support internal and client (external) business analytics.
- Actively involved in troubleshooting data / data process anomalies and works with the team to efficiently identify solutions.
- Coordinates with cross-competency teams to ensure quality deliverables.
- Consistently follow best practices and standards defined by the team / organization.
- Contributes to the project estimation process.
- Multitasks through project execution and prioritizes accordingly, ensuring project deadlines are met and deliverables are completed in a timely fashion.
- Assists with the transition from project completion to ongoing production and production support
- Communicates requirements and status with other teams and competencies, as required on an ongoing basis.
EXPERIENCE & EDUCATION
- Bachelor's Degree in a plus
- 2 years technical experience in a data management role utilizing SQL and ETL tools
KNOWLEDGE & ABILITY
- Consultative approach to data management and able to make CDI recommendations to the client.
- Knowledge of direct mail and email marketing
- Marketing and business knowledge – not just technical view
- Knowledge of marketing Database structures
- Primary point-of-contact for problem escalation and resolution for data management functions
- Development Tools/Platforms
- Experience working in an Azure environment
- Proficiency with Informatica, or similar enterprise ETL tool experience
- Strong SQL, PL/SQL skills
- Knowledge of UNIX/LINUX experience
- Shell scripting experience (KSH, Bash, Perl, Python, etc.) is a plus
- Databases
- Exposure to enterprise databases required
- Oracle
- SQL Server 2005/2008 is a plus
- Methodologies
- Demonstrates the ability to follow a consultative approach to data management
- Demonstrates the ability to work within various methodologies, like Waterfall, Lean, or Agile, is a plus
- Demonstrates the ability and desire to learn new technical skills and tools
***We are a hybrid company working 3 days a week in office and 2 days a week at home. Candidates must live in the Irving, TX area and willing to be in office on required days
Top Skills
What We Do
Targetbase is a data-driven, strategic communications agency that provides marketing technology, business intelligence, analytics and creative services to its clients. Our agency believes that clients become stronger when they leverage the wealth of information consumers provide online every day.
Targetbase applies its experience in acquiring knowledge and key consumer insights and turn that into relevant data that its creative team can generate brand experiences that consumers want. The agency brings together direct marketing principles, the innovative nature of digital thinking and the intelligence of marketing analytics, all integrated in one agency backed by the Omnicom family.
The DAS Group of Companies, a division of Omnicom Group Inc. (NYSE: OMC), is a global group of marketing services companies. DAS includes over 200 companies in the following marketing disciplines: specialty, PR, healthcare, CRM, events, promotional marketing, branding and research. Operating through a combination of networks and regional organizations, DAS serves international, regional, national and local clients through more than 700 offices in 71 countries.