This position contributes to Cristek’s success by building data services and analytics solutions which enable business operations and execution. The Lead SQL Data Architect/Developer will build data pipelines, on-premises SQL and Azure data infrastructures which underpin rich business intelligence and analytical capabilities for consumption across multiple aerospace and defense manufacturing environments. This position works collaboratively with IT and business contributors to deliver solutions which propel company strategic advantage through a rich information-on-demand capability.

Responsibilities include:

• Develop and execute multi-year data warehouse and analytical platform architectures and agile projects that deliver tangible business outcomes.
• Lead the architecture, development and operations for local and enterprise database and data warehouse environments for both on-premise SQL Server and Azure data platform environments.
• Translate business requirements into technical requirements ensuring solutions meet intended business needs.
• Provide oversight ensuring data solution architectures and solutions are built within consistent framework.
• Demonstrate deep knowledge and skills as an individual contributor to deliver Cristek’s data engineering capability.
• Support data science/ analytical workloads that transform and leverage local ERP, enterprise, and ad-hoc data sets into data assets.
• Monitor, analyze and optimize database performance and ensure effective and efficient utilization of database systems/processes.
• Perform and lead data validation efforts across the organization and functional subject areas.
• Develop and maintain documentation relating to all assigned systems and projects.
• Work in an agile environment. Develop and drive multiple cross-departmental projects. Establish effective working relationships across disparate departments to deliver business results.
• Participate in multifunctional database projects which may include design, implementation, maintenance of new databases, and configuration management as relating to manufacturing operations in the aerospace and defense industry.
• Develop, maintain, and participate in database backup strategy and disaster recovery plans.

Technical Skills/Expertise Required:

• 3+ years’ experience as a SQL Database Administrator
• 3+ years’ experience supporting SQL Databases for Enterprise Applications
• Thorough understanding of enterprise SQL Server best practices
• Experience executing on basic database engineering (e.g., building tables (OLAP/OLTP, ETL tasks)
• Proven experience assisting in the design, implementation, support, and scaling of SQL Server databases
• Experience in delivering solutions built upon with Azure data technologies e.g., ADLS Gen2, ADF, Databricks,
• Strong understanding of and hand-on development capability for Power BI
• Experience in technically setting up new data lake and data warehouse projects using Azure Data Services
• Knowledge of scripting for automation (e.g., Python, Perl, Ruby)
• Experience with large scale development technologies such as .NET, Java, PHP, etc.

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Information Management or Engineering
• Effective communication and problem-solving skills.
• Practice, evangelize and be an ambassador for agile and DevOps culture.
• Exceptional communication and presentation skills at an enterprise level.
• Solid business acumen and relationship management skills.
• Excellent team player who values the importance of customer service.
• A wide degree of creative and lateral thinking required.
• Azure Administrator and Database technology related certifications, Microsoft SQL Server related certifications and /or Software engineering and IoT development experience a plus

Cristek is fueled by the diversity of our talented employees.  We are an equal opportunity employer and consider and embrace all individuals.  We believe our employees should be happy and healthy, with peace of mind and a sense of fulfillment. We provide our employees with comprehensive benefits, great opportunities for career development, and a balanced lifestyle to achieve personal and professional success. We encourage all qualified individuals to apply for positions that fit their passions.

Hermetic Solution Group's PA&E division is looking for a plater to join the plating team. If you have an interest in plating but don’t have any experience, or you have some but very little experience we encourage you to apply. We train from the ground up for many of our roles, including this plater position.

Employees in this position will perform essential functions of plating to produce highly engineered products principally for the Aerospace, Defense, and Medical markets in a plating line environment.

Primary Responsibilities

• Work cooperatively with all employees.
• Willing to adapt work schedule to company needs.
• Demonstrate the ability to accurately and efficiently use applicable measuring tools such as, but not limited to Calipers and micrometers.
• Demonstrate a basic ability to read and comprehend drawings and other applicable documentation.
• Perform the following plating functions:
  • Proficient usage of microscope.
  • Ability to learn and use applicable area equipment.
  • Must be able to perform basic mathematical calculations.
  • Must have the ability to work in harsh environments.
• Perform other miscellaneous duties as assigned by area Senior I or Senior II.
• Observe safety regulations and follow protective equipment requirements. Report hazardous observations to Management personnel.
• Follow daily clean up and housekeeping procedures. Comply with all quality, safety, and work related rules and regulations.
• These responsibilities will be included in the plating area:
  • Be able to effectively electroplate components to meet drawing and specification standards.
  • Be able to use XRF to take thickness measurements of plated component.
  • Knowledge of applicable military and government plating specifications
  • Must be able to accurately follow instructions.
  • Must be able to rack components per instructions.
  • Must be able to demonstrate effective rinsing techniques, including using various hydro-washing methods and achieving water break free surfaces.
  • Must be able to set amperage and voltage on rectifiers.
  • Must be able to complete certification forms properly.

Qualifications

• Good hand / eye coordination (fine motor skills, dexterity).
• Able to work with a Microscope for extended periods of time.
• Read, write, speak and comprehend the English language.
• Basic computer skills.
• Able to sit and or stand for an extended periods of time.
• Willing to work with hazardous chemicals.
• Consistently notifies supervisor or designated personnel when tasks are completed.
• Must be able to follow basic instructions.
• Must be able to retain information.
• Must have legible handwriting.
• Dependability: Follows instructions, responds to management direction.
• Some knowledge of geometrical dimension and tolerancing.
• Basic print reading skills.
• Seek out duties to ensure you are consistently productive.
• Identify process improvements.

Desired:

• Initiative: Seeks increased responsibility, looks for and takes advantage of opportunities.
• Asks for help when needed.

Education/Previous Experience Requirements

• High School graduate or General Education Degree
• Zero to 1 year related experience

Hermetic Solution Group's PA&E division is looking for a QC Inspector. An employee in this role will need to perform final inspections of products to verify conformance with internal quality standards and customer requirements.

If you are interested in this position, please apply by sending your resume to Careers@pacaero.com and putting “QC Inspector” in the subject line.

Primary Responsibilities

• Work cooperatively with all employees.
• Willing to adapt work schedule to company needs.
• Attendance / Punctuality: Is consistently at work and on time.
• Demonstrate the ability to accurately and efficiently use applicable measuring tools such as, but not limited to Calipers, Micrometers and Height Gage.
• Demonstrate a basic ability to read and comprehend drawings and applicable inspection documentation.
• Initiate Non Conformance Reports as required.
• Perform product identification and traceability activities as required (Material and Process certification retrieval).
• Review shipping paperwork for completeness and accuracy.
• Perform other miscellaneous duties as assigned by area Lead
• Observe safety regulations and follow protective equipment requirements. Report hazardous observations to Management personnel.
• Follow daily clean up and housekeeping procedures. Comply with all quality, safety, and work related rules and regulations.

Qualifications

The requirements listed below are representative of the knowledge, skill and / or ability required.

• Good hand / eye coordination (fine motor skills, dexterity).
• Specific vision ability to have natural or corrected near distance acuity in at least one eye capable of passing the Jaeger Number 2 test and a color vision test..
• Able to work with a microscope for extended periods of time.
• Read, write, speak and comprehend the English language.
• Basic computer skills.
• Able to sit and or stand for an extended periods of time.
• Basic math skills.
• Willing to work with hazardous chemicals.
• Seeks out duties to ensure you are consistently productive.
• Consistently meets company minimum labor efficiency rates.

Education & Experience Required

• High School Graduate.
• 0 to 1 year of experience, training or equivalent combination of education and experience.

Preferred:

• 1+ years of experience and training.
• Legible handwriting.
• Ability to follow basic instructions with some multi-tasking skills.
• Dependability: Follows instructions, responds to management direction; takes responsibility for one’s own actions.
• Initiative: seeks increased responsibility, looks for and takes advantage of opportunities, asks for and offers help when needed.

HSG's PA&E Division in Wenatchee, WA is looking for a laser weld production employee who will manufacture highly engineered products principally for the aerospace, defense, and medical markets—with lasers!

If you are interested in applying, please  email your resume at Careers@PacAero.com with “Laser Weld” in the subject line.

Primary Responsibilities:

• Work cooperatively with all employees
• Willing to adapt work schedule to company needs
• Attendance / Punctuality: Is consistently at work and on time
• Demonstrate the ability to accurately and efficiently use applicable measuring tools such as, but not limited to Calipers, Micrometers and Height Gage
• Demonstrate a basic ability to read and comprehend drawings and other applicable documentation
• Follow daily clean up and housekeeping procedures
• Comply with all quality, safety, and work related rules and regulations
• Pre-Weld Assembly
  • Ground spring installation
  • Staking & Press-fitting connectors
  • Verifying proper orientation per print
• Laser Weld
  • Operation of laser weld machines
  • Loading correct programs
  • How to read applicable job instructions
  • Properly identifying and assembling necessary tooling
  • RE-verifying proper orientation per print
  • Basic troubleshooting skills
• Wash
  • The ability to identify contaminants
  • The ability to remove and replace solvents as required
  • The ability to perform beginning level procedures
• Post-Weld Assembly
  • Installation of hardware including Heli-coils, shrouds, jack screws, etc.
  • Manual removal of weld spatter
  • Conversion coat touch-up

Qualifications:

• Good hand / eye coordination (fine motor skills, dexterity)
• Able to work with a microscope for extended periods of time
• Read, write, speak, and comprehend the English language
• Basic computer skills
• Able to sit and or stand for an extended periods of time
• Consistently strives to meet company minimum labor efficiency rates
• Must be able to follow basic instructions
• Takes responsibility for own actions
• Some knowledge of geometrical dimension and tolerancing
• Basic print reading skills
• Ability to access training records
• Seek out duties to ensure you are consistently productive
• Identify process improvements

Desired:

• Initiative: Seek increased responsibility, look for and take advantage of opportunities
• Ask for help when needed

Hermetic Solution Group's PA&E division is looking for an Chemical Technician. If you  would like to apply, please need to email your resume to Careers@PacAero.com with “Chem. Tech.” in the subject line.

Employees in this position will actively contribute to the implementation and improvement of the plating operations by utilizing ones skills, experience, and competencies developed in the company. A technician will also assist the Chemistry Supervisor as a point person for daily tasks and mentoring co-workers.

Primary Responsibilities

• Demonstrate a basic ability to read and comprehend drawings and other applicable documentation.
• Perform the following chemistry lab functions:
  • Proficient usage of microscope, UV-VIS, FTIR, and AAS.
  • Proficient with Microsoft Office software, including Microsoft Word and Excel.
  • Ability to learn and use applicable area equipment.
  • Must possess good math and observation skills.
  • Must have the ability to work in harsh environments.
• Perform other miscellaneous duties as assigned by area Supervisor.
• Observe safety regulations and follow protective equipment requirements. Report hazardous observations to Management personnel.
• These responsibilities will be included in the chemistry lab area:
  • Must be able to accurately follow instructions.
  • Must be able to perform basic chemical titrations.
  • Must be able to perform chemical additions and make up new solutions per instructions.
  • Must be able to perform the basic functions of a pH meter.
  • Must have good knowledge of all process solution functions.
  • Must be able to show competence in XRF usage and function.

 Essential 

• Willing to work with hazardous chemicals.
• Consistently notifies Chemistry Supervisor or designated personnel when tasks are completed.
• Must be able to follow basic instructions.
• Must be able to retain information
• Must have legible handwriting.
• Takes responsibility for own actions.
• Identify process improvements.
• Requires minimal supervision to perform everyday tasks.
• Demonstrates strong independent thinking with problem solving skills.
• Must be able to navigate through applicable MRP system.
• Support company/management decisions.
• Offers help when needed.
• Maintain and report inventory levels of materials.
• Initiative: Seeks increased responsibility, looks for and takes advantage of opportunities.

Education/Previous Experience Requirements

• High school graduate
• Prefer college degree in science, technology, engineering or medical related field with completion of at least five semesters of college level chemistry with 1-2 semesters of analytical chemistry and/or 1-2 years work experience in a laboratory environment

Hermetic Solution Group's PA&E Dhas multiple open production positions on day shift and night shift! A production role at PA&E includes on-the-job-training in the highly skilled field of electronics assembly. Parts that we make are hermetically sealed electronic components that go everywhere around the world, from outer space to the human body!

If you have attention to detail and organizational skills, and you are looking for a new and exciting career in electronics manufacturing, look no further!

Starting wage is $14/hour and night shift roles include a $2/hour shift differential.

An employee in this role must:

• Have a high school diploma or a General Equivalency Degree
• Be interested in a Day shift role (M-F 6:00am to 2:30pm) or a Night shift role (M-F 2:30pm to 11:00pm)
• Have good hand/eye coordination and be willing to learn to work with a microscope for extended periods of time
• Read, write, speak, and comprehend the English language
• Be able to follow instructions, retain information, and have legible handwriting
• Be willing to work with hazardous chemicals after learning proper safety procedures and while wearing PPE
• Be a self-starter and seek out additional duties
• Be punctual and strive for perfect attendance

Benefits for regular, full-time employees include:

• Medical, Dental, Vision, and Voluntary Life Insurance available (eligibility period applies)
• Paid Time Off accruals that increase with your service years
• 10 Paid Holidays a year
• 401(k) with company matching (eligibility period applies)
• Employee Assistance Program
• Company Paid Life Insurance, AD&D Insurance, STD & LTD Insurance
• Corporate Gym Memberships with The Wrac & WORx Gyms
• Tuition Reimbursements

Hermetic Solution Group's PA&E division's machine shop is looking for an in-process inspector to work in the deburr department.

If you are interested and meet the following requirements then we encourage you to apply! To apply, you will need to email your resume to Careers@PacAero.com with “Deburr Inspector” in the subject line.

Primary Responsibilities:

• Work cooperatively with all employees.
• Willing to adapt work schedule to company needs.
• Attendance / Punctuality: Is consistently at work and on time.
• Demonstrate the ability to accurately and efficiently use applicable measuring tools such as, but not limited to Calipers, Micrometers and Height Gage.
• Demonstrate a basic ability to read and comprehend drawings and applicable inspection documentation.
• Perform other miscellaneous duties as assigned by area Lead
• Observe safety regulations and follow protective equipment requirements. Report hazardous observations to Management personnel.
• Follow daily clean up and housekeeping procedures. Comply with all quality, safety, and work related rules and regulations.

Qualifications:

The requirements listed below are representative of the knowledge, skill and / or ability required.

• Good hand / eye coordination (fine motor skills, dexterity).
• Able to work with a Microscope for extended periods of time.
• Read, write, speak and comprehend the English language.
• Basic computer skills.
• Able to sit and or stand for an extended periods of time.
• Basic math skills.
• Seeks out duties to ensure you are consistently productive.
• Consistently meets company minimum labor efficiency rates.

Education & Experience Required:

• High School Graduate.
• 0 to 1 year of experience, training or equivalent combination of education and experience.

Preferred:

• Legible handwriting.
• Ability to follow basic instructions with some multi-tasking skills.
• Dependability: Follows instructions, responds to management direction; takes responsibility for one’s own actions.
• Initiative: seeks increased responsibility, looks for and takes advantage of opportunities, asks for and offers help when needed.

Hermetic Solutions Group's PA&E Division, located in Wenatchee, Washington has an immediate need for intermediate and senior level Machinists. This position requires the employee to be knowledgeable and experienced in all areas of CNC machine tool use including the set up and operation of horizontal and vertical mills or turning centers.

Please note: you must be willing to work any shift based on the needs of our business.

Experience/Qualifications

• 5 years of machining experience
• Possesses positive attitude and a collaborative work style
• Excellent blueprint reading skills including GD&T
• Aptitude for creative problem solving
• Ability to communicate effectively and work cooperatively with all employees
• Exceptional attention to detail with the ability to work with a microscope the majority of the day
• Ability to recognize, evaluate and respond to problems during the machining process
• Willing to adapt work schedule to the company needs
• Good written, verbal and interpersonal communication skills with sound decision making ability with little or no support
• Due to ITAR regulations, you must be able to show proof of US Citizenship upon hire.

If you are interested in this position, please send your resume in an e-mail – with the job title in the subject line to Careers@PacAero.com.

Hermetic Solution Group's PA&E division is looking for a Maintenance JR. An employee in this role will need to repair and maintain machinery and mechanical equipment such as engines, motors, pneumatic tools, conveyor systems as well as production machines and equipment.

If you are interested in this position, please apply by sending your resume to Careers@pacaero.com and putting “Maintenance” in the subject line.

Duties and Responsibilities
• Observes mechanical devices in operation and listens to their sounds to locate causes of trouble.
• Dismantles devices to gain access to and remove defective parts. Examines form and texture of parts to detect imperfections.
• Repairs or replaces defective parts.
• Test electronic components and circuits to locate defects.
• Aligns, adjusts and calibrates equipment according to specifications.
• Installs special functional and structural parts in devices. Lubricates and cleans parts.
• Starts devices to test their performance. Initiates requisition for parts and machines. Repairs electrical equipment.
• Learns to read and understand electrical schematics.
• Inspects used parts to determine changes in dimensional requirements. Adjusts functional parts of devices and control instruments.

Education and Experience
High School diploma or equivalent. No minimum experience required, but some knowledge of facility and equipment maintenance preferred. Preference will be given to candidates with CNC maintenance experience.

Hermetic Solution Group's PA&E division is looking for a QC Inspector JR to work as an in-process plating inspector. An employee in this role will perform Plating inspections of products to verify conformance with internal quality standards and customer requirements.

If you are interested in this position, please apply by sending your resume to Careers@pacaero.com and putting “QC Inspector Plating” in the subject line.

Primary Responsibilities
• Work cooperatively with all employees.
• Willing to adapt work schedule to company needs.
• Attendance / Punctuality: Is consistently at work and on time.
• Demonstrate the ability to accurately and efficiently use applicable measuring tools such as, but not limited to Calipers, Micrometers and Height Gage.
• Demonstrate a basic ability to read and comprehend drawings and applicable inspection documentation
• Initiate Non Conformance Reports as required.
• Perform other miscellaneous duties as assigned by area Lead
• Observe safety regulations and follow protective equipment requirements. Report hazardous observations to Management personnel.
• Follow daily clean up and housekeeping procedures. Comply with all quality, safety, and work related rules and regulations.

Qualifications

Essential:

• Good hand / eye coordination (fine motor skills, dexterity).
• Specific vision ability to have natural or corrected near distance acuity in at least one eye.
• Able to work with a Microscope for extended periods of time.
• Read, write, speak and comprehend the English language.
• Basic computer skills.
• Able to sit and or stand for an extended periods of time.
• Basic math skills.
• Willing to work with hazardous chemicals.
• Seeks out duties to ensure you are consistently productive.
• Consistently meets company minimum labor efficiency rates.

Education/Previous Experience Requirements
• High School graduate
• 0 to 1 year related experience, training or equivalent combination of education and experience.

Job Summary

Under guidance of the Engineering Manager, or other senior staff members, use process control, corrective and preventative action, and drafting techniques using SolidWorks to design products, components and assemblies for the hybrid electronics package industry. This position is located at Hermetic Solutions Group's Sinclair Manufacturing facility in Chartley, MA.

Primary Responsibilities

• Design conceptual, prototype and production components to meet customer requirements.
• Evaluate part design to verify form, fit, and function using tolerance analysis.
• Assist in identifying risk areas and potential product design issues.
• Work with other departments to design prototype and production parts and tooling.
• Identify and create Bills of Materials (BOM).
• Process Engineering Change Requests (ECR).
  Review, evaluate and estimate the engineering design effort for sales quotes and customer
• submitted engineering changes.
• Assist in establishing test plans to demonstrate that design meets performance requirements.
• Manage design control processes and documentation required for assigned projects.
• Make process improvements focused on specific product lines and apply them across others.

Qualifications

• Knowledge of Geometric Dimensioning & Tolerancing (GTOL) requirements.
  Proven history – 6 months of continuous design - of CAD drafting and design of components and assemblies using 3D software. SolidWorks (currently at site), AutoCAD Inventor, or Creo experience is a plus.
• Ability to define problems, collect data, establish facts, and draw valid conclusions.
• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form.
• Identify and resolve problems in a timely manner.
• Gather and analyze information to produce product; develop alternative solutions when needed.
• Work well in group problem solving situations.
• Exhibit sound and accurate judgment and be able to explain the reasons for them.
• Communicate changes and progress in a professional manner.
• Complete projects in time allowed and in allowed budget.
• Ability to read and comprehend instructions, short correspondence, and memos.
• Ability to write correspondence.
• Write clearly and informatively. Edit work for spelling and grammar. Vary writing style to meet audience needs. Present numerical data effectively.
• Ability to effectively present information to individuals or in group situations to company personnel, customers, and auditors.
• Speak clearly and persuasively in positive and negative situations. Ability to listen attentively and ask for clarification as necessary.

Education/Previous Experience Requirements

Associate’s degree (A.A.) or beyond from a college or technical school. Curriculum must have an emphasis on mechanical and electrical component design, concepts, and practices. Materials (glass) science a plus.