Excel Group By Column Value And Sum Jobs in Usa

At Allegion, we help keep the people you know and love safe and secure where they live, work and visit. With more than 30 brands, 12,000+ employees globally and products sold in 130 countries, we specialize in security around the doorway and beyond. Additionally, in 2024 we were awarded the Gallup Exceptional Workplace Award, which recognizes the most engaged workplace cultures in the world.

Under the direction of the Operational Excellence Manager, this position is responsible for supporting the lean transformation and daily management initiatives by ensuring strategies are implemented and principles/practices/tools are incorporated in the culture and processes under transformation. This position implements and supports actions that bring about improvements which may include, but are not limited to safety, customer value proposition, quality, delivery, cycle, growth, margin expansion, and inventory.

Qualified candidates must be legally authorized to be employed in the United States. The company does not intend to provide sponsorship for employment visa status (e.g., H-1B, TN, etc.) for this employment position.

Support the Operational Excellence Manager and Value Stream in implementing lean transformation and daily management across the value stream including:

• Gathers data for key performance indicators for functions being reviewed, evaluates current state, and proposes future state goals and objectives.
• Implementing tactical strategies to achieve the desired vision
• Executing against long and short-term objectives to support the value stream's goals
• Working with necessary site personnel to identify, address, and eliminate process related obstacles
• Assisting in the change of systems/processes as required in support of the Lean initiatives
• Utilize value stream mapping techniques to design optimal information, material, and production flow methods

To act as a change agent to bring about improvements in the manufacturing process through the active support, participation and leadership of rapid improvement events or projects, that includes:

• Owning pre and post standard work.
• Lead or facilitate continuous improvement projects and events.
• Participating in Gemba walks and coaching employees on continuous improvement, standard work. development/modification/adherence, flow, takt time attainment, and problem-solving abnormalities.
• Providing necessary training specific to Lean Transformation tools and methodology.
• Helping update and maintain visual performance tools, including mission control and MDI boards
• Following up on action plans
• Assisting all teams as needed to ensure improvements are made and sustained

Executing key activities as part of Lean Transformation and daily management including tasks such as:

• Support value stream analyses events.
• Conducting cycle time analyses, time studies, line balance improvements, workplace analysis improvement.
• Creating and implementing standard work and teaching/coaching line leaders to do the same.
• Implementing / coaching the use of cell control boards and other visual management tools
• Lead, coach and assist teams in problem solving activities.
• Resolving issues after continuous improvement events to achieve desired state.

To support the launch of all activities needed to incorporate Lean Transformation and daily management into the Value Stream culture; includes:

• Assisting in identifying on-going training needs
• Supporting communication of the direction of Lean Transformation and daily management initiatives to employees
• Utilize change management model.
• Ensure high levels of engagement for continuous improvement events participants.
• Drive change through coaching of employees and leaders to drive lean behaviors, principles and practices.

Track all changes/improvements made to provide assurance that changes are effective and lasting, includes:

• Examining and evaluating the areas after improvements are implemented
• Posting/updating results to the Mission Control boards
• Reviewing new procedures/controls and appraising the efficiency and effectiveness of operations, and working with the Operational Excellence Manager, Site Leader, Department Managers and Supervisors to resolve any issues that might arise during implementation and/or maintenance phases
• Monitor and report on key metrics
• Supports and meets Departmental, Plant and Corporate EH&S goals. Works in a safe and efficient manner.
• Other duties as identified by the Value Stream Coach to further the site's Lean Manufacturing initiative

• Bachelor of Science Degree in a related discipline, preferably an engineering or supply chain degree
• Minimum of 4 years of documented world class lean manufacturing/transactional/functional experience.
• Experience with distribution, warehousing and/or logistics facilities a plus.
• You would ideally have some level of understanding of WMS, TMS and ERP systems
• Excellent written and oral communication and presentation skills with the ability to speak and communicate effectively with various audiences at the site level.
• Strong interpersonal and high-performance team building skills, with ability to develop collaborative relationships, influencing up, down and across organizational lines.
• Ability to effectively facilitate a group's activities and discussions using a defined process.
• Must be viewed credibly as either an informal leader or a positive influencer of change
• Ability to prioritize and handle multiple priorities in a fast-paced and changing work environment.
• Able to influence, persuade, convince and facilitate lean culture change in an environment with varying acceptance.
• Knowledge of personal computer applications required (Excel, Word, Visio, and PP). Excellent Team Facilitation Skills.

