Archive for the ‘database’ tag
Marketing Senior Man Job in northbrook 60062, Illinois US
The Allstate Corporation is the nations largest publicly held personal lines insurer.
A Fortune 100 company, with $156 billion in assets, Allstate sells 13 major lines of insurance, including auto, property, life and commercial.
Allstate also offers retirement and investment products and banking services.
Allstate is widely known through the Youre In Good Hands With Allstate® slogan.
Allstate was founded in 1931 and became a publicly traded company in 1993.
Reporting to the Director, Planning, Measurement and Administration, the Senior Marketing Analytics Manager, will develop and produce marketing analysis relating to Allstate customers, products, and distributions channels.
The primary role of this individual is to serve as mentor/coach to the entire analytics team and to develop expertise in marketing operations, marketing information, campaign test design, measurement infra-structure, and to develop advanced computer code so as to serve as this mentor.
Additionally, this position will design, develop and interpret statistical and business analyses/models utilizing enterprise databases for business units that do not currently have these capabilities.
This position will provide accurate timely campaign and portfolio analyses including baseline portfolio metrics.
The analyses and metrics will be critical input to the marketing decision making process.
The primary audience for these analyses will be marketing senior management and internal business partnersThe skills required are: · Creative problem solving in an analytical and technology-based environment (advanced) · Written and presentation skills of complex issues (advanced level) · Use of analytical software (SAS/SPSS) (advanced level) · Manipulation and large data format in UNIX Operating System, and Oracle database environment (advanced level) · Ability to interpolate data as information and information as relevant to business strategies and economics · Microsoft EXCEL, PowerPoint, Word and Outlook (intermediate level) · Above average information technology skills, including large multi-dimensional database experience including efficient querying of large database with operational component (performance degradation) (intermediate to advanced level) · Familiar with general demographic concepts, including census data geographic divisions (zip codes, census tracts, block groups, etc.). · Demonstrated ability to manipulate and qualify information at lowest detail level (intermediate to advanced level) · Project management capabilities within large and small teams · Coaching and mentoring for complex technical and business issues related to marketing programs.
Experience Required: · Working in a sophisticated multi-dimensional database-marketing environment.
· Experience in the development analytical processes and output, specifically in the areas of measurement, evaluation and recommendation.
· Advanced understanding of marketing campaigns, analytical concepts and methods, including knowledge of database marketing techniques for direct mail.
· Understanding of marketing targeting concepts, application of models, segmentation methodologies · Working effectively in non-structured environment, independently with minimal management involvement
PL/SQL Developer Job in ATLANTA, Georgia US
Industry leader is seeking a Database Engineer to join the conversion team.
The Database Engineer will be responsible for reviewing and creating complex Entity Relationship Diagrams as well as create/update sequence diagrams .
In this role you will also create/execute unit and integration test scripts, and design/develop SQL Server 2008 database objects (ie tables, views, stored procedures, triggers, etc.). The Database Engineer will create SQL queries using PL/SQL and T-SQL that will be used by the conversion applications and design/develop conversion applications utilizing SQL Server Integration Services (SSIS) as well as design/develop conversion reports using SQL Server Reporting Services (SSRS).
Must have strong skills in: Relational Data Base concepts; Reviewing and/or creating ERDs; Writing complex T-SQL queries and procedural logic; Designing and developing SQL Server database objects; Performing complex data analysis.
This is a high profile project and looking for candidates you have the make it happen attitude.
Application RequirementsClient will only consider local candidates.
Not accepting third party candidates for this position.
Required Qualifications: SSRST-SQLEntity-relationship diagramsPL/SQLSQL ServerRelational DatabasesSSIS (SQL Server Integration Services)Benefits/PerksSupplemental Disability and Long-Term Care Insurance, Dependent Care Assistance401(k) with Roth feature529 Educational Savings PlanFree e-Learning CoursesMedical, Dental, Vision, and Life Insurance for Full-time W2 Consultants.
mtxHdr {font-size
1. 5em; color: #004E61; font-weight: bold}About MATRIXFor more than 25 years, MATRIX has placed talented contract and permanent IT professionals like yourself at thousands of top-notch organizations throughout the U.
S., ranging from Fortune 50 to small IT shops across all industries.
MATRIX surrounds you with personal services from assistance with your resume and interviewing skills, to background information on the companies you will interview with, and more.
Once you are onboard as a TeamMATRIX consultant, we offer outstanding benefits, a 401(k) program (or plan), discounted training, and other valuable incentives.
www.MyMATRIXjobs.com, our Job Search Portal, features hundreds of jobs that we update hourly.
Unique functionality helps you streamline your job search and job application process.
You will benefit from productive job search tools such as: – Advanced Job Search- Job Alerts- Job Watches- Job Status TrackingPut the Power of Collaboration to work for you! Apply today at MATRIX.
Please Note: Your resume will never be submitted to a client company without your prior knowledge and consent to do so.
Database – Global Form Designer Job in San Francisco 94105, California US
PLEASE NOTE: ONLY LOCAL SAN FRANCISCO BAY AREA CANDIDATES WILL BE CONSIDERED Look no further!! Come check this company out!! This small software company, with a national clientele, continues to grow and seeks a talented GLOBAL FORM DESIGNER to join their team. The company, located in San Francisco, offers an energetic, dynamic and fun business casual work environment. It is close to BART and close to the Ferry Building and Muni. The individual chosen will work with a skilled, experienced and respected team and become an integral part of their success. This position includes an outstanding benefits package and the opportunity for continued education, additional certifications and strong career growth. Non-exempt position – eligible for overtime. Ready to hire NOW!! TO APPLY: Please email your cover letter and resume as a WORD document attachment and your target hourly salary requirements. Interviews will take place in our clientâs San Francisco office. SF Bay area candidates only. POSITION OVERVIEW The ideal candidate will be motivated, enthusiastic and ready for new challenges and opportunities. Candidateâs primary task will be to create and maintain immigration-related forms and questionnaires (for US and many other countries) using proprietary methodologies and established protocols. Candidate will map data between database and specific form and questionnaire fields using SQL stored procedures. A critical eye for formatting and layout is required, as well as meticulous attention to detail. Candidate will test his or her work, identify possible issues, and document solutions for bugs & fixes. In addition, candidate will participate on project teams for new and revised product interfaces, complete special projects involving online government forms, test new database and application software prior to release, and will optimally draft and proof tutorials and quick reference guides for end-users. REQUIREMENTS: â¢Bachelor’s or Associateâs degree with a preference for Computer Science, Information Technology or a related technical degree. â¢Intermediate knowledge of Adobe Acrobat Pro 8.0 and Adobe LifeCycle Designer a plus.â¢Familiarity with XML desired.â¢Familiarity with Visual Basic formatting functions desired.â¢Familiarity with HTML and Visual Studio desired.â¢Intermediate knowledge of Microsoft Word (2003 and newer) desired.â¢Requires excellent oral and written interpersonal communication skills with a strong positive team-oriented attitude. Must be able to speak effectively with both non-technical end-users as well as IT professionals. â¢Demonstrated experience in problem resolution and technical problem identification. â¢Help-desk and / or technical customer support representative ( CSR / TSR ) experience a strong plus. â¢SQL experience – intermediate skill level required. The right candidate must be comfortable working in Management Studio in SQL 2005 / SQL 2008, writing queries, and writing stored procedures.â¢Must understand database structures and relationships.â¢Requires strong attention to detail, outstanding resourcefulness, flexibility, and the ability to work independently as well as within a team setting. â¢Comfortable with working in a large shared office space with individual work-stations. â¢Typical work hours are 8:30â 5:00, Monday- Friday. Some OT required. â¢Familiarity with U.S. and / or global immigration a big plus.
Database – Global Form Designer Job in San Francisco 94105, California US
Data Architect Job in Fort Wayne 46898, Indiana US
We are seeking a Data Architect/Technical Architect to join the team at one of our clients in Northern Indiana. This insurance company has selected to implement PeopleSoft and they plan to implement General Ledger. The Architect will be gathering requirements from the business users in order to determine what data they need, direct where it needs to go and why. This individual will also be responsible for mapping out/designing the logical flow of the data throughout the DI Hub, General Ledger System (PeopleSoft), Data Warehouse, BI Reporting environment and various source systems.This is a very stable organization with opportunity for tremendous growth this year. This individual is going to be part of the core group of people as the implementation date nears. Applicants must possess the following skills/experience:- proven experience in data modeling and data integration- ability to understand the language and terms and be able to work with the business- logical database design experience using data modeling tools (ERwin)- Insurance/Accounting/Finance industry knowledge/interest/experience is highly preferredThis position is available immediately! All available/interested and qualified candidates, please apply to this posting and/or contact me directly at 317.810.7560.Required Skills: DATA MODELING, DATABASE DESIGN, LOGICAL DATABASE DESIGN, DATA ARCHITECTJoin TEKsystems® and get your career on the fast track. As the leading technology staffing and services firm, we are passionate about deploying high-caliber IT and communications expertise. To satisfy our constant need for expertise, we actively seek talented Technical Professionals with all levels of information technology and communications skills. TEKsystems knows that every professional has different needs, so we’ll work together to determine a suitable benefits package. We offer options to our Technical Professionals that could include: a health plan, 401k, provisions for vacation and holiday pay, and technical and professional training. With a foundation as the nation’s largest IT staffing firm, we’ve become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Allegis Group and its subsidiaries are equal opportunity employers. M/F/D/V
Senior Business Analyst (1564) Job in Chesterfield
Protectiveâs Asset Protection Division offers its products and services through automobile, marine, RV and power sports dealers. Through these business partners, the Asset Protection Division offers consumers protection against unwanted losses they may experience after purchasing and financing major consumer assets such as automobiles, boats and recreational vehicles. Our products and services are superior and we need superior people to join our team!DescriptionBasic Purpose: The Analyst is responsible for working with customers and end users to define and document functional requirements and scope of IT projects, and supporting the functional design process. The analyst will have the ability to learn the business functionality of multiple systems on different platforms. Works with members of the business community and collaborates with other technical team members. Must communicate effectively with internal customers and ensure that customer expectations are properly managed.Responsibilities: 1. Analysis. Perform business analysis for major IT systems. Work with user community and programming staff to define the scope of new service requests and projects. Research, identify and clearly document functional needs.2. Functional design documentation. Deliver informative, well-organized requirements to stakeholders for acceptance. Develop specifications for communication and use by programmers3. Project Execution. Work with project teams to ensure quality throughout the pre-development life-cycle, including identification of software defects.4. Report generation. Perform system reporting using Cognos and/or AS/400 query function and service request database to support the user community and gain more in depth knowledge of data structures to aid in system and service request analysis.5. Manage Inbound Service Requests. Actively review database entries and prioritize requests with functional department managers. Maintain current status and activity of service requests in the request database. Comply with Sarbannes Oxley standards.6. Customer relations. Conduct process review meetings, take input from manager and appropriately apply comments/feedback. Moderate meetings with project teams to ensure that customer expectations are properly managed.7. Ongoing professional development. Pursues continuing education opportunities in business analysis and industry subjects.8. Perform other job related duties as assigned.   Required SkillsWorks well with business partners in identifying business requirementsàWorks well in a team environment; interacts well with a variety of personality typesàAbility to design an develop solutions to meet customer requirementsàExcellent written and verbal communication and interviewing and facilitation skills Responsive to users (customer service orientation) Ability to work independently with little supervision Required ExperienceCollege degree, or four years relevant experience plus 2 years industry experience Possess and understanding in the areas of application programming, database and system design Knowledge of SQL, Cognos business intelligence tools and AS/400 environment a plus We also offer a competitive benefits package that includes Medical/Dental/Vision plans, 401(k), a Cash Balance Pension plan, paid vacations and holidays, life insurance, short-term/long-term disability, and a Flexible Spending Account. In some locations, we offer free parking or commuter benefits. Please apply directly at:our website
Microsoft SQL Data Base Administrator & SQL Server Developer Job in Saint Louis, Missouri US
Our client is seeking an experienced professional to join their St Louis team as a Data Base Administrator and SQL Server Developer. Duites include:Responsible for the stability, scalability, behavior, security and performance of SQL Data Bases and SQL based processes.Maintain and upgrade SQL patch levelsMonitor event and error logs, drive space availabilityResponsible for database backup operationsTest and implement new releases of SQLTest and oversee the implementation of SQL db applicationsDemonstrate the ability to prioritize efforts in a rapidly changing and dynamic environmentParticipate in 24x7x365 on-call rotationThis position regularly interacts with application developers, system administrators, project managers, technical requirements managers and client services reps. The successful candidate must be able to work effectively, independently and cooperatively within a team structure, in both cases striving to achieve shared company goals.REQUIREMENTS:Degree in a MIS related fieldProfessional appearance and demeanorMCDBA (Microsoft Certified DBA)4+ years of information technology experience3+ years in a DBA role working with Microsoft SQL relational databases2+ years experience using Microsoft Analysis Services and Reporting Services2+ years experience working directly with business terms2+ years creating, configuring, implementing and performing SQL server maintenanceExpert level proficiency in Transact-SQL, building triggers, writing stored procedures, and building other database objectsExtensive knowledge of relational database concepts, SQL and TSQLIn depth experience in MS SQL upgrade proceduresIn depth experience with Database ReplicationIn depth experience with Database Log ShippingIn depth experience with Database backup operationsIn depth experience with Database optimization proceduresBasic knowledge of Microsoft Visual Studio (.NET)Basic ability to program in VB.NET and HTMLExperience with SQL Profiler and Performance Monitor required.This is a Direct Hire opportunity. They offer an excellent compensation package including salary, benefits, paid holidays, paid vacations and sick days. This an exceptionally professional environment with an rapidly growing organization. This is a key position within the organization with strong promotional opportunities. Drug screen and background check are required.No relocation — local candidates only.
Microsoft SQL Data Base Administrator & SQL Server Developer Job in Saint Louis, Missouri US
Database Developer Job in Chicago 60610, Illinois US
Database Developer
Data Analyst Job in Los Angeles 90046, California US
AMAZING INDIVIDUALS WORKING FOR POSITIVE PEOPLE at AIDS Healthcare Foundation!Does the idea of doing something that really makes a difference in peopleâs lives while being well-compensated intrigue you? Are you looking to work for an organization that encourages growth and success from each and every one of its employees? If so, AIDS Healthcare Foundation is the place for you! Founded in 1987, AIDS Healthcare Foundation is the largest specialized provider of HIV/AIDS medical care in the nation. Our mission is to provide cutting edge medicine and advocacy, regardless of ability to pay. Through our healthcare centers, pharmacies, health plan, research and other activities, AHF provides access to the latest HIV treatments for all who need them. STILL INTERESTED? Please continue! AIDS Healthcare Foundation is searching for a Full Time Data Analyst to work in our in Linn House Administrative Office: 1001 N. Martel Ave., Los Angeles, California. The hours for this position are Monday-Friday from 8:30 a.m. to 5:30 p.m.JOB DESCRIPTIONESSENTIAL DUTIES & RESPONSIBILITIESIncludes the following. Other duties may be assigned.- Accesses multiple medical/financial/administrative databases and provide ongoing reporting that supports information-based decision making, measures the execution of strategy, and identifies opportunities for improving existing processes.- Confers with the persons requesting database services and/or reports to identify needs, requirements or problems in order to produce an accurate data gathering and reporting environment. – Assists in the development of reports that determine basic characteristics such as origin and report flow, format, frequency, distribution and purpose or function of report.- Recommends establishment of new or modified reporting methods and procedures to improve report content and completeness of information.- Demonstrates experience and skills in Relational Database Management Systems (RDBMS) like SQL Server and writing complex Data Transformation Services, Stored Procedures, etc. in SQL.- Programs applications in Microsoft Access and Visual Basic.- Supports business functions of enrollment invoicing, member services database support, claims system (EZ Cap) payment and MAS 90 integration accounts payable support.- Document data base configuration and update documentation with each change.- Document policies and procedures required to support system enhancements.- Prepares various reports required by funding sources, fiscal intermediaries, medical staff, and management on a routine and ad hoc basis.- Prepares various financial reports required by funding sources, including but not limited to Medi-Cal cost and utilization reports, the Department of Health Services (DHS), managed care filings, and other external financial reports.- Works regularly with management, physicians, other AHF programmers, and consultants to determine, interpret and program solutions.- Works continuously to improve efficiency of programs and process in use.- Interacts with multiple Foundation (e.g., Finance, Medicine, Nursing, Case Management, etc.) personnel to ensure open lines of communication and compliance with established procedures.- Supports the enrollment invoicing process by maintaining the appropriate data bases and analyzes the data for accuracy. – Collaborates with other companies and organizations (i.e., Department of Health Services, vendors) to ensure data transmission systems remain open and running efficiently.- Prepares and submits the monthly state invoice for Positive Healthcare.- Develops and assists in the maintenance of Managed Care applications.- Interacts with the Information Technology Department in order to facilitate information flow and business solutions.PARTICIPATION IN AHF MEETINGS/COMMITTEESAttends AHF meetings as assigned.SUPERVISORY RESPONSIBILITIESThis job has no supervisory responsibilities.QUALIFICATIONSTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.EDUCATION/EXPERIENCEBachelor’s Degree (BA)or higher in Computer Science or related disciplines; 3+ years experience including 1+ year in Healthcare Services – Medical Records, Health IT or Informatics; Managed Care experience preferred; Or equivalent combination of education and experience.COMPUTER/SOFTWARE SKILLS & ABILITIESTo perform this job successfully, an individual should have knowledge of Database related software(SQL 2000 or SQL 2005, MS Access Data Project); Internet software; Spreadsheet software, and Word Processing software.OTHER SKILLS & ABILITIES/QUALIFICATIONS- Ability to summarize analytical results graphically and numerically in Crystal Reports,MS Excel, PowerPoint, etc. – Proficient and demonstrated use of database reporting tools for data manipulation, data extraction, merging of large, complex data from variety of sources.- Prior experience with health-related applications(EzCap, Logician, Cactus, etc.).PHYSICAL DEMANDSThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Are you intrigued by this amazing opportunity? Are you eager to learn more? If so, please send your resume via e-mail to: Careers@aidshealth.org ADDITIONAL INFORMATIONSalary: Based on ExperiencePosition Type: Full Time, EmployeeLocation: 1001 N Martel Ave., West Hollywood, CA 90046Days/Hours: Monday-Friday from 8:30 a.m. to 5:30 p.m.Reference Code: 0700 Data Analyst CONTACT INFORMATIONDavid MarinHuman Resources ManagerAIDS Healthcare Foundation6255 W. Sunset Blvd., 21st. FloorLos Angeles, CA 90028Email: Careers@aidshealth.org We look forward to hearing from you!