Modis Data Warehouse Jobs | IT Jobs

Jr. Business Intelligence (BI) Developer

Wed, 23 May 2012 15:26:36 EST

Industry: Technology - Category: Data Warehouse - Location: Cleveland, OH - Position: Jr. Business Intelligence (BI) Developer Location: Cleveland, OH Duration: Direct Hire Are you a database or software developer looking for a way to break into the Business Intelligence (BI) world? Are you eager to learn new technologies and have a solid understanding of databases? We have an excellent opportunity with an awesome client who is looking for you! Modis, a leader in the staffing industry, is working with a client in the Cleveland area who is seeking a Business Intelligence (BI) Developer to join their fast-paced, creative, cutting-edge environment. Position Description: The Business Intelligence (BI) Developer will be a part of a team who works with a variety of groups within IT on their reporting needs. The developer will work on new projects, provide support of current reports, and act as the administrator for the reporting tool. Key Responsibilities: • Use your experience with reporting tools to plan, architect, and deliver reports or dashboards • Develop requirements and specifications to build data marts to support reporting needs • Work with developers to understand and develop requirements and processes for new information needs through the entire development lifecycle • Perform quality assurance testing of reports and dashboards Candidate Must Have: • 1-3 years working on an Data Warehouse team • 1-3 years designing and developing Business Intelligence (BI) applications • 1-3 years designing and developing data marts used for reporting or adhoc analysis • Experience performing queries in SQL or Oracle PL/SQL is required • Superior Communication skills is required **Please note - Must be authorized to work for any employer in the US directly without the need for sponsorship** NO C2C To be considered for this exciting opportunity, please send your Resume to: Krysti.Ellis@modis.com

Senior Data Warehouse Architects

Wed, 02 May 2012 09:06:45 EST

Industry: Technology - Category: Data Warehouse - Location: Cheshire, CT - ****Please send resumes to susan.horrigan@modis.com or call 781-262-5014**** Looking for someone who knows and has set-up enterprise warehouse and understand Business Objects, leads projects, SAP Data Services (ETL tool to pull data) and Attunity (ETL tool) Has advanced knowledge of Data Warehousing & BI concepts including Star Schema & Snowflakes, dimensional data and metric, normalization and denormalization. Has advanced and comprehensive knowledge of the Data Warehousing technology, its history, architecture, concepts and future direction. Subject matter expert in ETL. Expert in SAP Data Services, DBMoto and or Attunity data mappings, transformations and performance turning. Has database administrator expertise including indexing, replication and programming in least 2 of the following three databases: SQL 2000 and higher, Oracle 9i or higher, DB2/ 400.Has some knowledge of BI reporting tools and how they interface with RD. Has some knowledge of JDE functionality and how JDE interfaces with RD. Has advanced and comprehensive knowledge of general data warehousing set up procedures. Must be self sufficient with set up procedures and be able to implement data warehousing solutions independent of instructional direction. Understands and can clearly communicate to managers and clients what each step in the implementation process, how the steps interrelate and what is required to move forward at each step. Assists in the development of project plans. Is knowledgeable of, and assists the PM in the preparation of project documentation. Interact with client on a professional level and can run (Facilitates) meetings. Communicates project status effectively to clients and internal management. Be able to assists in the sales close process and overall presentation. Assists in writing proposals. Identifies opportunities for other service offerings and coordinates appropriate actions to explore those opportunities. Establishes and maintains credibility with clients. SEND ALL RESUMES TO susan.horrigan@modis.com or call 781-262-5014 Full Time/Direct Hire position Salary: OPEN

ETL Developer (Informatica)

Wed, 30 May 2012 20:16:11 EST

Industry: Retail - Category: Data Warehouse - Location: Calabasas, CA - Modis is looking for several ETL Developers for one of our clients located near the Woodland Hills area. This is a 3-6 month project with one of our clients who is experiencing major growth in the retail space. 1. Must have a minimum of 6 years of heavy experience with Informatica 2. Must have a strong understanding of source data, data mappings and translating into specs 3. Must be able to thrive in a fast paced environment, be able to provide solutions and show initiative 4. Experience with Epicor higly preferredbut not required 5.Retail Industry experience very desirable

Lead MS BI Developer

Mon, 07 May 2012 10:42:07 EST