Allegion is a great place to grow your career if:

• You're seeking a rewarding opportunity that allows you to truly help others. With thousands of employees and customers around the world, there's plenty of room to make an impact. As our values state, \"this is your business, run with it\".
• You're looking for a company that will invest in your professional development. As we grow, we want you to grow with us.
• You want a culture that promotes work-life balance. Our employees enjoy generous paid time off, because at Allegion we recognize that you have a full life outside of work!
• You want to work for an award-winning company that invests in its people. Allegion is proud to be a recipient of the Gallup Exceptional Workplace Award for the second year in a row, recognizing our commitment to employee engagement, strengths-based development, and unlocking human potential.

• Health, dental and vision insurance coverage, helping you \"be safe, be healthy\"
• A commitment to your future with a 401K plan, offering a 6% company match and no vesting period
• Tuition Reimbursement
• Unlimited PTO
• Employee Discounts through Perks at Work
• Community involvement and opportunities to give back so you can \"serve others, not yourself\"
• Opportunities to leverage your unique strengths through CliftonStrengths testing and coaching

Apply Today! Join our team of experts today and help us make tomorrow's world a safer place! Not sure if your experience perfectly aligns with the role? Studies have shown that some people are less likely to apply to jobs unless they meet every single qualification and every single preferred qualification of a job posting. At Allegion, we are dedicated to building a diverse, inclusive, and authentic workplace. So, if you're excited about this role but your past experience doesn't align perfectly with every item in the job description, we encourage you to apply anyway. You may be just the right candidate for this role.

We are looking for a BC/BE Hematologist Oncologist to join an excellent group in Western Texas:- Permanent, employed position- Beautiful, state-of-the-art facilities and technology- Reputable group with high physician retention and continued growth opportunities- Monday-Friday schedule with favorable call schedule- Highly competitive compensation/benefits, including sign-on and relocation assistance, generous PTO and loan repayment- Teaching opportunities availablePlease contact Alex James at or call/text Alex at if you are interested in learning more!

Locations : Atlanta | Austin | Boston | Brooklyn | Chicago | Dallas | Denver | Detroit | Durham | Houston | Los Angeles | Miami | Minneapolis | Nashville | New York | Philadelphia | Pittsburgh | San Diego | San Francisco | Seattle | Summit | Washington

Who We Are

Boston Consulting Group partners with leaders in business and society to tackle their most important challenges and capture their greatest opportunities. BCG was the pioneer in business strategy when it was founded in 1963. Today, we help clients with total transformation-inspiring complex change, enabling organizations to grow, building competitive advantage, and driving bottom-line impact.

To succeed, organizations must blend digital and human capabilities. Our diverse, global teams bring deep industry and functional expertise and a range of perspectives to spark change. BCG delivers solutions through leading-edge management consulting along with technology and design, corporate and digital ventures - and business purpose. We work in a uniquely collaborative model across the firm and throughout all levels of the client organization, generating results that allow our clients to thrive.

Practice Area

The Corporate Finance & Strategy Practice (CFS) combines rich expertise in corporate strategy concepts with a management methodology designed to create sustainable value-add for BCG clients. Our team provides extensive experience in planning and implementing corporate transactions including merger & acquisition deals and divestitures. We deliver analytic approaches that allow senior management to effectively deal with challenges such as generating growth, managing a portfolio of assets, forming a world-class finance organization, understanding risk, and responding to the way capital markets assess companies today. Taking swift action in turning around and restructuring a business for long-term survival is also part of our offering.

What Youll Do

BCG is looking for an Expert Consultant to join our CFO Excellence team. Our CFOx team partners with CFOs to tackle their most pressing challenges - reimagining finance operating models for peak efficiency, unlocking the power of advanced analytics and AI, and driving transformative value across the organization. With unmatched experience across industries, our team helps finance leaders modernize systems, enhance transparency, and position their finance functions as catalysts for strategic success. Join us to shape the future of finance and make a lasting impact.

