Data Architect

Mindshare Usa, LLC Albany , NY 12201

Posted 2 months ago

Gain Theory has an opening in New York City, USA for a Data Architect. In this role you will work within a team dedicated to delivering cutting edge capabilities to our clients. In particular, we are looking for someone to enhance our data management and tool development capabilities. If you are looking for an opportunity to contribute to a growing company and work within a group of bright people driven to help our clients, read on

Gain Theory is a global marketing foresight consultancy that brings together data, analytics, technology solutions and consumer-insight capabilities to help marketing and insight professionals make smarter, faster, predictive business decisions.

Gain Theory is a part of GroupM and WPP. WPP is the world leader in communication services focusing on advertising, media investment management, consumer insight, public relations and branding among others. GroupM is WPP's consolidated media investment management operation. As such, it is the global number one media investment management group (RECMA 2010) with worldwide billing of $90.8Bn (RECMA July 2012) representing 32.7% global market share. Our clients are leaders in their respective industries and represent more than 330 of the Fortune 500, more than half of the NASDAQ 100 and more than 30 of the Fortune e-50.

Position Overview

The Data Architect is responsible for the support and implementation of database applications during the design, build and maintenance phases of large projects and prepare datasets for modeling. Candidates are expected to demonstrate the following skills/experience: hands-on skills in processing large data sets, familiarity with data structure, big-data concepts, cloud computing, open-source tools, and optimization techniques, excellent oral and written communication skills, client focus and the ability to support and enable teamwork, self-motivated and able to operate independently with limited guidance and direction.

Responsibilities

  • Design, build, and deploy database applications

  • Document data architecture requirements and QA guidelines

  • Retrieve, compile, and format large volumes of data

  • Utilize syndicated research tools to retrieve various types of data (macroeconomic, marketing, business, etc.)

  • Design and implement marketing performance dashboard using Tableau or other visualization tools

  • Write customized query to generate automatic periodical reports

  • Prepare and refresh datasets for the different cycles of Marketing Mix Modeling

  • Build applications writing SQL and/or SAS scripts to manipulate data and / or writing specific instructions for an off-shore programmer to write the scripts

  • Communicate with offshore implementation team during build phase. Write and track tasks to be completed by offshore.

  • Ensure applications are properly maintained by working with off-shore maintenance teams to ensure all cycles are properly completed, with strong emphasis on Quality Assurance of data and settings

  • Attend key design meetings and provide support

  • Assist implementation lead in resolving database architecture questions

  • Meet project timelines and deliverable schedules

Requirements

  • Understand data processing, i.e. Extract/Transform/Load

  • Good communication and written skills

  • Ability to work on multiple projects at a time

  • Experience with the full development life cycle of an application stack - from architecture through test and deployment.

  • Skills in SQL and proven experience working with at least one of the major databases platforms (SQLServer, Oracle, DB2, MySQL, Sybase, or Postgres)

  • Strong analytical skills; ability to analyze raw data, draw conclusions, and develop actionable recommendations

  • Organized, detail-oriented, QA-focused

  • Experience with visualization tools including Tableau, Spotfire, Omniscope and MicroStrategy will be highly valued

  • Proficient in system architectures (translating application design to operational requirements)

  • Prior knowledge of advertising ecosystem, understanding of marketing metrics, and analytical products offered as a service is preferred

  • Familiarity with scripting like R, Python, VBA, Perl and cloud computing techniques is preferred

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Cobol Technical Architect

NTT Data Corporation

Posted Yesterday

VIEW JOBS 4/18/2019 12:00:00 AM 2019-07-17T00:00 Req ID: 47841 At NTT DATA Services, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company's growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA Services and for the people who work here. NTT DATA Services currently seeks a COBOL Technical Architect to join our team in Albany, New York (US-NY), United States (US). Tasks include: * Provide general system design, application programming, documentation, coordination of changes, and unit and integration testing of programs, as well as guidance and mentoring of other staff. * Programming tasks include complete unit routines or functional routines that make up discrete parts of functional units. Programming will utilize structured COBOL. * Coordinate project activities among other team members, users, and/or requestors. Qualifications: * 84 months of experience as a technical expert centered around a technology, technologies or a portfolio of applications. * Designing and implementing Information Technology solutions; Candidate is able to provide leadership of large teams and/or extensive industry experience and is considered at the top of his/her field. * Minimum 84 months experience working directly with COBOL 74 and/or 85 programming on Unisys 2200 series or Clear Path, including monitoring production work; error diagnostic/debugging; system analysis & design; and program, unit and integrated testing. * Minimum 84 months experience utilizing Unisys ECL, TIP and DMS 2200/RDMS. * Minimum 36 months performing real-time transaction programming using structured programming techniques, including system analysis and design, code walk-throughs and integrated testing. * Minimum 36 months in coordinating project activities among other team members, users and/or requestors. * Minimum 36 months managing application systems development This position is only available to those interested in direct staff employment opportunities with NTT DATA, Inc. or its subsidiaries. Please note, 1099 or corp-2-corp contractors or the equivalent will NOT be considered. We offer a full comprehensive benefits package that starts from your first day of employment. About NTT DATA Services NTT DATA Services partners with clients to navigate and simplify the modern complexities of business and technology, delivering the insights, solutions and outcomes that matter most. We deliver tangible business results by combining deep industry expertise with applied innovations in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. NTT DATA Services, headquartered in Plano, Texas, is a division of NTT DATA Corporation, a top 10 global business and IT services provider with 118,000+ professionals in more than 50 countries, and NTT Group, a partner to 88 percent of the Fortune 100. Visit nttdataservices.com to learn more. NTT DATA, Inc. (the "Company") is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result. NTT Data Corporation Albany NY

Data Architect

Mindshare Usa, LLC