Industry: Technology - Category: Data Warehouse - Location: Fort Lauderdale, FL - Job Description: Support the client's project initiatives by implementing design recommendations put forth by the project core team. The projects goal is to optimize the performance of the existing DW, cubes and ETL process in order to provide increase scalability, performance and enhanced user experience. The developer will be using the Microsoft BI technology stack. This is a senior level role were the candidate will be expected to be well versed in all aspects of the BI technology stack as well as strong enterprise SLDC experience. Demonstrated SSAS experience is a must. Required Skills: This is a senior level role were the candidate will be expected to be well versed in all aspects of the BI technology stack as well as strong enterprise SLDC experience. Demonstrated SSAS experience is a must. Primary Duties and Responsibilities include: • Participate in discussions with business users to gather data requirements. • Query source data systems in SQL Server as necessary and learn data to support business requirements. • Design and build data warehouse dimensions and fact tables as required, using SQL Server and SSAS. • Build/maintain SSIS packages to move data from source systems (both files and databases) into Staging and Data warehouse databases. • Build/modify cubes as required to support front-end user interfaces. This is expected to include KPIs, aggregations and drill-trough’s as needed. • Develop multiple cubes and integrate them using Linked measures • Automate SSAS Cube processing using SSIS • Design ETL (SSIS packages) to load Slowly Changing Dimensions (Type I and II) • Develop Database components Objects including tables, views, stored procedures, indexes and define best practices • Perform database and ETL tuning Qualifications and Requirements: • Highly proficient in all tools in the Microsoft BI technology stack (SSIS, SSAS SQL) • Ability and willingness to adhere to corporate development standards and documentation requirements • Ability to interpret business requirements and produce supporting data queries and result sets that match these requirements • Strong interpersonal, organizational, and follow-up skills with ability to develop rapport with others • Strong customer service skills, with the ability to carry out assignments and adapt to changing priorities.

Technical Red Prairie Configuration Architect

Wed, 16 May 2012 19:40:24 EST

Industry: Technology - Category: Data Warehouse - Location: Jacksonville, FL - We have a GREAT position with travel which we will cover. Technical/Functional that can help us in setting up a Multi-Client warehouse environment in Red Prairie. And by technical, I’m not referring to installing RP or configuring the server or its database, all that is done by another team. We need someone that are able to take the basic installation of Red Prairie and set up its parameters to work as a multi-client WMS. Contract will be about 6-12 months PLEASE SEND ALL QUALIFIED RESUMES TO: Amy.Pennington@modis.com

Systems Storage Administrator

Fri, 25 May 2012 14:35:59 EST

Industry: Technology - Category: Data Warehouse - Location: Dallas, TX - Our client in Dallas is looking for a Sr. Storage Administrator. If you are interested and possess the necessary qualifications, please send your resume to thomas.amend@modis.com. BASIC FUNCTION: Manages, conducts, configures, maintains, deploys, troubleshoots and supports at the expert level mixed and growing environment of Windows Servers, NAS and Storage Area Networks consisting primarily of EMC storage area networks under minimal supervision. Directs or leads the work of others. ESSENTIAL JOB DUTIES/RESPONSIBILITIES: (functions considered essential as defined by ADA) Manages and monitors Storage Area Network (SAN), and analyzes usage and trends Consults regularly with management and end users on needs and requests ¿ Plans and implements new Storage Area Network (SAN) and provides highest-level input for developing local operating procedures and policies as needed or requested Researches, designs, installs, administers and maintains distributed enterprise storage technology to ensure maximum availability of mission critical business systems, applications and data Oversees ongoing storage systems operations and provides utilization reports to identify problems and corrective actions as needed Uses best practice methodologies to develop and manage data backup, disaster recovery and replication throughout the enterprise Develops local and enterprise backup strategies, operating procedures and implements them as needed or requested Ensures data recovery, maintenance, data integrity and space requirements are met across a variety of platforms Manages, configures, maintains, deploys, troubleshoots and supports company servers and server based applications (which currently includes Windows Server 2003, 2008 (with Active Directory), Exchange Server 2003, 2007 and Microsoft SQL Server 2000, 2005) Ensures all repairs, updates and other changes necessary are made to ensure maximum performance Provides expertise in troubleshooting, root cause analysis and issue resolution Handles high-level requests from Help Desk, Systems Supervisor and Manager, Infrastructure as delegated Writes clear, concise, and accurate documentation and provides training (i.e., work procedures, how to guides) Evaluates, tests, and recommends new solutions and technologies, troubleshooting techniques, tools, processes, and procedures Relocates technical equipment to and from an assigned location Special assignments or tasks assigned to the employee by their manager, as determined from time to time in their sole and complete discretion EXPERIENCE: A minimum of 10 years of overall IT experience with at least 5years of supporting enterprise Storage Area Networks (SAN) and managing data recovery, tape backup and restore technology in a mission critical environment are required. EDUCATIONAL LEVEL: A minimum of a Bachelor’s Degree in Computer Science (or related discipline) or equivalent work experience is required. EMC Certification required. REQUIRED SKILLS: In depth knowledge of SAN fabrics, EMC Clarion, VNX, V-Max and Celerra arrays, Enterprise Server and application monitoring tools, storage connectivity (HBA), data backup, recovery and replication best practices, fiber switch administration (Brocade and Cisco), logical volumes and storage partitioning creation, basic TCP/IP networking, and good security habits and practices. Working knowledge of Windows server 2003 and 2008 clustering and virtualization; x86 Server hardware, Symantec Backup Exec, file and print server administration, Active Directory Administration and server monitoring best practices. Strong reading and communication skills, written and verbal, time tracking and reporting skills; ability to perform intermediate level mathematical calculations, and strong interpersonal skills with ability to communicate effectively with others. Ability to work creatively and analytically in a problem-solving fast paced environment, coordinate multiple tasks, coordinate projects, lead others and meet deadlines which may require off hour work. PREFERRED SKILLS: Working knowledge of Exchange 2007/2010, Citrix Xenserver 5/6, Advanced Active Directory, Windows Scripting, VMWare ESXi 4.x and process automation tools (Altiris, Microsoft System Center, BMC). Understanding of problem and incident management and change control processes is desired. SUPERVISORY/MANAGERIAL RESPONSIBILITIES: Directs or leads the work of others as needed WORK CONDITIONS: Office based with travel up to 30% of time by land or air is required. From time to time, required to work long hours which may include nights, weekends, holidays for regularly scheduled maintenance and emergency work and support as well as on-call availability. At times, required to work in refinery/industrial environment, includes but not limited to, work near moving mechanical parts and/or rotating equipment, loud noise or vibrations and varying road conditions. At times, may be exposed to risk of electrical shock. PHYSICAL REQUIREMENTS: Job conditions require standing, walking, sitting, twisting, stooping, crouching, kneeling, lifting or carrying up to and pushing or pulling up to 50lbs, climbing up to 15ft, working in confined spaces, talking or hearing, making visual inspections, making precise hand and finger movements, reaching or grasping; ability to operate and drive all assigned company vehicles at company standard insurance rates is essential, valid State driver’s license and proof of insurance, and perceiving color differences. If you are interested in the position and possess the necessary qualifications, please send your resume to thomas.amend@modis.com

