ETL / Data Warehouse Developer - Troy, MI

iVantage Group is currently looking for an ETL / Data Warehouse Developer for a great client of ours in Troy, MI. This position is a full time, contract (6 month). 


The best candidate is one that is strong in SQL (primarily Oracle) and one that has spent time building out reports (currently reporting solution is BO).

REQUIREMENTS: 
•More than 8 years Data Warehouse experience in a technical role of large relational data warehouses. Experience with Oracle databases preferred
•Implementation experience with ETL concepts and tools (such as Data Migrator, Informatica, Data Stage, Ascential) required.
•Emphasis on SQL especially within the ORACLE space.
•Strong knowledge of data warehousing concepts in relational databases.
•Strong understanding of dimensional data models.
•Strong understanding of building out reporting as part of a comprehensive BI solution.
•High standards of customer service.
•Bachelors degree in Computer Science or related field.
•Ability to collaborate in a team environment, offering vital information where necessary.
•Ability to work closely with system/solution architects and other team members.
•Ability to communicate effectively to both technical and business leaders, working well with Developers, Managers, and DBAs.
•Experience in data integration/warehousing is highly preferred.
•Experience using Microsoft Office suite of products especially Word, Excel, and Access. 
•Requirements analysis, data assessment, business process reengineering, and familiarity with data warehousing design concepts such as 3rd Normal Form and Dimensional models.
•Good understanding of data warehousing project life cycle, especially tasks within the ETL phase.


Please send a copy of your resume to Karen Alfanos at Karen@theivantagegroup.com or visit our website www.theivantagegroup.com to apply online.

PeopleSoft Developer - Ann Arbor, MI

iVantage Group is seeking a talented, PeopleSoft Developer for a great client in Ann Arbor, MI. This position is a full time, direct hire opportunity.

Plan, develop, and launch efficient information systems and operations systems in support of core organizational functions. Exercise judgment in developing methods, techniques, and evaluation criteria for obtaining development plan. Apply proven communication, analytical, and problem-solving skills to help identify, communicate, and resolve system issues in order to maximize the benefit of IT systems investments and support end users in efficiently and effectively fulfilling business objectives

Major Responsibilities:

•Develop and support PeopleSoft applications, and collaborate with other developers and architects on solution architecture, scalability, maintainability, and efficiency.
•Assist in production support resolution as required.
•Assist in project deliverables as required.
•Define and conduct system tests and system validation.
•Work with business analysts to understand and document program development requirements.
•Develop and maintain project documentation and deliverables as required.
•Develop technical documentation for all deliverables.

Required Skills:

•Excellent communication, analytical, and presentations skills.
•Excellent interpersonal skills and the ability to work as a results oriented team player.

•5 - 7 years of PeopleSoft developmental experience with:
-PeopleCode
-Application Designer
-SQR
-Component Interface
-Application Engine
-SQL
-Master or Bachelor Degree in Information Systems or related field
-5 years experience in software application development and support

Preferred Skills:
•5 - 7 years of functional knowledge of PeopleSoft modules with: (PeopleSoft Financials 9.X)
-Accounts Payables
-Accounts Receivable
-Billing
-Asset Management
-General Ledger

Additional Preferred Skills:
•EDI Integration
•Work Flow 
•XML Publisher
•PeopleSoft upgrades


Please send a copy of your resume to Carey Allen at callen@theivantagegroup.com or visit our website www.theivantagegroup.com to apply online.

SQL Programmer - Auburn Hills, MI

iVantage Group is currently seeking a talented SQL Programmer for a tremendous opportunity with a great client in Auburn Hills, MI. This position is a contract opportunity.


