Boston Categories:
SQL Developer/Tech Consultant - Mid-level Extraprise
DescriptionThe 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 technical consultant / SQL developer 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 report
The technical consultant / SQl developer will act as a sole contributor, a member on a team, or a team lead, depending upon the needs of the client, project and Extraprise.
The SQL developer / technical consultant will also:
Define solution requirements
Provide technical analysis of data requirements
Devise creative technical approaches
Design 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 service
Required Skills and Experience
The technical consultant will need to have 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:
Minimum two years experience developing applications in a Microsoft Windows environment utilizing:
SQL Server 2005 or 2008
PL/SQL, T-SQL, or equivalent
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
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
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
Data cleansing tools, e.g., Trillium, Firstlogic, DQXI, etc
Business analytics ro reporting tools, e.g., Siebel Analytics, Cognos, Business Objects, SAS, Crystal, or Actuate
Prior experience with CRM applications
Education
BS or BA degree required, CS, MIS, EE or closely related preferred
| Location: | 321 Summer Street Sixth Floor Boston, MA 02210 United States |
|---|
Extraprise
Investors: Bessemer Venture Partners, Commonwealth Capital Ventures, Redpoint VenturesAll Jobs: at Extraprise
| Web Site: | www.extraprise.com |
|---|---|
| Headquarters: | 321 Summer Street Sixth Floor Boston, MA 02210 United States |
| Industry: | IT Services |
