POSITION: Development-Associate Director
LOCATION: Shanghai, China
JOB TYPE: Digital Marketing, Digital Studio
COMPANY: The largest and fastest growing customer relationship marketing (CRM) agency
Position Summary:
Development Associate Directors are responsible for the detailed design, development and delivery of multi-terabyte marketing solutions that integrate and optimize our client's data across numerous sources. Our solutions enable our clients to better communicate to their customer and prospects across a number of marketing channels and media. Once hired, the qualified candidate will be immersed in the development and maintenance of marketing database solutions to meet client business objectives. You will have an opportunity to work with a cross-disciplinary team across various divisions of the Technology Solutions Group.
Position Responsibilities:
- Data warehouse architecture and ETL design
- Build and maintain SQL procedures and ETL processes
- Manage and mentor a team of up to 10 developers and/or other managers in a matrix organization
- Design and implement technical vision for client projects
- Own overall project architecture and technical delivery of solution
- Interact with clients on regular basis
- Assist in requirements gathering and data analysis as needed
- Estimate work effort and assist the Project Manager with task planning and LOE (level of effort) estimates
- Serve as the technical point of contact for the solution, both internally to Company and in interactions directly with the client
- Provide technical leadership and oversight of a project development team
- Review work product of others for compliance with development standards
- Provide guidance and mentoring in database marketing development best practices
- Write technical documentation
- Author design documentation for project and solution
- Lead / participate in design reviews; participate in code reviews
- Contribute to the best practices, standards and guidelines for the capability
- Approve the technical deliverables in order to ensure the compliance with architectural standards
Outcomes:
The successful Development - Associate Director will:
- Deliver large scale solutions on time and on budget
- Interact regularly with clients
- Effectively hand off work to developer level resources in the US and off shore
- Manage and grow other developers and managers in a matrix organization
- Thoroughly understand core Company marketing technology platforms
- Grow client relationships through high quality work
- Continuously raise the bar for the entire Development group
QUALIFICATIONS:
Skills:
- Exceptional understanding of relational and dimensional database concepts
- Exceptional understanding of SQL and database programming
- Exceptional understanding of ETL concepts, processes, and tools – Informatica, SSIS, DM Express, SQL
- Understanding of file management concepts, processes, and tools - sFTP, PGP Encryption, Sterling
- Understanding of scheduling/automation concepts, processes, and tools - Tidal
- Understanding of common IT offerings - e.g. Operating systems, storage, backups
- Understanding of database platforms - SQL Server, Netezza, Oracle
- Understanding of big data platforms - Hadoop
- Understanding of .NET / Java
- Strong knowledge of software engineering and development methodologies, techniques, and tools, including SVN, Issue Tracking (Jira), and Software Development Lifecycle (waterfall, agile)
- Ability to serve as technical point of contact for the solution both internally to Company and in interactions directly with the client
- Ability to hand off work to other development resources - both US and off shore
- Excellent communication skills - both verbal and written
- Ability to present, both verbal and written, to team members, capability members, portfolio members, and clients at the appropriate technological level
- Working knowledge of at least one BI tool, such as Cognos, Business Objects or Microstrategy.
- Experience with a campaign tool, such as Alterian, preferred
Experience:
- 10+ years’ experience with Microsoft SQL Server, Oracle or other major RDBMS
- 4+ years’ experience as a team lead
- Experience with Customer Data Integration or Master Data Management preferred
- Experience in database marketing preferred
- Significant experience designing and implementing large databases and data warehouses utilizing both relational and dimensional design concepts
- Technical consulting experience a plus
- Significant experience with at least one leading ETL tool, Informatica preferred
Other:
- Bachelor's degree from a four-year college or university in Computer Science or related IT field, or relevant professional experience
- Possess the Company attributes of being smart, curious, committed to vision, passionate, fun/pleasant, an achiever, and having a sense of urgency
- Ability to be a team player