The SQL Programmer provides analyzes the programming needs of the end user, providing technical support for all Teams and Departments, such as coding, designing, implementing, and debugging programs.
Essential Functions
Under direction perform the following:
• Ensure the timely creation and distribution of weekly, monthly, quarterly, and annual reports and data files.
• Ensure the deliverables are properly distributed to the organization and external parties, where appropriate.
• Analyze the needs, design, program, test, and implement management reports within the Authority
• Thoroughly document and properly inventory any completed work.
• Maintain the overall IS department inventory of management reports produced within the department.
• Assist various staff in identifying and correcting data integrity issues.
• Ensure continued compliance with all security and privacy requirements of our client and State and Federal regulations.
• Work as a team member in the development of new software systems for gathering and reporting data for our client.
• Other duties as assigned
Job Requirements and Qualifications
Education:
Individual must possess a Bachelors degree in an Information Systems related field from an accredited college or university
Training Requirements (licenses, programs, or certificates):
Experience:
Minimum of two years experience in a related computer systems field in the healthcare industry.
Knowledge Requirements:
• Demonstrated working knowledge of the databases systems that supply data to the management reporting needs of the Authority
• Demonstrated working knowledge of the report and system
Competencies/Skills:
Core Competencies:
• Interacting with others in a way that gives them confidence in one’s intentions and those of the organization; maintaining social, ethical, and organizational norms; firmly adhering to codes of conduct and ethical principles. (Integrity/Building Trust)
• Making customers and their needs a primary focus of one’s actions; developing and sustaining productive customer relationships, recognizing that the ultimate customer is the consumer. (Customer Focus)
• Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge and skill on the job and learning through their application. (Continuous Learning)
• Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence in addition to consciously adopting organizational standards of excellence. (Work Standards)
• Clearly conveying information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message. (Communication)
Other Information
Special Information (Travel required, physical requirements, on-call schedules, and so on):
• Must have available means of transportation to and from Authority and for required offsite meetings or site visits.
• Work performed primarily in an office environment.

Please send a copy of your resume to Gina Maurino at gmaurino@theivantagegroup.com or visit our website www.theivantagegroup.com to apply online.

Citrix Server Administrator - Troy, MI

iVantage Group is currently looking to fill a Citrix Server Administrator position with a great client of ours in Troy, MI. This position is a full time, contract-to-hire opportunity.

The Citrix Server Administrator position will be responsible for day-to-day support of the Citrix Microsoft Windows servers and Citrix farms. Be able to support Citrix end users on a 3rd level support basis. Install and configure Citrix XenApp and applications. General Citrix Administration tasks (migrations, new implementations, etc) are expected with this role. Patch management on the Citrix servers will be required.

This is not an entry level IT position. Prior Citrix/Microsoft server administration experience is required.
The position will also require occasional weekend work as part of a formal change control process and occasional after hours work to respond to any issues when required. An oncall rotation is also expected from this position.

Required Qualifications/Skills:
Prior experience in administering, building, designing, and maintaining Citrix environments a must.
Knowledge or experience with the following environments are required: Citrix XenServer, Citrix XenDesktop, Citrix Presentation Server/Xenapp, Access Gateway/Secure Gateway/NetScaler, Citrix Provisioning Services, and Citrix EdgeSite.

Other Qualifications:
Prior experience with VMware ESX/ESXi/Server/Workstation a plus.
Prior experience with Microsoft Active Directory a plus.
Prior experience with Microsoft MOM/SCOM a plus.
Prior experience with Microsoft SMS/SCCM/WSUS a plus.
Prior experience with Symantec NetBackup a plus.
Knowledge of SAN/NAS disk storage for NetApp and EMC storage systems a plus.
Prior experience in VB, PowerShell, and XML scripting a plus.
Certifications in one of the following areas are helpful:  Citrix Certified Administrator (CCA), Citrix Certified Advanced Administrator (CCAA), or Citrix Certified Enterprise Engineer (CCEE) but not required.

Comments:
Must be assertive, confident and comfortable taking the lead by establishing command and control when necessary.
Excellent communication skills (written and verbal; ability to communicate across all levels with various customers).
Strong organizational skills with the ability to handle numerous work streams simultaneously.
Must have great attention to detail while operating with urgency, focus and discipline.
Excellent analytical and problem solving skills required (troubleshooting or other problem/incident management experience).
Maintains awareness and expertise relative to evolving technologies and techniques.
Must have the ability to work independently; strong thought leadership and motivation.

Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at www.theivantagegroup.com 

Portfolio Project Manager - Troy, MI

iVantage Group is currently seeking a strong Project Manager with experience in portfolio management and banking systems. This position is a full time, direct hire opportunity.


The role of Project Portfolio Manager is to manage the delivery of a portfolio of projects and a team of Project Managers with a focus on the advancement of project management and its role in helping the enterprise successfully achieve corporate objectives.  This position requires a dynamic individual who can foster improvements, successfully build partnerships, and champion engagements across organization boundaries.


