SIGMA Marketing Group

Applications Developer

General Description:
Use .NET, Java, SQL and/or web-based programming skills to develop database applications. Must be capable of developing complex programs and reports. Develop estimates for development and enhancement work. Analyze and document business requirements. Design, code, test, and document programs according to standards to meet business requirements. Resolve complex problems. Provide technical and functional solutions and advice to team members, managers, and end users.

Responsibilities:
• Design, develop and manage database and web applications.
• Implement business-critical internal applications.
• Deliver partner-facing web applications.
• Perform key portions of the system development lifecycle, including designing, coding, testing, documenting, installing, and maintaining custom applications.
• Create custom reports and forms using reporting tools.
• Perform administrative tasks such as entering time, updating work orders, updating knowledgebase, providing status reports, etc.

Skills/Job Requirements:
• Proficiency in SQL is a MUST, with good understanding of database design and development.
• A strong understanding of object-oriented languages and development methods.
• A strong understanding of structured programming methods and data normalization concepts.
• A mid- to high-level of experience in two or more of the following development languages: MSVisual Basic, .NET, ASP.NET, MS-Visual FoxPro, MS-SQL Server, MS-Access.
• Experience with the following development technologies: ODBC, OLE, and OCX concepts.

Qualifications:

EDUCATION:
• BA or BS degree in computer science or a related technical degree.
• MBA or MS degree a plus.

EXPERIENCE:
• Five to seven years’ industry experience in developing applications.
• Experience with Business Intelligence tools a plus.
• Experience in database design, SQL and object relational mapping.
• Working knowledge of Internet protocols, networks, HTML, TCP/IP, JavaScript, CSS, Perl.
• Two to three years’ in-depth experience creating business-related applications.
• A demonstrated track record of working on projects to success following established timelines and budgets.
• Experience with related development technologies (MS-SQL Server, Crystal Reports, etc.).
• Experience with SQL Server and/or Oracle.
• Project management experience a plus.

Database Developer

General Description:
Provide database development and troubleshooting multiple IT projects. Must have an in-depth understanding of all aspects of database technology.

Responsibilities:
• Support all database and data processing activities associated with performing marketing analysis.
• Design and develop marketing data marts for analytic purposes.
• Design, develop and implement complex database systems, programs and applications.
• Work with users to identify and develop system requirements, taking into account desired results, hardware limitations and operating requirements.
• Development and maintenance of database systems to extract, cleanse, transform, load and maintain data.
• Ensure that all database systems meet business and performance requirements.
• Provide database development support to data services team.
• Produce adhoc queries and develop reports to support business needs.
• Test developed solutions.
• Work as part of a project team to coordinate database development and determine project scope, schedule and limitations.

Skills/Job Requirements:
• Proficiency in SQL is a MUST, with good understanding of database design and development.
• Understanding of index design and performance-tuning techniques.
• Good verbal and written communication skills.
• Comfortable working in a deadline-driven environment.
• Familiarity with RDBMS principles, database design and normalization.
• Understanding of the full development life cycle, development methodologies and version control.
•Proficiency in Microsoft Office is require.

Qualifications:

EDUCATION:
• BS Degree in business, information technology, or related field.

EXPERIENCE:
• Three-five years’ experience in database development.
• Minimum three years’ full-time experience with SQL Server or Oracle.
• Experience with complex query design, stored procedures, views and functions.
• Experience with very large databases and/or data warehousing.
• General database knowledge/experience.
• Experience in statistical software, reporting tool such as Crystal Reports, or Business Intelligence tools such as Business Objects a plus.

SQL Developer

General Description:
SQL Developer is responsible for the analysis, design, development, maintenance and support of SQL applications.

Responsibilities:
• Develop and maintain SQL scripts in Microsoft SQL Server.
• Build and maintain DTS and/or SSIS packages.
• Build and maintain production SQL jobs.
• Build and maintain complex SQL queries for data analysis and data extract.
• Build and maintain ETL jobs using third-party applications.
• Build and maintain data mart extraction processes.
• Performing quality assurance and testing at the unit level.
• Assisting in writing user and technical documentation.
• Other duties as assigned.