Dev/Prgrm-Data WHS/Bus Int Sr

Thu, 10 May 2012 18:52:50 EST

Industry: Banking/Financial Services - Category: Data Warehouse - Location: San Antonio, TX - If you are creative, with experience as a Business Objects expert; then we would love to speak to you! We are seeking a Senior Developer/Programmer-Data Warehousing/Business Intelligence for a dynamic Corporation who was voted one of the top 100 Companies to work for with true success in technology development and maintenance. Its presence here in San Antonio is highly recognized as a “place to be” with a state of the art exemplary work environment. Please contact us if you have the following requirements and we will provide additional pertinent details regarding this one of a kind opportunity: Business Objects (Universe Design, Excelcius/Dashboard design/development, Webi development) is the primary required skill. 6 – 10 years experience. Advanced ETL experience using either Informatica or Data Stage. Strong leadership experience including proven success in leading development teams in complex Data Warehousing and Business Intelligence project implementations Please send your resume to Justin.reich@modis.com to be considered for this position. Who is MODIS: To succeed in the complex world of technology, you need exceptional connections – to the right experts, the right opportunities and the right answers. You'll find Modis right in the center of this ever-changing technological world – uncovering opportunities and connecting possibilities. We use our insight, knowledge and expanded resources to understand your goals and help you achieve them. Yes, the world of technology is a complex place. But from our perspective, we see things clearly. You know where you want to go. Outstanding Benefits available to our consultants and employee include: Access to Online Skill Learning Program during employment, Optional PPO Group Health / Dental / Vision Insurance, 401K with matching, Optional HSA (Health Savings Account) as well as Long and Short Term Disability. MODIS is always searching for highly skilled, dedicated IT professionals to join our team. We always seek to deliver competitive and sought-after career opportunities to our potential consultants and employees. Even if this is not the opportunity for you, we encourage you to send your resume to the San Antonio office for consideration for other opportunities. The email address is SanAntonio@Modis.com

Sr. Dev/Prog-DW/BI

Fri, 18 May 2012 12:11:32 EST