Job Functions

• Drive improvements in project management throughout the company by setting corporate-wide standards for  project management  and leveraging best industry and internal practices.
• Communicate project status to executive team, functional managers and other key stakeholders, highlighting key contributions needed to “stay on track”.
• Perform  project reviews to assess and improve the quality of project delivery through monitoring the health of ongoing projects and driving accountability.
• Serve as the point of contact and escalation for the project sponsors and governance entities.
• Leverage strong facilitation and negotiation skills to drive decisions across all levels in the organization, including portfolio discussions on trade-offs based on resource needs vs. capacity, and risk/reward scenarios.

Leadership Responsibilities and Position Complexity

• Understand at a high level the solutions being developed and/or deployed, the business value and how it aligns with the overall business operation and corporate objectives.
• Proactively work with technology and business managers to eliminate critical path road blocks and cross functional conflicts to help ensure successful delivery of the solution.
• Improve project execution by coaching Project Managers and teams in building well-integrated, realistic project plans, and by ensuring team and organization commitment to desired results.
• Contribute to the development of team spirit and inspire the management group to lead by example.
• Demonstrated ability to lead through organizational change, lead under pressure  and develop creative solutions to project challenges.

Position Prerequisites

• BS or BA degree in computer science, business administration or related field, or equivalent experience.
• 7+ years program and/or portfolio management experience including Banking System implementations with vendor components and cross-functional teams.
• Portfolio financial planning and cost tracking experience with an in depth knowledge of Microsoft Office products. 
• Experience implementing continuous improvement objectives within a project delivery environment.
• PMP Certification required.
• Program Management Professional (PgMP) Certification is a plus
• Significant experience managing direct reports.

Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at www.theivantagegroup.com   

PHP Developer - Detroit, MI

iVantage Group is currently seeking a talented PHP Developer for a great client of ours in the Detroit, MI area. This position is a full time, direct hire opportunity.

Position Description:

A PHP Developer works on a project-by-project basis with other engineers, web developers, business and marketing team members to create an intuitive experience for website visitors and clients. This includes extending and improving an object-oriented PHP framework, building solutions and maintaining existing applications in a high-energy environment.

Primary Duties and Responsibilities:

- Build Great Web Sites: work with other engineers, developers, architects, QA, system engineers and project managers in solving new and existing technical challenges

- Talk the Talk, Walk the Walk: understand requirements, implement solutions, provide administration tools and documentation for specific projects

- Be There When Needed: perform scheduled on-call duties

- Speak Up: participate in Design and Code Reviews

- Find A Better Way: follow and enhance existing development processes; Measure and verify that new and old code has acceptable performance and scalability; Maintain ownership of the projects assigned

- Get It Done: deliver accurate estimates, provide regular feedback and consistently meet project deadlines

Knowledge, Skills, and Abilities:

- Exceptional Object Oriented PHP Development Experience: four (4) + years of professional-level OO PHP 5 experience, including experience with MVC Frameworks

- Plays Nice With Others: collaborative development experience, able to explain complex ideas and concepts to non-technical team members

- Unit Testing Makes You Happy: understand how and why unit testing delivers better solutions and speeds up maintenance

- Laser Vision: superb attention to detail

- Experience with Web Standards philosophies and modern XHTML/HTML /CSS markup recommended

- Related experience in software testing and design desired

- Team-oriented experience highly desired

- Excellent oral and written communication skills regardless of audience

Minimum Education/Experience Requirements:

- Bachelor's degree in computer science, software development, art and technology, information technology, information systems or equivalent work experience

- Established portfolio of work and/or code samples

Physical Requirements:

- Must be able to effectively write and modify code for 8 plus hours/day

Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at www.theivantagegroup.com  

ASP.Net Developer - Williamston, MI

iVantage Group is looking to fill several ASP.Net Developer positions with a great client of ours in Williamston, MI (east of Lansing, MI). This is a direct hire, contract-to-hire opportunity.



Primarily responsible for the development of custom website and applications relevant to business-driven initiatives. Work may be performed via defined project plan or self-directed. Existing application maintenance and customer support will be required.