As an Expert Consultant, you will be integrated into a BCG team to leverage your deep expertise on projects that reshape finance functions. You will be given end-to-end responsibility for a workstream within a BCG project. You will work closely with clients to understand their issues, create strategies for change, and win buy-in for your recommendations, while also collaborating with colleagues on complex client issues. You will provide deep expertise and insight to clients and help build your expertise area within BCG. A majority of your time will be focused on supporting and executing case work.

The Expert Consulting Track (ECT) is vital to BCG’s ability to successfully meet our clients’ demand for deep expertise and advanced technical capabilities. Experts deliver next-level impact for BCGs most complex and cutting-edge client challenges. Experts focus on developing BCGs thought leadership, commercial capabilities, and intellectual property assets; and their work is essential to our delivery model. Working alongside our traditional and specialty consultants to bring the ‘best of BCG’ to our clients, Experts come from diverse backgrounds, with expertise often gained outside of BCG in industry, academia, or specialized consulting. Consulting work is varied and rigorous, much of it performed at our client sites. Projects can vary in length, size, and location, depending on the client’s challenge. Because our clients operate all over the world, you may travel internationally.

What Youll Bring

• 5+ years of experience in finance across topics such as finance function effectiveness, CFO advisory, FP&A, process and policy, technology, operations, organizational structure and strategy, and/or transformation .
• Previous consulting experience is required.
• Proven experience working on finance transformation programs including: operating model redesign, process re-engineering, technology enablement, shared services, finance technology, budgeting, management reporting and Business Intelligence, core accounting, tax, treasury, internal audit, AI and machine learning.
• Experience in finance technology stacks, process optimization, and data architecture to deliver scalable and efficient solutions.
• Strong consulting skill set with a demonstrated willingness to learn and grow.
• Entrepreneurial, driven, and proactive mindset with a strong work ethic.
• Collaborative working style with a proven ability to team effectively across BCG and with clients.
• Ability to build trust and rapport with clients by deeply understanding their business and challenges.
• Advanced degree in a related field (preferred).

Additional info

What We Offer:

At BCG, we care about our people, and offer best in class benefits to support you personally and professionally including:

• An opportunity to work organically across disciplines and across BCG, we offer a unified and unrivaled opportunity that combines strategic thinking with hands-on applications.
• A unique experience to work alongside a team of passionate and driven problem-solvers with a mission to deliver innovative and valuable digital solutions in a supportive environment.

For U.S. Applicants:

The base compensation for this role is $190,000 in USD.

In addition to your base salary, you will also be eligible for an annual discretionary performance bonus and BCGs Profit Sharing and Retirement Fund (PSRF) contribution. BCG also provides a market leading benefits package described below.

At BCG, we are committed to offering a comprehensive benefit program that includes everything our employees and their families need to be well and live life to the fullest. We pay the full cost of medical, dental, and vision coverage for employees - and their eligible family members.* That’s zero dollars in premiums taken from employee paychecks. All our plans provide best in class coverage:

• Zero dollar ($0) health insurance premiums for BCG employees, spouses, and children.
• $10 (USD) copays for trips to the doctor, urgent care visits and prescriptions for generic drugs.
• Dental coverage, including up to $5,000 (USD) in orthodontia benefits.
• Vision insurance with coverage for both glasses and contact lenses annually.
• Reimbursement for gym memberships and other fitness activities.
• Fully vested retirement contributions made annually, whether you contribute or not.
• Generous paid time off including vacation, holidays, and annual office closure between Christmas and New Years.
• Paid Parental Leave and other family benefits such as elective egg freezing, surrogacy, and adoption reimbursement.

*Employees, spouses, and children are covered at no cost. Employees share in the cost of domestic partner coverage.

To learn more about our employee benefit please check our Benefits page.

Boston Consulting Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity / expression, national origin, disability, protected veteran status, or any other characteristic protected under national, provincial, or local law, where applicable, and those with criminal histories will be considered in a manner consistent with applicable state and local laws.