Industry: Banking/Financial Services - Category: Data Warehouse - Location: San Antonio, TX - If you are creative, with experience in Informatica resources preferably with P&C knowledge then we would love to speak to you! We are seeking a Sr. Developer/Programmjer/Data Warehouse/BI for a dynamic Corporation who was voted one of the top 100 Companies to work for with true success in technology development and maintenance. Its presence here in San Antonio is highly recognized as a “place to be” with a state of the art exemplary work environment. Please contact us if you have the following requirements and we will provide additional pertinent details regarding this one of a kind opportunity: 6-10 years experience with advanced ETL experience using either Informatica or Data Stage. Well rounded, experienced resources working on larger/complex data warehousing/analytics environments. Strong leadership experience including proven success in leading development teams in complex Data Warehousing and Business Intelligence project implementations. Advanced SQL skills including complex query building and query performance tuning. Please send your resume to Justin.reich@modis.com to be considered for this position. Who is MODIS: To succeed in the complex world of technology, you need exceptional connections – to the right experts, the right opportunities and the right answers. You'll find Modis right in the center of this ever-changing technological world – uncovering opportunities and connecting possibilities. We use our insight, knowledge and expanded resources to understand your goals and help you achieve them. Yes, the world of technology is a complex place. But from our perspective, we see things clearly. You know where you want to go. Outstanding Benefits available to our consultants and employee include: Access to Online Skill Learning Program during employment, Optional PPO Group Health / Dental / Vision Insurance, 401K with matching, Optional HSA (Health Savings Account) as well as Long and Short Term Disability. MODIS is always searching for highly skilled, dedicated IT professionals to join our team. We always seek to deliver competitive and sought-after career opportunities to our potential consultants and employees. Even if this is not the opportunity for you, we encourage you to send your resume to the San Antonio office for consideration for other opportunities. The email address is SanAntonio@Modis.com

SAS Statistical Modeler (Marketing Research) Attn: BGM

Thu, 31 May 2012 13:56:33 EST

Industry: Banking/Financial Services - Category: Data Warehouse - Location: Vienna, VA - MODIS is seeking a Statistical Modeler for a diret hire position in Vienna, VA. Please send resume and rate to brenda.mitchell@Modis.com. Location: Vienna, VA Status: Permanent, full time Position: SAS Statistical Modeler **Sponsorship will not be provided for this position** Responsibilities: • Develops program initiatives utilizing segmentation strategies based on customer behaviors, business drivers, competitive environment and past program results • Participates in developing and implementing Marketing strategies • Responsible for developing strategies around all stages of product and member life-cycle (i.e., acquisition, on-boarding, activation/usage/relationship maintenance, and retention) • Develops and maintains predictive models using data mining tools (e.g. SAS/JMP, SPSS/Clementine) and applies those models to enhance member targeting and identify key business opportunities. • Performs other duties as necessary Required Qualifications: • Extensive knowledge in many areas of statistics, including linear and nonlinear regressions, categorical data analysis, Survival Analysis, experimental designs, multivariate analysis, nonparametric methods, Bayesian methods, etc • MUST HAVE prior experience developing program initiatives utilizing segmentation strategies based on customer behaviors, business drivers, competitive environment and past program results • Bachelor’s degree in Marketing, Business or a related field. • Significant knowledge and experience in marketing campaign “life-cycle” management and a broad range of marketing research tools, trends and technologies - e.g. Cognos, Business Objects, SAS, JMP, SPSS, SQL, and CRM platforms such as Infor/Teradata • Highly effective interpersonal, verbal, and written communication skills • Excellent experience communicating and presenting technical results to shareholders and senior management in a clear, concise and understandable language • Experience with automated systems, data mining, and CRM platforms Desired Qualifications: • Masters Degree/MBA in Marketing, Business or related field. ***Please email resumes directly to brenda.mitchell@modis.com***

9388 - Data Integration Design Lead

Mon, 14 May 2012 13:28:29 EST

