Position Description
The senior technical consultant will be a member of a team that is responsible for designing, building, and deploying marketing data marts and for delivering marketing and analytics solutions. Responsibilities include:
- Building new marketing data marts and analytic engines including functional analysis, technical design, development, testing, and deployment
- Enhancing existing marketing data marts and analytic engines
More specifically, the senior technical consultant will work closely with the marketing team to develop flexible, maintainable (including enhancements), and stable marketing data marts that will meet the needs of Extraprise’s clients. This includes, but is not limited to:
- Designing and building data staging areas, marketing data marts, and analytic engines
- Installing, configuring, and, if necessary, customizing analytics and campaign management tools
- Technically designing and developing data management (matching, merging, consolidation, purging, and cleansing) and extraction, transformation, and loading (ETL) functionality
- Designing and developing reports
The senior technical consultant will also:
- Participate in sales pursuits
- Determine project scope with the marketing / business team
- Provide accurate time and resource estimates
- Devise creative technical approaches
- Build task- / resource-level project plans
- Technical team and project managementDesign and develop interface / ETL code
- Design, develop, and utilize zero-tolerance testing approaches
- Assist with hardware, software, and data communications architecture and sizing
- Contribute to the development and support of ongoing production services
The senior technical consultant will act as a sole contributor, a member on a team, a team lead, or a project manager, depending upon the needs of the client, project, and Extraprise. Notwithstanding the specific role, the senior technical consultant will be responsible for coaching, mentoring, and assisting other technical consultants in the organization. Finally, the senior technical consultant may serve as the primary technical contact with Extraprise’s clients to determine best approaches, provide consultative advice, resolve issues, and/or to report progress.
Required Skills and Experience
The senior consultant will need to have strong consulting, communication, design, and development skills, as well as the knowledge to implement complex data base and integrated data and application solutions. Other required characteristics and skills include:
SQL Server 2005 or 2008
Stored procedures
ETL tools, e.g., SSIS, Informatica, DAC, etc
Data cleansing tools, e.g., Trillium, Firstlogic, DQXI, etc
Business analytics or reporting tools, e.g., Siebel Analytics, Cognos, Business Objects, Oracle, SAS, Crystal, or Actuate
Ability to perform logical and physical database design
Experience leading development teams
Strong organizational skills
Good written and verbal skills
Ability to work independently, juggle multiple priorities, provide superior client service, problem solve, and communicate with all members of the team
Desired Skills and Experience
It would be very helpful for the successful candidate to possess database marketing experience and skills, which include:
- Prior experience with
- Siebel Marketing and Business Analytics software
- Other database marketing applications, e.g., Unica, Alterian, Aprimo, etc
- Oracle database software
- Prior experience with CRM applications
Education
BA / BS, preferable in computer science or information technology