Hospital in Tallahassee, FL is seeking a dynamic Vascular Surgeon to join the Florida Panhandle's premier Cardiology Group.

This surgeon will be the second Vascular Surgeon in this group, and the 6th in Tallahassee, and will be tasked with building the Vascular clinic for medical group.

The group currently has 12 Internal Medicine Physicians and 21 Cardiologists representing General, Cardiothoracics, Interventional and Electrophysiology.

Single Specialty Group Employee w/ Partnership .  1:5 Call Ratio.   Annual Salary.  Excellent payor mix.  Opportunities to buy into joint surgical facilities.  Newly renovated, dedicated Vascular Labs.  Level II Trauma Center.  

Hospital in Tallahassee, FL is seeking a dynamic Vascular Surgeon to join the Florida Panhandle's premier Cardiology Group.

This surgeon will be the second Vascular Surgeon in this group, and the 6th in Tallahassee, and will be tasked with building the Vascular clinic for medical group.

The group currently has 12 Internal Medicine Physicians and 21 Cardiologists representing General, Cardiothoracics, Interventional and Electrophysiology.

Single Specialty Group Employee w/ Partnership .

1:5 Call Ratio.

Annual Salary.

Excellent payor mix.

Opportunities to buy into joint surgical facilities.

Newly renovated, dedicated Vascular Labs.

Level II Trauma Center.

Seeking a Non-Invasive Cardiologist to join a private group in southern California! Opportunity to replace a retiring with an existing patient panel.

Beautiful location with easy access to Joshua Tree National Park and other parksFull time M-F.  Call schedule to be determined.  take on an existing patient panel from a retiring physician.  NexGen EMR.  Join 1 interventional Cardiologist and 1 Nurse Practitioner.  Mix of inpatient and outpatient work.  Full benefits.  Group serves two nearby hospitals.  Procedures in the morning and office in the afternoon.  

Urologist opportunity nestled in the Rocky Mountains.

An outdoor lovers' dream location for hiking, skiing and snowboarding.

A great community with affordable housing and excellent schools.

Affordable housing.  Hospital coverage a couple times per month.  Multi-specialty Group.  Rapidly Growing Population .  Family-oriented community.  Easy access to state and national parks.  

Join a growing Urology practice in Southern Indiana.

This physician owned group focuses on all medical issues related to the urinary tract in women and men.

They have expertise in male reproductive system, hormone replacement therapy, and prostate problems.Single Specialty Group Employee w/ Partnership, Traditional.  1:4 Call Ratio.  Competitive Salary OR Income Guarantee.  Quality Bonus production incentives.  Signing Bonus available, contact us for details.  Relocation Bonus available.  CME time and money available.  Retirement plan provided.  A surgical center.  Dornier Compact Delta lithotripsy unit .  

Partnership opportunity located in one of the best places to raise a family! A growing boom town with metro population in excess of 250,000.

This Eastern Iowa city has it all, with all of the Midwest's splendor on display.

Competitive package and opportunity to join a group of 80 plus providers practicing in new state-of-the art medical facility.Multi Specialty Group Employee w/ Partnership, Traditional.  Assigned Call.  Salary Available, contact us for details.  WRVU and Quality Bonus production incentives.  Signing Bonus possible, contact us for details.  Relocation Bonus available.  CME time and money available.  Ancillary income available from Diagnostics.  Eastern Iowa partnership opportunity.  Unique Midwest Metro partnership opportunity   Established practice with sub-speciality support   

This well-established organization has a need for a full-time Psychiatrist.

The position will be a split of inpatient and outpatient work.

Join our progressive Hospitalist team and our robust outpatient Behavioral Medicine team.

The site is in a lovely area of Washington State where you can enjoy endless outdoor recreation.

They are offering an excellent employed package and more.

Interested physicians are encouraged to apply today.Multi Specialty Group Employee, Traditional.   Annual Salary.  Loan Forgiveness available.  Signing Bonus available, contact us for details.  Relocation Bonus available.  Easy drive to Seattle or Spokane.  Beautiful views of the Cascade Mountains.