Technology Data Analyst

Posted 2 Days Ago
Irving, TX
1-3 Years Experience
Agency
The Role
The Data Analyst is responsible for executing marketing, reporting, and analytics processes. Key duties include creating complex ETL processes, collaborating with clients, developing data processing procedures, troubleshooting data issues, ensuring quality deliverables, and contributing to project estimations while meeting deadlines.
Summary Generated by Built In

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

Pl/Sql
Python
SQL
The Company
HQ: Irving, TX
318 Employees
On-site Workplace
Year Founded: 1979

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.

Jobs at Similar Companies

Caxy Logo Caxy

Project Manager/Project Owner

Agency • Artificial Intelligence • Enterprise Web • Mobile • Software
Hybrid
Chicago, IL, USA
45 Employees

Digible Logo Digible

Office Coordinator / Receptionist

AdTech • Agency • Artificial Intelligence • Digital Media • Marketing Tech • Social Media • PropTech
Easy Apply
Englewood, CO, USA
120 Employees

JuiceMedia.AI Logo JuiceMedia.AI

Office Coordinator

AdTech • Agency • Digital Media • Machine Learning • Marketing Tech • Analytics • Big Data Analytics
Hybrid
Marina del Rey, CA, USA
68 Employees
38K-62K Annually

Similar Companies Hiring

Caxy Thumbnail
Software • Mobile • Enterprise Web • Artificial Intelligence • Agency
Chicago, IL
45 Employees
Digible Thumbnail
Social Media • PropTech • Marketing Tech • Digital Media • Artificial Intelligence • Agency • AdTech
Englewood, CO
120 Employees
JuiceMedia.AI Thumbnail
Marketing Tech • Machine Learning • Digital Media • Big Data Analytics • Analytics • Agency • AdTech
Marina Del Rey, CA
68 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account