Excel Group By Column Value Formula Jobs in Usa
20,420 positions found — Page 4
Health system in Wyoming is seeking an experienced ENT provider to join its hospital-employed group.
The incoming physician will be comfortable in a solo setting along with another part time provider and enjoy living in a rugged WY environment.
Enjoy mountain views and no state income tax in an area with no shortage of outdoor recreation.
Signing Bonus available, contact us for details. Relocation Bonus available. CME time and money available. Good referral base of local PCPs. MGMA-median comp + wRVU production incentive.
This established private practice in the northeast Atlanta suburbs is searching for the right Family or Internal Medicine physician to join their group.
They have a very successful practice in aesthetics, women's health, functional medicine, hormone therapy, traditional Primary Care and Geriatric outreach.
You'll have the opportunity to build the practice you want, in one of these areas of medicine, or in combination with your own skill set and interests.Competitive salary based on experience. Reasonable patient census of 12-20 per day depenmding on type of visit. Comprehensive and Generous Benefits Package. Monday-Friday schedule with very light phone call. The ideal candidate will be Board Certified, have two or more years experience, but they will consider a very strong, less experienced candidate.
Are you ready for the next step in your property management career? Would you like to work for an organization with a national presence and strong company culture? This group offers professional development, supports employee volunteering, and fosters a strong sense of community. This Property Manager will be responsible for managing operations for a Class A office building including maintenance, property appearance, accounting, lease administration, construction and customer service.
Duties Include:
- Oversee vendor service agreements—including specifications and performance—to ensure high‐quality delivery of janitorial, security, landscaping, and other operational services. Regularly obtain competitive bids to validate service quality and cost efficiency, and confirm all vendors meet ownership requirements.
- In partnership with the Chief Engineer, guide the implementation and management of fire and life‐safety systems, preventative maintenance programs, environmental initiatives, and energy‐management strategies.
- Deliver exceptional Class A service to tenants, while driving ongoing projects that enhance customer relationships, elevate the retail experience, and strengthen overall property image.
- Coordinate tenant move‐ins and move‐outs, collaborating with the construction coordinator on space‐related needs when necessary, while independently managing smaller customer space adjustments.
- Stay informed on evolving safety and environmental regulations, including HVAC requirements and indoor air‐quality standards.
- Actively participate in industry organizations and events (IREM/BOMA/BATMA) to remain current on issues affecting regional markets and the broader real‐estate industry.
- Review leases for compliance, tracking escalations and monthly billing, monitoring renewals and expirations, managing fees and notification requirements, and incorporating updates from new amendments.
- Manage the monthly financial reporting process in Yardi, ensuring accuracy and timely delivery of all financial information to management.
- Prepare annual operating budgets for assigned properties, along with producing year‐end tenant
- Monitor utility consumption and oversee the preparation of customer and retailer sub‐metering reports as well as related bill backs rent letters and completing DOE, CAM bill backs, and other reconciliation adjustments.
- Conduct thorough reviews of operating financial statements, property status updates, and capital and tenant improvement reports to identify variances and recommend strategies that strengthen project cash flow and net operating income.
- Manage the monthly financial reporting process in Yardi, ensuring accuracy and timely delivery of all financial information to management.
Requirements:
Seeking a minimum of 5 years' experience commercial property management, Class A office preferred
Bachelor's Degree Preferred
Advanced Microsoft Office skills
Come join our growing MFM practice for an opportunity to work in a collaborative, stimulating office environment, offering didactic-style learning with academically interesting, complex cases. Large, stable practice supported by Pediatrix & Obstetrix, a nationwide company.
Responsibilities
This position has a one-time $5,000.00 sign-on bonus!
The Sonographer provides diagnostic ultrasound tests for patients in the Maternal Fetal Medicine setting. The Sonographer works independently and with other members of the healthcare team to provide comprehensive care to pregnant women.
- Explains exam to patient and family prior to the commencement of the test to assure cooperation and optimum test results.
- Prepares patients for ultrasound examination and performs required Fetal Echo scans.
- Acquires anatomical, pathological, and/or physiological data.
- Records/processes sonographic data and other pertinent observations made during the procedure.
- Creates a preliminary report for physician interpretation and review/signature.
- Assists physician during invasive procedures such as amniocentesis and chorionic villus sampling.
- Recognizes equipment malfunctions and takes appropriate corrective action.
- Responsible for maintaining adequate inventory of ultrasound supplies.
- Follows the accredited laboratory protocols for obtaining two-dimensional images, color flow, Doppler, and m-mode where applicable.
- Rotates as needed to cover Sonographer absences.
- Performs related and other assigned duties as directed.
Qualifications
Education:
- Graduate of an accredited sonography program with a degree in ultrasonography or equivalent.
- Maintain or be eligible for certification as an American Registered Diagnostic Medical Sonographer (ARDMS) in OB/GYN.
- Must provide evidence of continuing education credits to fulfill accreditation requirements.
- CPR certification required.
- Fetal echo certification required.
Experience
- Minimum six months experience as an ultrasound technician working in OB/GYN and/or MFM setting preferred.
Experience Industry: Healthcare
Skills/Abilities:
- Skilled in operating ultrasound equipment.
- Ability to react calmly and effectively in emergency situations.
Benefits and Compensation
Take great care of the patient, every day and every way.TM At Pediatrix & Obstetrix, that's not only our motto at work each day; it's also how we view our employees and their families. We know that our greatest asset is YOU.
We take pride in offering comprehensive benefits in a vast array of plans that fit your life and lifestyle, supporting your health and overall well-being. Benefits offered include, but are not limited to: Medical, Dental, Vision, Life, Disability, Healthcare FSA, Dependent Care FSA and HSAs, as well as a 401k plan and Employee Stock Purchase Program. Some benefits are provided at no cost, while others require a cost share between employees and the company. Employees may also select voluntary plans and pay for these benefits through convenient payroll deductions. Our benefit programs are just one of the many ways Pediatrix & Obstetrix helps our employees take care of themselves and their families.
The expected pay for the position ranges from $40.82 - $78.94 per hour. The actual pay range will be computed based on years of relevant experience.
This job posting will remain open, and we will continue to accept applications until an offer has been extended and accepted.
About Us
Pediatrix Medical Group is one of the nation's leading providers of highly specialized health care for women, babies and children. Since 1979, Pediatrix has grown from a single neonatology practice to a national, multispecialty medical group. Pediatrix-affiliated clinicians are committed to providing coordinated, compassionate and clinically excellent services to women, babies and children across the continuum of care, both in hospital settings and office-based practices. The group's high-quality, evidence-based care is bolstered by significant investments in research, education, quality-improvement and safety initiatives.
Please Note: Fraudulent job postings/job scams are becoming increasingly common. All genuine Pediatrix job postings can be found through the Pediatrix Careers site: PedSon
Pediatrix is an Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.
Gastroenterologist needed in Northern Indiana.
Nestled an easy drive to either Chicago, Detroit, or Indianapolis, you will have no shortage of ways to enjoy your time outside of the practice.
You'll join a group whose aim is provide boutique executive medicine and women's wellness to more than 1.2 million residents.
Backed by a national leader in healthcare, CME, medical education debt assistance, relocation, and more may be offered in a robust compensation package.
Don't hesitate, apply today.Multi Specialty Group Employee, Traditional. Loan Forgiveness available. Residency/Fellowship Stipend available. Relocation Bonus available. CME time and money available. Retirement plan provided.
Company Description
Summit Funding Group, Inc., established in 1993, specializes in delivering creative and flexible equipment lease and finance solutions to businesses across various industries in the U.S. With over $6.5 billion in originations and more than $1.3 billion in assets under management, Summit Funding Group has become a leading equipment finance provider. The company operates through its Corporate Leasing and Vendor Finance divisions, emphasizing strong partnerships and customized financial solutions that drive business growth and operational success. At Summit Funding Group, integrity, client-focused service, and tailored financing options are integral to helping companies achieve their goals.
Essential Functions/Responsibilities
- Draft, review, and negotiate financing documents and a wide array of legal contracts
- Foster collaborative relationships with sales, business folks, and management
- Assist in implementing company’s business initiatives, strategic plans, and special projects
- Provide guidance to the company in legal, collections, Human Resources and compliance issues
- Manage lease contract enforcement, including bankruptcy and other recovery efforts
- Research, review and advise the General Counsel and senior management on legal matters such as the UCC, titling issues, and related equipment finance law
Must Have:
- J.D. from accredited law school
- 2-4 years’ relevant firm or in-house experience
- Positive approach to the practice of law, a quick learner, and commitment to exceptional work product
- Outstanding verbal and written communication skills
- Dedication to the details, yet creative and flexible
- Relationship-driven, eager to work cooperatively with business partners and colleagues
Experience in equipment finance, although not required, is a strong plus!
Physical Requirements
- Occasionally lifts and carries up to 10 lbs.
- Frequently sits, stands and walks.
Compliance Statement
- The associate is responsible for meeting all compliance requirements imposed on First Financial Bank by State and Federal law and regulation, as well as all related First Financial Bank policies and procedures. This includes all Bank Secrecy Act, Anti-Money Laundering, OFAC and Suspicious Activity reporting requirements, as well as all other lending and deposit compliance requirements.
About the Job
Redwood Electric Group is seeking a proactive and detail-oriented Administrative Assistant to support our on-site Project Management and Field teams. This role is essential to keeping project operations running smoothly and efficiently, requiring strong organizational skills, financial awareness, and the ability to communicate effectively across teams.
About Us
Redwood Electric Group provides electrical construction and design services across the Greater Bay Area and Northern Nevada, with offices in Santa Clara, San Leandro, Vacaville, Sacramento, and Reno. Our success is rooted in our commitment to customer satisfaction, innovation, and a team dedicated to exceeding expectations.
Duties/Responsibilities
- Provide administrative support to ensure efficient office operations, including answering phone calls, scheduling meetings, and supporting visitors.
- Perform general administrative tasks such as filing, typing, copying, scanning, and making travel arrangements for senior staff.
- Assist with the preparation and submission of project proposals and bids.
- Facilitate the project process from setup to closeout by organizing initial documentation, coordinating necessary approvals, tracking project milestones, maintaining project documentation, managing transmittals and submittals, creating O&M manuals, drafting warranty letters, and preparing closeout documents.
- Manage insurance certificates and bonds, including bid, payment, and performance bonds.
- Handle contracts and change orders, ensure approvals, and provide copies to accounting.
- Oversee the Potential Change Order (PCO) process within ProjectSight, ensuring accurate reconciliation of the PCO log with the accounting software.
- Support special projects and organize occasional job-site or office meetings, lunches, and breakfasts.
- Copy, scan, and order drawings for projects as requested.
Required Skills/Abilities
- Proficiency in computer software, including Microsoft Office Suite (Word, Excel, Outlook, PowerPoint), Adobe Acrobat, and Bluebeam.
- Strong organizational and priority management skills.
- Excellent interpersonal, verbal, and written communication skills.
- Strong administrative writing and reporting skills.
- Competence in managing processes and analyzing information.
- Ability to solve problems efficiently and effectively.
- High level of professionalism and integrity.
Education and Experience
- High school diploma or GED required.
- Minimum of 3 years of administrative assistant experience, preferably in the construction industry.
Working Conditions
- This position is based in our Redwood City office and is not eligible for remote work.
- Work may be performed in an office or on active job sites, depending on role and project needs.
- Office work includes sitting, typing, and using a computer for extended periods.
- Noise levels range from quiet (office) to high (job sites).
- May require occasional travel to project locations or meetings.
- REG will provide reasonable accommodations as required by the ADA and applicable state law.
Disclaimer
The duties and responsibilities listed above are representative of the work typically performed in this role, but are not intended to be a comprehensive list. Actual responsibilities may vary depending on department needs, project scope, or business requirements. Employees may be assigned additional tasks as needed to support company goals and operations.
This Southern Illinois site needs an outpatient Family Medicine provider in a wonderful family friendly area.
This location is just 1.5 hours from St.
Louis and just 2 hours from Indianapolis, so you can enjoy major metro attractions.
The organization is offering an excellent compensation and benefits package with full benefits, sign on, relocation, four weeks' vacation, paid holidaysm and retirement.
Hospital Employee, Outpatient only. M-F, no weekends. Quality Bonus production incentives. Signing Bonus available, contact us for details. Relocation Bonus available. CME time and money available. Up to 4 weeks of PTO available.
Just 15 minutes from downtown Louisville we have a rare, 100% outpatient Gastroenterology opportunity.
This is an incredible chance for someone to have the best work/life balance possible, while providing excellent earnings and access to a metro area of over 1 million people.$600,000 base plus incentives. Partnership in the practice and ownership in the surgery center are available. Fully employed with excellent benefits including a 401K, a cash balance plan to allow for greater savings, health insurance, and much more. The practice will be further expanding its surgery center soon ensuring the best possible environment for you and your patients. The Louisville metro area has a shortage of Gastroenterology physicians, ensuing you will be busy right away with the opportunity to grow your practice. ERCP proficiency is a welcome skill but not required.
Just 15 minutes from downtown Louisville we have a rare, 100% outpatient Gastroenterology opportunity.
This is an incredible chance for someone to have the best work/life balance possible, while providing excellent earnings and access to a metro area of over 1 million people.$600,000 base plus incentives.
Partnership in the practice and ownership in the surgery center are available.
Fully employed with excellent benefits including a 401K, a cash balance plan to allow for greater savings, health insurance, and much more.
The practice will be further expanding its surgery center soon ensuring the best possible environment for you and your patients.
The Louisville metro area has a shortage of Gastroenterology physicians, ensuing you will be busy right away with the opportunity to grow your practice.
ERCP proficiency is a welcome skill but not required.
