United Online, Inc. (Nasdaq: UNTD) is a leading provider of consumer products and services over the Internet, where the company's brands have attracted a large online audience that includes more than 60 million registered accounts. The company's offerings include floral related products and services (FTD and Interflora) for consumers and retail florists. The company's Content & Media segment services are online nostalgia (Memory Lane) and online loyalty marketing (MyPoints). Its primary Communications segment services are Internet access and email (NetZero and Juno). We are committed to hiring the best, most enthusiastic team of talented individuals in the industry. Our team of talented employees has helped build a successful, rapidly growing organization that prides itself on its world-class marketing capabilities and its development of innovative technologies. If you are interested in becoming part of the United Online revolution, we invite you to consider the following opportunity:

Data Warehouse Engineer

We are looking for a Data Warehouse Engineer who is highly self-directed and able to manage and prioritize multiple concurrent and competing challenges, issues, ambiguities, and contradictions. The day to day duties would require the candidate to architect, design, document, lead, develop and operationalize (EDW/ODS/DM etc.,) integration solutions as appropriate using Informatica tool suite in accordance with industry best practices. This position also requires evaluation and recommendation of methods, software tools, definition of hardware requirements and system configuration in support integration solutions.

Responsibilities:

• Will be responsible for architecture, design and maintenance of data and its integration architecture framework in of support of the information lifecycle management.
• Develop data models that support data processing and/or information management and delivery (semi-structured and unstructured).
• Create processes for capturing and defining information/data, standards, modeling Meta models and documentation.
• Determine integration strategies to ensure integration processes and Data Warehouse data model are optimized for data processing, reuse and scalability.
• Perform impact analysis on existing integration and EDW Data Model when new integration logic or new source systems are introduced into the data warehouse.
• Contribute to architecture, capacity planning and data quality activities for the data warehouse
• Conduct performance tuning and capacity management
• Work with engineering team and business users to resolve support and technical questions
• Responsible in preparing high level integration architecture and low level design documents to hand over to the developers
• Act as a lead working with onsite and offshore teams and managing development efforts
• Participate in our data integrations on call support rotation.

Qualifications:

• 3+ year’s progressive experience in enterprise information/data related disciplines, i.e., data modeling, architecture and integration in BI environments
• 3+ years of Informatica 8.xx Power Center.
• Strong analytical and integration SQL query writing skills
• Strong Unix shell scripting skills
• Good understanding of various database platforms, including Oracle, Netezza, Teradata
• PL/SQL programming is a PLUS
• Exposure to enterprise class data mining is a PLUS.
• Working knowledge of SAS Analytics and/or SPSS tools is a PLUS
• Experience in data modeling (3NF), dimensional modeling and object oriented modeling.
• Experience in creation of data dictionaries, defining metadata management approaches and governance processes.
• Experience creating enterprise models incorporating master and reference data.
• Solid understanding of transaction and information systems, data warehouses, data marts, ODS, MDM methodologies and life cycle as well as ETL and MDM technologies.
• Strong analytical and problem solving skills.
• Excellent verbal and written communication skills, able to explain and document the Enterprise Information Architecture to diverse audiences (technical, business, etc).

About us:

Classmates® is the premier online, social, and mobile destination for reconnecting with the people and events from your high school years. Classmates offers the largest digitized collection of high school yearbooks online, with over 100,000 available to view, tag, sign, and share, and has built the most comprehensive directory of high schools and class lists from the 1940s to today.

Join us today! This position is located at our headquarters on Seattle’s waterfront. We offer a competitive salary and benefits package that includes medical, dental, vision, 401(k), employee stock purchase plan, flexible spending accounts, and much more! Memory Lane d/b/a Classmates ® and the United Online, Inc. family of companies are equal opportunity employers.

Please apply to jobs@memorylane.com .

Local area candidates are encouraged to apply, and please note we are not able to offer visa sponsorship, visa transfer, or corp-corp arrangements.