Job ID: | J318462 |
Job Title: | Data Management Expert |
Client: | To Be Discussed Later |
Location: | Long Island City, New York |
Contract Duration: | 12 Months |
Hourly Rate: | $80/hr W2 Contract |
Experience Level: | 15+ Years |
Interview Type: | Phone + Face to Face |
Domain Exposure: | IT/Software |
Work Authorization: | US Citizen, Green Card |
Preferred Employment: | Corp-To-Corp Contract, 1099/ Contract,Contract-To-Hire |
Current Status: | Open |
Location: Long Island City, NY; Elk Grove Village, IL; or Jacksonville, FL
This role would focus on supporting our digital data ingestion and validation process, as well as transformation and usage of the data for reporting and customer journey tracking. Position responsibilities include but not limited to setting up new data feeds for ingestion into multiple Hadoop platforms, conducting audits on the data, overseeing data quality, tracking feeds from source to source. For reporting, responsibilities include requirements gathering, validation of all metrics to ensure results are as expected and oversight of KPIs to ensure understanding of trending and patterns. This individual will leverage existing tools and systems to perform the above duties. The ideal analyst must be detail oriented and organized, having the ability to focus and keep track of numerous details across various systems.
• Work closely with Client IT, Vendors, Digital Data Management and other external third party vendors to coordinate file transfers, loads, validations and end to end tracking of files
• Work with Data Governance, BISO and any other teams to get approvals for data feed transfers
• Draft specifications and timelines as required to process files – includes requirements for file loads, transformations and any other special instructions
• Document process changes
• Develop validation audits for new data feeds and update existing data feed audits as required
• Perform data quality audits; identify data collection issues & gaps; recommend fixes
• Help team to maintain control and process manual documentation
• Operate as the subject matter expert on data sources from all systems that supply data to the platform
• Support reporting requirements and builds
• Support data warehousing requirements and builds
• Assist with reporting and Ad Hoc projects the team manages as needed
Qualifications
• Bachelor's Degree required
• Experience in marketing technology implementations with a focus on data
• Experience with web log, web analytics and/or digital behavioral data a must
• Extensive experience querying/selecting data in tools such as Cognos, Access, Hive or using query language such as SQL. Working knowledge of Excel macros, VBA, and Access a plus.
• Experience with data loads, data quality/validation and QA
• Experience with dashboard creation through tools such as Cognos, Platfora and Tableau
• Experience with data lineage through platforms and the creation of end to end data dictionaries
• Ability to create customer journey and analyze data for anomalies and trends and apply learnings to data in
support of a contact data warehouse
• Highly organized, proactive communicator, ability to manage, clearly articulate and navigate challenges that come up regularly
• Highly motivated/self-starter with a sense of ownership, willingness to learn, high degree of curiosity and desire to succeed
• Ability to form partnerships with internal/external stakeholders (vendors, marketing, decision management, technology, partner organizations, etc.)
• Must perform well in high pressure situations, balance competing priorities, and demonstrate the ability to work without direct supervision