Essential Functions:
- Develop efficient and maintainable code-based solutions adhering to defined corporate programming standards
- Unit test developed code for quality assurance
- Provide support for existing websites / applications
- Address customer support needs related to deployed applications

Supplemental Functions:
- Participate in the discussion and analysis of business issues to propose technical / non-technical solutions
- Contribute in team meeting and code review sessions

Requirements:
- 3-5 years’ experience developing ASP.Net applications. (C# 4.0/3.0 preferred) 
- MVC 3.0 and Entity Framework 4.0 experience is a plus.
- 3 years’ experience working with SQL 2008/R2 database and stored procedures
- Ability to work within Agile methodology life-cycle
- Strong problem solving abilities
- Strong communication / team skills
- Self- motivated and ready to take ownership of development tasks / initiatives. 

Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at www.theivantagegroup.com  

Data Warehouse Engineer - Detroit, MI

Position: Data Warehouse Engineer – Location: Detroit, MI – Type: Full time, Direct hire 


iVantage Group is looking for a Data Warehouse Engineer to join our client’s Data Operations team. The Data Warehouse Engineer (DWE) is responsible for the full life cycle of back-end development of the data warehouse.  Responsibilities include the development of ETL processes, dimensional design of the table structure, cube development for performance, and database administration.  The DWE will work closely with the Business Analyst to work through business requirements and develop processes necessary to provide visibility into the data via the centralized data warehouse and reporting platform.  The DWE will also work closely with the front-end developers to ensure data that is being brought in and managed is clean, accurate, available, and complete.  The DWE will help to ensure the data warehouse processes are running optimally.


If you're the type of person that keeps your skills sharp, is constantly reading about new technology and participates in online communities for database administrators then you're the type of person we are looking for.


Responsibilities:
-         Design and support the database and table schemas for new and evolving sources of data being brought into the data warehouse.
-        Create and support the ETL to facilitate bringing data into the data warehouse using SSIS.
-        Create and support the Analysis Services 2008 cubes to help with query performance.
-        Monitor and troubleshoot performance issues on the data warehouse servers.
-        Follow the design principles and best practices defined by the team for data warehousing techniques and architecture.
-      Participate in an on-call rotation.
-      Participate in monthly production code pushes after regular business hours.




Requirements:
-        B.S. degree in Computer Science, Information Technology, or equivalent experience.
-         A passion for relational databases and dimensional modeling.
-         Strong SQL development skills.
-        Understanding of database de-normalization, star schema and snowflake schema.
-         2+ Years development with a relational database (SQL Server, Oracle or similar).
-         Must be a self starter who enjoys solving challenging problems.


Additional Desired Skills:
-         Experience working with the MDX query language.


 Platforms & Tools We Use:
-         Microsoft SQL Server 2008 (T-SQL).
-        Microsoft SQL Server 2008 Analysis Services (MDX).
-         Microsoft Business Intelligence Development Studio.
-         SQL Server Reporting Services.


Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at www.theivantagegroup.com  

Mobile App Developers - Detroit, MI

iVantage Group is currently looking for Mobile App Developers for a tremendous opportunity with a very distinguished client in the Detroit suburbs. This position is a full time, direct placement opportunity.

A Mobile Application Developer works on a project-by-project basis with other engineers, web developers, business and marketing team members to create an intuitive experience for mobile users. This includes creating, extending and improving native mobile applications for iOS, Android, and potentially other mobile platforms, leveraging an internal web service framework, building solutions and maintaining existing applications in a high-energy environment.

Primary Duties and Responsibilities:
 - Build Great Mobile Apps: work with other engineers, developers, architects, QA, system engineers and project managers in solving new and existing technical challenges
-Talk the Talk, Walk the Walk: understand requirements, implement solutions, provide administration tools and documentation for specific projects
- Be There When Needed: perform scheduled on-call duties
- Speak Up: participate in Design and Code Reviews
- Find A Better Way: follow and enhance existing development processes; Measure and verify that new and old code has acceptable performance and scalability
- In It To Win It: you won't just work on these projects, you'll own them.  As a project owner you're going to want to see you're work succeed and last the test of time.
- Get It Done: deliver accurate estimates, provide regular feedback and consistently meet project deadlines
- Help with mentoring other Mobile Software Engineers: teach mobile coding techniques, assist with debugging issues and testing, explain what issues could lurk within high-level designs

Knowledge, Skills, and Abilities:
 - Got An App For That? Applied experience developing iOS apps using Objective-C or Android apps using Java (1 year experience required). Solid understanding of Cocoa/UIKit frameworks, -Xcode/Interface Builder and the iOS SDK or Java, the Android SDK, and Eclipse.  Having applications posted in the AppStore / Android Marketplace is a huge plus. Experience with using version control repositories such as CVS and Git
- Plays Nice With Others: collaborative development experience; Able to explain complex ideas and concepts to non-technical team members; Must enjoy learning process and teaching others
- Unit Testing Makes You Happy: understand how and why unit testing delivers better solutions and speeds up maintenance
- Laser Vision: superb attention to detail
- We'll Figure It Out: must welcome and embrace challenges, focusing on coming up with solutions and options to solve these challenges
- User interface implementation experience recommended
- Related experience in software testing and design desired
- Team-oriented experience highly desired
- Excellent oral and written communication skills regardless of audience

Minimum Education/Experience Requirements:
 - Bachelor's degree in computer science, software development, art and technology, information technology, information systems or equivalent work experience
- Established portfolio of work and/or code samples

Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at www.theivantagegroup.com 

Medical Healthcare System Administrator - Auburn Hills, MI

iVantage Group is currently seeking a talented Medical Healthcare System Administrator for a great client of ours in the Auburn Hills, MI area. This position is a full time, contract opportunity.

Seeking candidates that have worked in a company that does PHYSICAL healthcare, as opposed to mental. Also, looking for candidates with experience working on billing systems. Recommended skills, NextGen and SuccessEHS.

This person will be the primary support person and system administration for all activities for the Physical Healthcare/EHR information system in a clinic.

The person will report to IT staff, but eventually will be working at/for the new entity that will services Physical Healthcare needs of our consumers and the general population of the uninsured starting in Pontiac, MI.


Under the general direction of the Sr. Applications Analyst:

• Become familiar with all aspects of the Healthcare Patient Information System and EHR Application in support of the physical healthcare clinic.
• System administration, implementation, documentation for staff on selected system functions.
• Develop and maintain a process to report and track work related to the support of the OIHN system.
• Develop and coordinate user group meetings.
• Establish vendor performance measures and a method to track and report these measures on an on-going basis.
• Develop methods to train and track the training of OIHN staff on clinical systems.
• Identify and track a methodology for healthcare system development that incorporates the appropriate staff in the process.
• Mange and oversee all processes for moving data in and out of the clinical system/EHR. Examples include:
• Submission of encounters and QI data to other entries as required.
• Downloads to the Warehouse(s).
• Third party revenue reporting and claims management.
• Manage production reporting where appropriate.
• Participate in Operational meetings.
• Where appropriate manage projects plans related to system development.
• Collaborate and coordinate efforts with other locations and IS.

Education:

• Possess a Bachelor's degree from an accredited college or university with a major in Computer Science, Information Systems or a closely related field.
• NOTE: The Bachelor’s degree may be waived with six years of relevant experience in the Physical Healthcare environment.

Experience:

• Have at least two (2) years of full-time work experience in data management and system analysis.
• Two year of system administration of a physical healthcare clinical management system that includes claims management and EHR.

Core Competencies:

• Interacting with others in a way that gives them confidence in one’s intentions and those of the organization; maintaining social, ethical, and organizational norms; firmly adhering to codes of conduct and ethical principles. (Integrity/Building Trust)
• Making customers and their needs a primary focus of one’s actions; developing and sustaining productive customer relationships, recognizing that the ultimate customer is the consumer. (Customer Focus)
• Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge Ensure the control of processes and data management at the CMH provider networks are compliant with CMH protocols
• Manage the development and use of Central System coding and data management structures throughout the CMH network.
• Assist in the implementation of system changes as directed by the Procedure Code Work Group. This includes: participation in
• the PCWG, Coordinating with PCE to make system changes, any training an oversight needed within the provider networks.
• Assist in the extraction, reporting and quality assurance of the data necessary to support the MDCH Performance Indicators.
• Responsible for the completeness and content quality of the various data gathered and used in the Central System.
• and skill on the job and learning through their application. (Continuous Learning)

Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at, www.theivantagegroup.com