Macula Group

Executive / Sales Assistant

Status: Closed

Position Summary:

The ideal candidate will be experienced in handling a wide range of administrative/executive/sales support related tasks and will be able to work independently as well as with heavy supervision. This person must be exceedingly well organized, flexible and enjoy the administrative challenges of supporting a small office of diverse people and programs.

They will also have the ability to interact with staff (at all levels) in a fast paced environment, sometimes under pressure, remaining flexible, proactive, resourceful and efficient, with a high level of professionalism and confidentiality is crucial to this role. Expert level written and verbal communication skills, strong decision making ability and attention to detail are equally important.

Must Have:

• Excellent calendar management skills, including the coordination of complex executive meetings.
• Experience assisting management with the creation of PowerPoint presentations.
• Strong knowledge of MS Office, including Word, Excel, PowerPoint and Outlook.
• Experience with and willingness to cold call appointment set.
• Willingness to network through local events, chambers of commerce, etc….
• Tremendously optimistic and positive approach to work and life.

Strongly Prefer:

• Support experience in a professional services, sales or marketing environment.
• Experience successfully creating and/or modifying processes.
• Bachelor’s degree.

The Candidate Will:

• Calendar manage, requiring interaction with both internal and external executives and assistants, as well as consultants, to coordinate a variety of executive meetings.
• Answer phones and direct all incoming calls to appropriate party promptly and efficiently.
• Communicate and handle incoming and outgoing electronic communications on behalf of the Partners.
• Assist Partners with preparation of presentation materials.
• Assist in pipeline/forecast preparation and management.
• Prioritize and manage multiple projects simultaneously, and follow through on issues in a timely manner.
• Arrange travel schedule and reservations for executive management as needed.
• Work closely with the Partners to coordinate and launch hard copy or email campaigns to consultants, clients and potential clients.

Location:

Lemoyne, Pennsylvania

Length:

Permanent

Compensation:

$35,000 – $45,000

Click here to apply.

Data Warehouse Developer

Status: Closed

Position Summary:

We are looking for a Data Warehouse Informatica Developer to join our team in Mechanicsburg, PA.
The position requires a minimum of 3 years experience in the following:

• ETL architect in designing, implementing and maintain enterprise level data warehouse solutions using the Informatica ETL toolset.
• Designing, implementing and maintaining Oracle data warehouses and a data warehouse application and data base architect.
• Oracle’s SQL and PL/SQL programming, UNIX shell scripting in a multi-server environment, secure FTP and SCP programming, server to server interfaces using SSJ protocol, and performing migrations, upgrades of Informatica or comparable software and objects.
• Logical and physical data warehouse modeler, using Erwin, Oracle Designer, or some other modeling tool.

Modeling techniques include star/snowflake schema design, dimensional modeling, federated query design, data mart design, and re-design efforts in support of an enterprise data warehouse solution.
A thorough knowledge of relational data base management systems (RDBMS), data warehouse design methodologies, performance turning and monitoring, space utilization, sizing requirement and date integrity is required. An understanding of On-line Analytical Processing (OLAP) is also needed.

BENEFITS: Full benefits, including dental, medical, life insurance, matching IRA, paid vacations and holiday and more.

REQUIRED: US Citizenship

Location:

Mechanicsburg, Pennsylvania

Length:

Permanent

Compensation:

$85,000 – $100,000

Click here to apply.

Programmer

Status: Closed

Position Summary:

The primary responsibility of a Programmer I is to develop and maintain information technology solutions to support the business team by using industry and company best-practices for new and existing applications including .Net, VB6, Client/Server, and Internet applications.

Responsibilities:

• Under the direction of the Senior Programmer, utilizes VB, C#, ASP, HTML, Java Script, CSS, MS Access, Crystal reports and other 3rd party tools to create and or Modify reporting functions for all systems.
• Provides daily operational and miscellaneous application support including software installs, problem research, issues with routine functions and processes.
• Creates or enhances programs to automate manual processes.
• Generates ad-hoc reports as needed.
• Works with Senior Programmers on larger more complex projects/problems.

Qualifications:

• BS Degree in MIS or Computer Science with 1-2 years experience preferred. Eight years of programmer related experience can replace the Bachelor’s degree requirement.
• Understanding of System Development Life Cycle Methodologies preferred.
• Experience with relational databases (SQL preferred) and MS Access.
• Experience with report writers (Crystal Reports).
• Strong organizational and communication skills.
• General familiarity with PC hardware and networking concepts.
• Experience in .Net (VB, C#, ASP).
• Experience with SharePoint, Flash, mobile platforms and web service development preferred.
• Ability to independently acquire news skills as needed.

Location:

Lancaster, Pennsylvania

Length:

Permanent

Compensation:

$46,000 – $56,000

Click here to apply.

Analytics Team Lead

Status: Closed

Position Summary:

As the analytics team lead, the applicant will be responsible for leading the work of a small team of 1 to 2 individuals. The responsibilities of this team include extracting data from multiple source systems using SQL and other tools, analyzing data to help clients better use and understand their business and creating complex reports and score cards to present information in meaningful and insightful ways. The candidate will also be called on to create Adhoc documents and presentations that will be used to convey important metrics and decision points to our clients using both written and visual (Charts and Graphs) representations of data. The ideal candidate will possess exceptional analytical and problem solving skills and will have both the ability and desire to solve new and complex problems.

Required Skills:

• Undergraduate degree.
• Superior analytical and problem-solving skills.
• Strong verbal and written communication skills.
• A background in technology and computer systems.
• An understanding of relational databases.
• Experience developing SQL queries.
• Experience using MS Office Products especially Access, Excel and PowerPoint.
• Implement and enforce the use of improvement processes and tools to improve sales performance.
• An understanding of Healthcare concepts, specifically in the public sector.
• An understand of the concepts used to design a business report.

Preferred Skills:

• Previous experience as a team lead.
• Experience using data and statistical analysis software.
• An understanding of System Development Life Cycle (SDLC).
• Experience in using Cognos Cubes, Reports and Report Studio.
• An understanding of the workings of PA state and local government.

Location:

Harrisburg, Pennsylvania

Length:

1 Year +

Compensation:

$35/hr

Click here to apply.