Skills/Job Requirements:
• Experience in SQL programming is required.
• Experience using Visual Basic and the .Net platform (VB.Net, ASP.Net, C#) a plus.
• Experience with web services a plus.
• Experience with MS SQL OR Oracle required.
• Ability to apply object-oriented analysis and design.
• Experience writing customer-facing applications a plus.
• Experience with Business Intelligence (BI) and Data Warehousing preferred.
• Ability to work with a team.
• Eagerness and willingness to learn.
• Proficiency in Microsoft Office required.
• Knowledge of software engineering and applying database methodologies, techniques, and tools a plus.

Qualifications:

EDUCATION:
• BS Degree in Computer Science or related Information Technology field required.

EXPERIENCE:
• One to three years’ professional experience in Microsoft SQL Server or Oracle, DTS, and ETL tools.

Web Developer

General Description:
Work with others to develop and implement web applications.

Responsibilities:
• Create and maintain web applications.
• Gather business requirements and developing specifications for web-based applications.
• Provide technical assistance to web administrators.
• Integrate websites with back-end systems such as databases.
• Multitask between regular task requests, small projects, and work as a team on larger projects.
• Aid in conversion to newer technologies.
• Work with all popular web browsers.

Skills/Job Requirements:
• VB.NET
• HTML & CSS
• XML & XSLT
• Windows OS Environment.
• Cross-browser and interface testing.
• Troubleshooting and debugging Internet technologies.
• Utilizing or building Content Management Systems a plus.
• Solid n-tier web application development experience utilizing the .NET Framework 2.0 or higher a plus.
• Strong understanding of object-oriented concepts, design patterns and processes.
• Proficiency in web-to-database integration.
• Excellent oral and written communication skills.
• In-depth understanding of internet protocols and applications.
• Candidates should be well versed in web technologies and tools (Java, XML, ASP, etc.).
• Familiarity with TCP/IP, FTP, HTTP and HTTPS and similar Internet protocols also required.
• Proficiency in Microsoft Office is required.

Qualifications:

EDUCATION:
• BS Degree in a computer-related field.

EXPERIENCE:
• One to three years’ professional experience in a web-development position.
• SQL programming experience a plus.
• Experience in the development of multiplatform, distributed applications a plus.
• Experience working with firewalls, intranets, domain name services, servers and the related hardware and software required to administer a website.
• Experience in all phases of the web application development life cycle.
• Must have programming and design knowledge and experience to be able to create internal or external Internet pages.

Senior Technical Project Manager

General Description:
The Senior Technical Project Manager (STPM) will hold a critical role as he/she will develop project plans, allocate resources and manage the tasks, schedule and budget for multiple database development and marketing application projects. He/she will be responsible for staff growth, planning and management and ensure that proper project management, development and change control process are followed, as well as develop and maintain requirements, product specification, code and other project documentation. The Senior TPM will manage other project managers and a variety of IT staff on a number of projects to ensure their successful completion. Successful candidates must be able to see the big picture and be involved in the many details of the projects. He/she must be extremely comfortable working with individuals at all levels within and outside the organization. Motivating team members and communicating expectations to project members is crucial to project success.

Specific Responsibilities: IT Solutions
• Participate as a principle architect in the design and building of Microsoft and Oracle relational databases for OLTP and/or OLAP use cases.
• Oversee the development of new marketing applications using ASP, ASP.NET, VBScript or Jscript, Visual Basic, or other third/fourth generation programming languages.
• Oversee the development of queries and stored procedures to automate data operations.
• Author/maintain program code and documentation and oversee the documentation and archival process.
• Assist in ongoing production support.
• Modify/develop data access processes in accordance with team policies, procedures and security standards.
• Oversee the design and build of data loading/extraction, cleansing, transformation and mining technology processes using appropriate technologies.
• Help administer the implementation of commercial vertical applications such as Enterprise Marketing Management.
• Oversee and develop project planning, requirements, design, software and other documentation.

Specific Responsibilities: IT Team Oversight
• Develop the technical portions of client proposals, budgets, revenue forecasts, and results reporting, associated with business development opportunities.
• Be responsible for quality of all technical efforts on the projects being managed and provide increased quality control measures for data processing and development efforts.
• Responsible for reviewing and implementation of training tracks to provide team members with appropriate skills to successfully build competitive solutions.
• Accept full responsibility and accountability for project.
• Create and manage budget analysis and reports with regard to projects.
• Create and manage project plans and responsibilities associated with plan: obtaining approvals, tracking, updating, reporting, etc.
• Ensure definition of roles and responsibilities across all team members involved with projects.
• Develop resource plans.
• Allocate personnel across projects.
• Serve as channel for internal communication.
• Take responsibility for team performance.
• Directly supervise developers.
• Carry out supervisory responsibilities.
• Interview, hire, and train employees.
• Plan, assign and direct work.
• Appraise performance.
• Reward and discipline employees.
• Address complaints and resolve problems.
• Interview, hire, and train employees.
• Plan, assign and direct work.
• Appraise performance.
• Reward and discipline employees.
• Address complaints and resolve problems.

Skills/Job Requirements:
• Proficiency in TSQL and/or PL/SQL.
• Proficient in Word, Excel, Access, Power Point, MS Project or other project management tool, Microsoft Outlook, Microsoft SQL Server, Oracle.

Qualifications:

EDUCATION:
• Minimum B.S. in Computer Science or equivalent experience. M. S. or equivalent preferred.

EXPERIENCE:
• 7-10 years overall IT experience.
• Experience in Database Marketing desirable.
• A minimum of five years managing mid-size and complex database and/or application development projects (full cycle).
• Minimum four years experience in database and/or application development.
• 3-5 years of team leadership experience (at least 5 individuals)

Marketing Analyst

Responsibilities:
• Design, manage and deliver client analyses, such as customer profiling, segmentation, predictive models, post-program measurement, and other ad-hoc projects.
• Determine appropriate quantitative and qualitative methods for addressing clients’ marketing challenges.
• Evaluate the productivity and profitability of marketing campaigns and identify opportunities for improvement.
• Work with clients and internal developers to interpret data, analyses, requirements, and reports.
• Project management responsibilities include client communication, internal team management, project tracking, and the packaging and presentation of deliverables.

Job Requirements:
• 3+ years of experience in marketing analysis and database marketing.
• Experience performing exploratory data analysis.
• Demonstrated ability to formulate and answer important business questions, interpret analytical output and provide strategic recommendations.
• Understanding of and experience applying a subset of statistical methods such as regression analysis, conjoint analysis, CHAID and neural networks.
• Proficiency in SQL is a MUST, with good understanding of database design and development.
• Experience with OLAP tools such as Business Objects or Cognos a plus.
• Experience with Web analytics a plus.
• Proficiency with Microsoft Word, Outlook, Excel and Power Point.
• Excellent verbal and written communication skills.
• Comfortable working in a team-oriented, deadline driven environment.

Education
• Bachelor’s degree in statistics, math, engineering, information systems, economics or related quantitative field.
• MBA or MS degree a plus.
 

Account Relationship Leader

Position Summary:
• Provide strategic and tactical direction to both the client(s) and the internal SIGMA teams.
• Serve as the primary liaison with the various client marketing managers and the internal SIGMA Expert teams for opportunity identification and project requirements.
• Responsible for managing a team of direct marketing professionals in the database, strategic and tactical execution of marketing initiatives.
• Responsible for maintaining and growing the client relationship(s) with as many as 5 client marketing managers.
• Responsible for maintaining and reporting on specific client-related SIGMA business metrics (revenue, contribution margin, customer satisfaction, etc).
• Stay current in the clients’ industry trends and events.

Preferred Experience/Behavior:
• Experience developing and managing direct marketing programs in the financial services industry vertical.
• Experience developing strategy and working closely with clients and internal groups to identify opportunities and project requirements.
• Experience working with multiple clients/project requestor situations.
• Experience growing client relationship(s) and in planning/monitoring of client initiatives.
• Experience in managing cross-functional team of professionals (i.e.; account services, creative, analytical, IT, telemarketing, fulfillment, etc.).
• Very strong marketing background required, including development and monitoring of budgets/income opportunities.
• 3-5 years' experience with a financial services customer database, experience with Dun & Bradstreet data.
• Preferred Educational Experience: BA/BS, ideally in Marketing, Communications, etc.

Must Have Skills:
• Ability to translate arcane technical details into English for client discussions and back again.
• Ability to communicate effectively at a client level as well as at a programmer/analyst level.
• Analytical background (data manipulation and analysis, segmentation, predictive modeling, database design).
• Ability to recognize and develop strategic marketing opportunities for client.
• Ability to identify new and/or manage existing income opportunities.
• Ability to grow client relationship(s).
• Knowledge of database marketing program execution.
• Ability to provide direction to additional account staff members.
• Strong leadership skills, ability to manage a team, and leverage/allocate available resources.
• Team player.
• Strong organizational/multi-tasking skills.
• Strong problem-solving skills.
• Proficiency with MS Office Suite.
• Accomplished business communicator (written and verbal/presentation).

Nice to Have Skills:
• Experience in providing and understanding direct marketing campaign results analysis.
• Understanding and ability to identify and sell IT-based solutions.
• Knowledge of creative aspects of marketing program execution.

Account Manager

Position Summary:
• Responsible for marketing program planning/execution and for contributing to continued client development.
• Serve as primary tactical contact with client, internal resources and vendors for project, planning implementation and management.  
• Effectively manage, prioritize client activities and work with other team member to schedule team resources to meet client timelines.
• Ability to provide successful project management in the areas of campaign targeting, file development, response and lead management, and campaign reporting for mail, email, and telemarketing initiatives.
• Assist in response management activities as needed, including, but not limited to, response entry, lead review, press/print checks, etc.
• Development of all appropriate documentation to complete project on a timely basis.
• Shared responsibility in the quality control of all components of the client deliverables.
• Ability to identify income opportunities and development of plans for presentation to clients.
• Jointly responsible with other team members for client satisfaction.
• Jointly responsible with other team members for managing projects and engagements to meet overall team and corporate metrics.

Preferred Experience/Behavior:
• Minimum of 3-4 years' experience in project or account management.
• Minimum of 2-4 years' of experience with creative and print production business process.
• Minimum of 1-3 years of database/direct marketing experience (client or agency side).
• BA/BS, ideally in Marketing, Journalism, Communications, Business, or relevant work experience.

Must Have Skills:
• Experience in the areas of general, online and print advertising, and event-based marketing.
• Excellent verbal/written communication skills, both internally and with clients.
• Initiative and ability to work in a team environment.
• Proven client management skills.
• Strong organizational and presentation skills.
• Strong problem-solving skills.
• Ability to maintain focus while managing multiple projects and tight deadlines.
• Proficiency with MS Office Suite.

Nice to Have Skills:
• Knowledge of database/direct marketing, specifically with direct marketing campaign development and execution.
• Experience in channel marketing.
• Experience with direct marketing-based analytics.
• Exposure to IT application development projects or marketing solutions involving IT components.