Industry: Insurance - Category: Data Warehouse - Location: New York, NY - To be considered for this role you must email Michael Aponte michael.aponte@modis.com 212.378.3783 Description: This position will be the data integration design lead of a significantly large risk data warehouse, providing designs for implementation-ready data integration patterns based on specifications provided by the solutions architect via the semantic layer architecture. This position requires deep design and technical skills, supreme multi-tasking, great communication skills and great collaboration skills. It is a â€œget your hands dirtyâ€, â€œno detail is too smallâ€ position that requires a mix of desiogner, technologist, project manager, and coach. Successful candidate must clearly demonstrate the ability to work independently as part of a team that makes use of an Agile/Iterative development approach. Work with Data Analysts, Business Intelligence Developers, Infrastructure Architects and key business users to review, design and develop data integration models in a hub-n-spoke environment utilizing IIW core data model Creates solution designs, technical specifications, and ETL/ELT processing designs Leads technical discussions impacting solutions and data integration technology Designs data integration patterns based on Atomic and Dimensional Modeling, Denormalized Data Structures, OLAP and Data Warehousing design patterns Leverage design optimization techniques to maximize the efficiency of integration layer design and the subsequent computer systems Adhere to industry and company best practices for service delivery Assist in the ongoing development and documentation of various systems, policies, procedures and customer deliverables Assisting in the ongoing data integration development of technical best practices for data movement, data quality, data cleansing and other Data Integration related activities Directly liaise with the Business Analysts, Report Writers and Architects on all Data Integration development activities Serve as the Designer and provide documentation (workflows, functional specifications, data models, etc.) of all ETL processes from data source to data staging to core data model to data consumption and distribution layers Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs. Develop data integration standards according to the organization's information services policies as well as best practices. Conduct review of other integration developersâ€™ development efforts to ensure consistent methodologies are followed and to make recommendations where necessary. Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment. Must possess strong knowledge in metadata and data integration processes and methodologies 8+ years of data warehouse and data integration (including ETL patterns) design experience 5+ years in a direct role as a designer / lead for data integration and/or EDW systems 5+ years data warehousing and methodology experience 5+ years of data modeling ERD - Dimensional 4+ years ETL architecture including Ab Initio, IIS (Datastage) 4+ years of Agile development experience Must have advanced technical expertise with Oracle, complex PL*SQL, UNIX/LINUX in a large data environment. Understand SQL execution plan and how to tune a query. Advanced SQL and Advanced Analytical Functions such as windowing, partition by, ranking, pivoting etc. Technical expertise in distributed system architecture, design, and development Able to communicate effectively with all levels of management in a clear and professional manner; verbally, written, and possess superior people management and leadership skills Strong project management, leadership, decision-making, and technical design skills Strong conceptual and analytical skills: SQL, problem solving, performance tuning, test case analysis Ability to multitask and comfortable working in a large organization across multiple teams Demonstrated competency in all phases of software development Expert understanding of MPP and or large SMP environments Solid understanding of data modeling and design considerations for analytical systems Solid understanding of database administration, tuning, and space management BI experience with Cognos or Microstrategy due to our growing business intelligence needs Able to anticipate and mitigate risks as well as define design solutions Able to produce professional documentation and manage small initiatives To be considered for this role you must email Michael Aponte michael.aponte@modis.com 212.378.3783

ETL Production Support Analyst

Wed, 16 May 2012 11:56:11 EST

Industry: Banking/Financial Services - Category: Data Warehouse - Location: Prairie Village, KS - Fantastic high profile opportunity for an ETL Production Support Analyst at one of our best clients, located in Johnson County. You have the chance to join one of the nations most respected asset management companies and put your career in a position to make a difference. I invite you to review the requirements below and apply today if your skills match my needs! Position Type: • 3-6 month contract to hire, conversion salary 80k-85k Description: • Performs system maintenance, break/fix and small enhancement work on the enterprise ETL jobs in the production environment. With minimal supervision, handles system problems and exceptions to ensure timely delivery of services and problem recovery. Troubleshoots production tickets, administers performance tuning and develops small enhancements to the enterprise ETL jobs post go-live. Functions as a technical expert in one or more specialized areas in order to work with customers to establish the service request scope, requirements and commitments. Required: • Proven experience in providing Application/Production Support • SSIS (2005 & 2008) • SSRS (2005 & 2008) • 5 yrs Oracle DB (11g) • 5 yrs SQL Server (2005 & 2008 R2) Preferred: • Informatica/PowerCenter: 9.0.1 • Informatica/PowerExchange 9.1.0 • College degree in a software development discipline I look forward to receiving your contact information and resume! Please send to Zachary.ross@modis.com and let me know if you have any additional questions.

ETL Senior Programmer Analyst

Wed, 16 May 2012 11:51:24 EST

Industry: Banking/Financial Services - Category: Data Warehouse - Location: Prairie Village, KS - Fantastic high profile opportunity for a Senior ETL Programmer/Analyst at one of our best clients, located in Johnson County. You have the chance to join one of the nations most respected asset management companies and put your career in a position to make a difference. I invite you to review the requirements below and apply today if your skills match my needs! Position Type: • 3-6 month contract to hire, conversion salary 90k-95k Description: • Performs ETL development responsibilities with minimal supervision and performs process analysis and provides technical solutions using company-directed advanced methods and technologies. Expertly produces designs that address systems integration, compatibility, and multiple platforms. Develops technical project deliverables, including those that can be utilized by others during solution development, implementation and maintenance. Thoroughly plans and executes testing of assigned system components and may have project or application quality assurance review responsibilities. Required Skills: • Experience working in the capacity of a team lead with responsibility to initiate and drive Informatica training/mentoring initiatives. • 5+ yrs SSIS (2005 & 2008) • 5+ yrs SSRS (2005 & 2008) • 5+ yrs Oracle DB (11g) • 5+ yrs SQL Server (2005 & 2008 R2) Preferred Skills: • Informatica/PowerCenter: 9.0.1 • Informatica/PowerExchange 9.1.0 • Agile/Scrum Development • ScrumMaster certified • College degree in a software development discipline I look forward to receiving your contact information and resume! Please send to Zachary.ross@modis.com and let me know if you have any additional questions.

Data Warehouse Developer

Tue, 22 May 2012 14:06:03 EST

Industry: Other - Category: Data Warehouse - Location: Carlisle, PA - This is a contract to hire with our client. Candidates requiring visa sponsorship will not be considered. Summary: Responsible for mission critical Data Warehouse (DW) and Business Intelligence (BI) development who provides reports, analysis, data visualization solutions. Essential Duties and Responsibilities: ¿ Plan, design, build and manage DW / BI solutions. ¿ Work directly with business units to develop reporting requirements and solutions for key business initiatives. ¿ Ensure business department data needs are being delivered in an accurate, conformed and repeatable manner. ¿ Gain a thorough knowledge of loan origination process and its data. ¿ Provide Data Visualization solutions. ¿ Provide data analysis and ad-hoc reporting quickly and accurately based on business requests. ¿ Integrating data from multiple, disparate sources into the DW. ¿ Write and support T/SQL scripts to create and test the DW / BI solutions. ¿ Support databases for multiple projects and business initiatives, initiating projects and following through to implementation. ¿ Be a proactive and a forward thinking person who will address and formulate long range plans based on the business direction, someone who will work closely with developers throughout the project life cycle and who is interested in understanding the relevant business processes. ¿ Provide strong analytical and troubleshooting skills in fast-paced environments. ¿ Support Database Administration functions as required. Qualifications: ¿ Detailed knowledge of MS SQL Server ¿ Experience working in a DW / BI role ¿ Strong attention to detail and an understanding of the importance of accurate reporting solutions ¿ Strong T/SQL experience ¿ Excellent oral and written communication skills is required ¿ Experience with ETL, SQL Server Integration Services (SSIS), SQL Service Reporting Services (SSRS) ¿ Experience in design, deployment and tuning of SSAS cubes and data marts and experience with Excel Analysis Cube interface ¿ MS SQL Server Certification a plus

Average Oracle DBAs need not apply

Thu, 24 May 2012 11:59:50 EST

Industry: Telecommunications - Category: Data Warehouse - Location: Cincinnati, OH - Are you an experienced Oracle DBA looking for a new and exciting challenge? What to have the flexibility of working virtually? In the complex world of information technology, the new Modis will connect you to the right opportunities and the right answers. Let us help you make exceptional employment connections. Cincinnati Modis is assisting the local Cincinnati data center of an international company in finding a Oracle DBA for a long term contract assignment. SUMMARY: Around 15 years of work experience in Oracle Database Administration: 1. Strong experience in Design, Configure Real Application Clusters (RAC) on AIX, HP and SUN Solaris. 2. Strong Experience in Oracle 11g, 10g, 9i, 8i, Oracle 8.x/7.x, Database Design, Management, System Analysis and System Administration on SUN Solaris, AIX, HP-UX and Windows 2000/NT. 3. Strong skills in installation and configuration of Cluster Ready Services (CRS) using srvctl, crsctl, cluvfy and ocrconfig tools. 4. Strong Experience in Logical and Physical Data Modeling Using ERwin, Designer2000 and ER/Studio. 5. Design and Configuration of Multi Master Replication Servers, Oracle Streams, Standby Database using Dataguard, EMC Time Finder/BCV/SRDF and SAN replication for Disaster Recovery, Site Fail-over, 24X7 Applications and High Volume Batch Reporting. If you or someone you know might be interested, reply to this posting with your resume and contact info or forward your resume to: Bob Sprague - Cincinnati Modis Resource Manager bob.sprague@modis.com

Data Modeler

Mon, 14 May 2012 14:29:00 EST

Industry: Banking/Financial Services - Category: Data Warehouse - Location: North Bethesda, MD - Location: Rockville, MD Duration: Contract to Hire Position: Data Modeler This position requires analyzing data from a variety of data sources to present a cohesive view of data. The candidate will work directly with the task managers, system architects and software developers to analyze application requirements for identification of data requirements to create logical and physical models and specifications of data. Facilitate working sessions to obtain input from technical specialists, customers, end users, and application designers to define the data requirements and structure for the application. The ideal candidate for this position must be proficient in ERwin modeling tool, to effectively model data requirements and document metadata. Knowledge of business process modeling standards and practices (BPMN, UML, RUP, etc.) preferred. This role will report to the Data Architect who will oversee and provide overall data architecture guidance on how the data model should be constructed Daily Responsibilities: • Analyze and integrate information from disparate systems/FDA documents to create a cohesive, comprehensive data model for each identified subject area of data. Develop Conceptual, Logical, and Physical Data Models, using the ERwin modeling tool. • Lead the development of data models and data specifications in close collaboration with the requirements gathering team, aligning data requirements with software requirements. • Participate in technical reviews of ERwin models. • Deliver the application’s data access framework that will be used by application developers. • Plan and implement data model across several releases and potentially multiple task orders. • Manage the change control for updates of data models. • Deliver presentations to development team on developed database schema, and present technical concepts to both technical and non-technical audiences at all levels of the organization.. • Transform Logical models to Physical models, and generate SQL Data Definition Language (DDL). • Must be able to juggle multiple models at one time with direct over-sight responsibility for design, construction, and implementation of data models. Qualifications: • Bachelor's Degree or higher plus 10 years relevant experience in software engineering and data architecture/modeling. Experience should include minimum 5 yrs data architecture/modeling experience. • Prior experience leading a data architecture/modeling effort of similar size and scope. • Must be proficient with data modeling and ERwin modeling tools • Must be proficient with database desgin and development and Oracle RDBMS. • Must be proficient with data migration, synchronization and Informatica • Must be proficient with SQL, PL/SQL and Java Desired Skills: Knowledge of business process modeling standards and practices (BPMN, UML, RUP, etc.) ***Please send all resumes to jill.barlow@modis.com***

Data Modeler

Wed, 23 May 2012 22:44:44 EST

Industry: Banking/Financial Services - Category: Data Warehouse - Location: West Des Moines, IA - Multiple Data Modeler positions open right now!!! Contact Modis Recruiter Madelyn Hakes at madelyn.hakes@modis.com or 515-327-7557 My client is looking for Data Modelers with 6+ years of development experience and ideally a financial background. If this is you please contact me!!! You don't want to miss out on this opportunity. Madelyn Hakes | Resource Development Manager Modis Modis, Inc. | 4401 Westown Parkway #303 | West Des Moines, IA 50266 515.327.7557– Office| 515-223-6215 - Fax madelyn.hakes@modis.com – Email www.modisit.com

OBIEE/Analytics Developer

Thu, 17 May 2012 12:27:14 EST

Industry: Other - Category: Data Warehouse - Location: Piscataway, NJ - Modis is one of the world’s largest Information Technology Staffing companies. Come join our experienced team and enjoy the competitive advantages of working with us. We offer a comprehensive benefits package in addition to access to local positions that are specifically matched to your career parameters. Please contact me to discuss this role, as well as other positions that may be a fit for your job search. Modis is seeking candidates for a full time job opportunity which is located in Piscataway, NJ. Please rush resume to meenakshi.sarangdevot@modis.com Meenakshi Sarangdevot, Resource Development Manager, MODIS 732-529-2017 (desk) Job Title: OBIEE/Analytics Developer Location: Piscataway, NJ Type: Full time Job Description: The client is moving from Siebel Analytics to Oracle OBIEE. Need only 1-3 years of OBIEE exp. Strong understanding of dataware housing and ETL/Informatica This is a hands on technical position requiring analytical and problem solving skills. The person in this position will be required to understand business requirements, architect, independently design, develop and implement solutions. In addition, the person is able to read high level requirements and provide effort estimates to help in project planning. The Senior Programmer Analyst follows the IT Development methodology, ensuring best design and compliance with programming practices, source code control, and change management procedures.. Essential functions include but are not limited to: • Assisting users in tuning and building reports • Analyzing and deploying fixes to defects and help desk tickets • Conducting design review sessions with peers and QA teams • Working with the respective software vendor to implement solutions when there are issues or enhancements needed to the vendor provided software • Coordinating and managing of batch integration processes with specific business team members as and when needed • Planning and conducting unit and system integration tests for all project solutions and defect fixes. • Reporting progress and issues to Project Leader/Manager on a regular basis. • Serving as a subject matter expert in the field and stays up to date on current technology trends in the area of expertise Requirements: • Has at least 7 years overall Business Intelligence experience • 5+ years of hands on analysis and development experience in OBIEE/Analytics with at least 1+ year experience in OBIEE 11g • 5+ year of hands on analysis and development in Informatica ETL. Additional experience in DAC preferred • 3+ years of working with OBI Applications • 3+ years on Unix/Linux preferred • Sound knowledge of Oracle Data Warehouse data model • Excellent knowledge and minimum 5 years experience in Oracle SQL & PL/SQL and Data Warehouse design • 2+ experience in performance tuning in OBIEE, Informatica and Database desired • Must be a team player and have excellent communication and presentation skills to work with individuals and teams across the organization • Ability to work independently with minimum supervision • Displays enthusiasm and positive energy

Hyperion Developer

Mon, 14 May 2012 14:29:24 EST

Industry: Healthcare - Category: Data Warehouse - Location: Rockville, MD - Be a part of a company that influences the entire world! Our client is a non-profit scientific organization that sets the standard for medicine, food ingredients and supplements that are used in over 130 countries around the world, and the standards they develop are enforced by the FDA. Not only do they make a huge impact around the globe, but they were founded almost 200 years ago! What could make this opportunity any more exciting? Read on… Perks: - Direct hire, permanent position in Rockville with an excellent salary - Excellent Benefits – all family insurance is 100% paid by the client, no out of pocket expenses for you! - Relocation assistance for the right candidate - Annual bonus system - 401k matching Required Skills: - 5+ - 7 years experience in end to end Hyperion development (don’t need an architect, just a developer) - Bachelor’s degree - Implementation experience for 2 complete projects (implementation will be done next year so some planning experience is a plus) - Data warehousing experience - Must be able to obtain a secret clearance (don’t need to have one, but must be clearable) Please email qualified resumes to Christopher.wiseman@modis.com. Please include salary requirements as well as the best number and time to reach you.

Senior ETL Developer

Thu, 31 May 2012 13:27:57 EST

Industry: Education - Category: Data Warehouse - Location: Pittsburgh, PA - ***PLEASE SEND RESUMES TO PITTSBURGH@MODIS.COM TO APPLY*** Our client has a need for a Senior ETL Developer for a full-time, direct hire opportunity in Pittsburgh, PA. The client is looking for someone with heavy SQL experience, with a minimum of 5 years of developing Business Intelligence solutions. Qualified candidates will meet the following requirements detailed below: Description: Individual will be responsible for designing and developing Business Intelligence solutions for the enterprise utilizing Microsoft SQL Server, Teradata, SQL, Unix/Bash, SSIS and/or Informatica PowerCenter. The DW Developer will work on-site at the client’s headquarters located in Pittsburgh, PA. Key functions include designing, developing, testing, debugging, and documenting ETL processes for enterprise-wide Data Warehouse implementations. Position reports to Supervisor. Data Warehouse Analytics. Responsibilities Include, but are not limited to: • Works closely with business and technical teams to understand, document, design and code ETL processes. • Works closely with business teams to understand, document, design and code ETL and Reporting needs utilizing dimensional models. • Translate source mapping documents and report requirements into Dimensional Data Models. • Design, Develop, Test and Optimize ETL routines utilizing SQL, Bash, SSIS and Informatica PowerCenter. • Assist with converting the client’s legacy SQL Server DW to Teradata platform. Required Skills: • 5+ years developing Business Intelligence solutions. Understanding of ETL methodologies, Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs and usage of data warehouses and data marts. • Demonstrated best practice experience for Data Integration and Data Movement • 3+ years experience with one or more of the following: Microsoft Business Intelligence, Oracle or Teradata. • 3+ years experience working with and/or creating dimensional models • Must demonstrate strong verbal and written communication skills and be able to interface with all levels of business and IT organizations. • Work well in a team-oriented environment managing multiple priorities, following a project plan and meeting project delivery dates. • Highly organized individual with excellent decision making, analytical, problem solving and presentation skills. • Experience working as an implementation team member with critical individual contributor responsibilities. • Physical data architecture, design, modeling, integration, and reporting experience • Strong Problem Solving skills • Experience with Performance Tuning • Experience with various SDLC methodologies • BS degree in Computer Science or MIS. Preferred Skills: • Education Industry experience • Informatica PowerCenter with CDC experience or SQL Server Integration Services • SQL Server Integration Services • Unix/Linux/Bash scripting • Teradata ***PLEASE SEND RESUMES TO PITTSBURGH@MODIS.COM TO APPLY***

ETL Developer

Tue, 08 May 2012 12:16:15 EST

Industry: Technology - Category: Data Warehouse - Location: Des Moines, IA - Are you an IT professional that is looking for that one position that will catapult your career to the next level. Well if you have... 1. Knowledge of developing computer programs, application components, or developing integration and migration functions. 2. Knowledge of the ETL process with technical development experience of Informatica and SQL. ....I have your catapult right here. Please contact me for additional information and we can schedule a time to speak in more detail. Email is the best way to reach me at adam.viet@modis.com. I look forward to hearing from you.